Illustrating how to use data from Google Sheets in eleventy (11ty).
- Google Sheets cscie114-demo-data
- google-spreadsheet npm package
This will need some setup on your end. Create your own copy of the spreadsheet. Follow instructions for setting up authentication on the Google side.
Create an .env file with the following entries:
GOOGLE_SPREADSHEET_ID="<your spreadsheet id>"
GOOGLE_SERVICE_ACCOUNT_EMAIL="<email goes here>"
GOOGLE_PRIVATE_KEY="<key goes here>"
And then run:
npm install
npm run start