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

1. 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

2. Start developing.

   Navigate into your new site’s directory and start it up.

   cd gatsby-site/

3. 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_ID from 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.

   gatsby develop

   Your site is now running at http://localhost:8000!

   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.

   Open the gatsby-site directory in your code editor of choice and edit src/pages/index.js. Save your changes and the browser will update in real time!