Sending data to Google Sheets
The Google Sheets component (beta) can only be used to transfer data to a document.
You can watch all the steps for sending data to Google Sheets in the video tutorial:
It works on all platforms.
If you registered an account with Google, create a password to log in to Botmother before linking Facebook. The password is set on the bots page in the Profile Configuration section. After that, save the changes, log out of your account, then log in using your username and password.
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.
If you need a wide variety of actions working with sheets, you can use integrator services such as Zapier or set up Data Transfer API.
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.