Steps to Integrate Google Sheets API
There are few ways to connect the API. We request two outputs right now: Service file and API Key.
These are the following steps that you need to follow for successful integration
Turn on the Google Sheets API and get credentials for your project.
- Visit https://console.developers.google.com
- Create a new project if you don’t have one or if you don’t want to mix it with a project that you already have
- Tap on Enable APIs And Services
- Search for Google Sheets API
- Enable it
- Now tap on Create Credentials
- Use these settings and click on next
- Use these settings, you can add any name
Click on – Create and continue
- Now use these settings
Click in Done
- Edit the Service Account created
Go to the top tab “Keys” and click to “ADD KEY”, select JSON type
A file will be downloaded after clicking continue to rename it to credentials.json
- Send the file to us and telling which email was used
- Create a google spreadsheet and share it with us
- Go back to your Credentials and under “+ Create credentials”, create an API Key
Copy the number and send it to us