Google Sheets is a web-based application that enables users to create, update, and modify spreadsheets and share data online in real-time.
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. |
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.
-
Click Scope.
-
To access all of the scopes in the API, click the » button.
– or –
Check the scopes you want to add and click the > button.
-
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. |
-
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:
If so, click Advanced, and then click Go to integrator.io (unsafe) to allow the exception and continue.
-
After signing in, review the permissions for the integration and click Allow.
Caution
Caution: Depending on your Google permissions, you may see the following screen when attempting to sign in:
{{img class=screenshot-frame id=3}}
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.
-
Related topics and community posts: