Connection Configuration for Google Sheets

Prev Next

summary

This is the help page for Connection Configuration in Google Sheets.

There are two ways to set up Connection Configuration for Google Sheets in TROCCO: using a Google account or using a service account.

Preparation before transfer

If you wish to use a service account, you will need to do the following

  • Set JSON Key
  • Enable API
  • Data Source and Data Destination Spreadsheet Sharing Configuration, granting permissions to the email address of the service account.

Set JSON Key

  1. Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key. It is not necessary to grant roles to service accounts.

  2. Note the email address of the service account.

  3. Copy the entire contents of the obtained JSON Key and paste it into the JSON Key form on TROCCO's Create Connection Settings screen.

Enable API

  1. Access the GCP Console and select your project.
    (If you have not created a project, please do so in advance.)

  2. Access the API library.

  3. Click on Google Sheets API.

image.png

  1. Enable API.

image.png

Data Source and Data Destination Spreadsheet Sharing Configuration, granting permissions to the email address of the service account.

  1. Finally, open the spreadsheet that will be the Data Source and Data Destination.

  2. Open Share in the upper right corner of the screen.

  3. Paste the email address of the service account into the user input field.

  4. In the Authorization Selection box on the right, select the required authorization.
    (Select the Viewer for Data Source or the Editor with Write permission for Data Destination.)

Reference: Official Documents