Use Multiple Google Sheets Simultaneously

To use multiple Google Sheets APIs simultaneously, follow these steps:

Enable Google Sheets API in Google Console

  1. Open to the google console on your browser.On your console click on Navigation Menu>API and Service>click on ‘+Enable APIs and Services’.

  2. Search for google sheet

  3. Enable the Google sheet API

After Enabling the google sheet API, copy the link of googlesheet, make sure it is shareable.

Generating Credentials

To generate credentials:

  1. On console, API and SERVICES click on credentials.

  2. In Service account section you will see yor default App Engine default service account click on it.

  3. In App Engine default service account click on keys>ADD keys>Create New keys. A json document will be downloaded. Rename the json file as `Credentials.json`(NOTE: Do not expose this file make sure to include it in .gitignore)

Include the credentials.json in working repository.