Skip to content

henry74/googlesheets-graphql-server

Repository files navigation

Note: This is no longer being updated. Please see https://github.com/henry74/gsuite-graphql-server for the latest updates

Simple GraphQL API for Google Sheets

Setup

  1. Create a new Google project and enable Google Calendar API
  2. Create OAuth 2.0 client ID credentials
  3. Copy Client ID and Client Secret into .env
# See .env.example for required environment variables

Generate token manually (can also be done through API)

yarn authorize

API Usage

Terminal/CLI

yarn start # start graphql playground on http://localhost:4000

Dockerfile (after building)

docker run -d \
   -p 4001:4000 \
   -e GOOGLE_OAUTH2_CLIENT_ID="123412341234-randombunchofcharacters.apps.googleusercontent.com" \
   -e GOOGLE_OAUTH2_CLIENT_SECRET="1234asdf1234" \
   -e GOOGLE_OAUTH2_REDIRECT_URL="urn:ietf:wg:oauth:2.0:oob" \
   -e TOKEN_PATH=./token.json \
   your/image:latest


**spreadsheetId** is located in the spreadsheet URL: `https://docs.google.com/spreadsheet/d/`spreadsheetId`/edit`

Click schema tab within graphQL playground for details

About

Use graphQL to access Google sheets (read only for now)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published