Gatsby Starter Google Sheets
Kick off your project with this boilerplate. This starter ships with the main Gatsby configuration files along with the gatsby-source-google-spreadsheet you might need to get up and running blazing fast with the blazing fast app generator for React.
🚀 Quick start
Create a Gatsby site.
Use the Gatsby CLI to create a new site, specifying the default starter.
# create a new Gatsby site using the starter gatsby new gatsby-site https://github.com/harshil1712/gatsby-starter-googlesheets
Navigate into your new site’s directory and start it up.
Open the source code and start editing!
Before running the development server you will need to add credentials to the .env file.
SPREADSHEET_ID=<YOUR_SPREADHEET_ID> CLIENT_EMAIL=<SERVICE_ACCOUNT_EMAIL> PRIVATE_KEY=<YOUR_PRIVATE_KEY>
You can get the
SPREADSHEET_IDfrom the URL of your sheet,
https://docs.google.com/spreadsheets/d/<SPREADSHEET_ID>/edit#gid=12345. You will have to create a service account which will provide you with the service account email id and a private key. To know more about creating service account you can visit here. After creating a service account share your sheet with edit permission with the given email id.
Your site is now running at
Note: You'll also see a second link:
http://localhost:8000/___graphql. This is a tool you can use to experiment with querying your data. Learn more about using this tool in the Gatsby tutorial.
gatsby-sitedirectory in your code editor of choice and edit
src/pages/index.js. Save your changes and the browser will update in real time!