Getting the table ID or public_key

We go to your spreadsheet and copy the string from the address bar, as shown in the screenshot. Save it for future use.

Example string from the screenshot:
15VBEqphERwld9gkfQ-DOOPqKa9x2cCw0djDKG1nkxyA

We issue access keys for the service account

If you do not have a service account created or it has been created incorrectly, go to the account creation step: https://bot-t.com/faq/HELP/sozdanie_servisnogo_akkaunta

Select your service account and go to its settings.

Creating a JSON file and downloading it to the PC

Go to the KEYS tab
Then click add key and select JSON format

Open the file and copy the contents

Copying all content for further use

We are filling in the previously created keys and table number

Fill in the data as shown in the screenshot. Do not delete any symbols or add anything.

After saving, you have successfully set up the integration!

Granting permissions on the table to the service account

Very important step!
Choose how to grant access as shown in the screenshot. And paste the email of your service account into the search field.

In my case, it is:

[email protected]