Set up a connection to Google Sheets

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

Google Sheets documentation: API guide, Authentication
Additional reference: Supported Google Sheets APIs

Contents

• A. Set up a Google Sheets connection
• B. Describe the Google Sheets connection
• C. Supply required Google Sheets account information
• D. Edit advanced Google Sheets settings
• E. Test the connection

A. Set up a Google Sheets connection

Start establishing a connection to Google Sheets in either of the following ways:

• From the Resources menu, select Connections. Then, click + Create connection at the top right.
  – or –
• While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination/lookup.

In the resulting Application list, select Google Sheets.

The Create connection pane opens with required and advanced settings.

B. Describe the Google Sheets connection

Edit the General settings specific to your account and this connection resource.

Name (required): Provide a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.

Application (required, non-editable): A reminder of the app you’re editing.

C. Supply required Google Sheets account information

The Application details section contains settings for Google Sheets authentication.

Configure scopes (required): Scopes are permissions that the Google Sheets API defines to limit the access to your account. The following scopes are available:

1. Click the Configure scopes button.
2. To access both of the scopes in the API, click the » button.
   – or –
   Check the scope you want to add, and click the > button.

3. Click Save when you’re ready to leave the editor and finish setting up your connection.

D. Edit advanced Google Sheets settings

Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Google Sheets connection.

E. Test the connection

Once you have configured the Google Sheets connection, you have a couple options for continuing:

• Save & authorize – Click this button to test the connection and commit it so that it will be available to all integrations for your account. (If you created it within a flow it will be applied to the current source or destination app as well.)
• Cancel – Click to exit without saving any new changes

When you click Save & authorize, Google prompts you to sign in.

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.

The new connection is now successfully added to your account. If you created it within a flow, it is applied to the current source or destination app. Otherwise, you can proceed to register the connection with an integration.

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.

Need more help?

Check out these related topics and community posts:

• Import example: Add rows to a Google sheet
• HOW TO: Populate data into Google Sheets
• HOW TO: Extract data from Google Sheets and get data rows into name/value pairs