Google Sheets

In this doc, we will cover how to setup a Connection to Google Sheets.

Prerequisites

  • Google Sheets API Access credentials (JSON) Ref

The high level steps boil down to:

  1. Create a Google Cloud project with access to Google Sheets API.
    Note that you may need to enable the Google Sheets API and Google Drive API in your project.
  2. Create 'Service account key' credentials in that project
  3. Download the JSON key type
  4. Share the Google Sheet with the email address in the JSON key downloaded
  5. Inert the contents of the JSON key file into the 'credentials' field

Create new Google Sheets connection

28802880

Figure 1

See Figure 1 above.

12161216

Figure 2

In Figure 2 above:

  • Connection Name (required): The name to identify this connection with, such as *Sheets Read Connection
  • Choose Credentials (required): Choose from existing credentials or create new credential (in JSON) for connecting to Google Sheets if 'Required Credentials' checkbox is selected.

📘

Share the Spreadsheet with the Email in the Service Account

In order for Ascend to access private spreadsheets, the spreadsheet must be shared with the email address that was generated as part of the service account. The credential should have the email in it. In the case of the screenshot below, the email address is [email protected]eaccount.com

13201320

Figure 3

In Figure 3 above, create new credentials if required Credentials checkbox was selected and you do not want to select from the already created ones.

10021002

Figure 4

In Figure 4 above, use TEST CONNECTION button to check whether Google Sheets credentials are correctly configured and If SUCCESS, click CREATE AND USE CONNECTION.


Did this page help you?