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
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_akkauntaSelect your service account and go to its settings.
Creating a JSON file and downloading it to the PC
Go to the KEYS tabThen 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]