Google Spreadsheets connection information

summary

This is the help page for setting up Google Spreadsheets connection information.

There are two ways to set up Google Spreadsheets connection information 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
* Authorization to the email address of the service account in the source and destination spreadsheet sharing settings

Set JSON Key

1. Refer to Obtaining a Google Cloud J SON 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 connection setting creation 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.

4. Enable API.

Share settings for source and destination spreadsheets, with permissions granted to the service account's email address

1. Finally, open the spreadsheet that will be the source and destination of the transfer.

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.
   (Please select a viewer for the source or an editor with write permission for the destination.)

Reference: Official Documents