Articles in this section

Set up a connection to Google Sheets

Naga Sri Hari Gonaboyina
Updated

Google Sheets is a web-based application that enables users to create, update, and modify spreadsheets and share data online in real-time. 

Set up a connection

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings:

Setting Instructions
Name your connection * Enter a clear and distinguishable name.
Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.
Scope *

Scopes are OAuth 2.0 permissions that the Google Sheets API defines to limit access to your account.
Fetch data How to configure scopes

Tip: This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see OAuth 2.0 auth universal connector documentation.

  1. Click Scope.
  2. To access all of the scopes in the API, click the » button.
        – or –
    Check the scopes you want to add and click the > button.
  3. Click Save.

The following scopes are available:

Scope Definition
https://www.googleapis.com/auth/spreadsheets.readonly Allows read-only access to the user's sheets and their properties.
https://www.googleapis.com/auth/spreadsheets Allows read/write access to the user's sheets and their properties.
  1. Click Save & authorize to commit your changes and proceed to sign in with Google Sheets.
Caution: Depending on your browser history and the permissions you’ve granted, you may see the following screen when attempting to sign in:
google-warning.png
If so, click Advanced, and then click Go to integrator.io (unsafe) to allow the exception and continue.
GooglePermissions.png
  1. After signing in, review the permissions for the integration and click Allow.
Caution: Depending on your Google permissions, you may see the following screen when attempting to sign in:
If so, you must change your Google third-party application permissions before you set up a connection. If your permissions are managed by your company, you may need to speak to your security, compliance, or IT department before creating the connection.

Additional references

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.