Sending data to Google Sheets
The Google Sheets component (beta) can only be used to transfer data to a document.
It works on all platforms.
We recommend configuring the component immediately so that later it was not necessary to be edited, because a new sheet will be created when editing, the existing one won’t change. Users data will be transferred to a new sheet after the component settings are changed.
To avoid problems with operations in Google Sheets component, we do not recommend editing the table created in it. In particular, you should not delete sheets, edit columns, etc. In case of problems due to changes to the table, you need to create the component again.
We do not recommend sending broadcasts with a screen where the sheet is located. In the case of such a broadcast, several copies of the sheet will appear on your Google drive.
Setting up Google Sheets:
1. Click Link Google Account button, select your account, give Google full permissions to continue.
If your Google account is already linked, unlink and link it.
2. Open the builder and add Google Sheets component in the place in the bot where the variables will be passed to the sheet.
In Sheet name field, write the name of the table that will be automatically created on your Google drive later.
3. In the component settings, fill in Key and Value fields.
In Key, add the names for the columns in your sheet, enter the variables in Value. These variables data should get into the sheet.
After transferring data from the user, the sheet will appear on Google Drive. The sheet columns will have the same names as Keys, and the values of the corresponding variables will be in the rows below.
The first column Record date is created and filled in by the system automatically.
You can watch all the steps for sending data to Google Sheets in the video tutorial: