What are the advantages of integration with Google Sheets?

Connecting your Google Sheets account with the Botmaker platform is useful to have your databases accessible from your bot. This way, you will be able to have the information you need to communicate always updated. Note that the initial steps for the connection of this tool are the same for both Bot Designer and intent chatbots. See the step-by-step integration:

Step 1: Go to Menu>Settings>Integrations (https://go.botmaker.com/#/integrations/connections) and select Google Sheets. Click on Connect.

When you click on it, this screen appears with an email to copy.

You can copy it in the conventional way or click on the “Copy” button.

This email must be pasted into the Google Sheet that you want to give access to.

In each Google Sheet file there is a “Share” button.

You must click and paste the email address.

We recommend granting “Editor” access for cases where information needs to be added to a spreadsheet.

Please note that you will need to grant that email address access to each Google Sheet file you want to use.

The mailbox is always located in the “Channels and Integrations” > “Other Platforms” > “Google Sheets” menu.

Google Sheets has two actions within the platform, each with a specific function:

• Create record in Google Sheets: Allows you to collect user data from Botmaker using variables and transport it to a Google Sheet spreadsheet.
• Incorporate data from Google Sheets: Allows you to verify if the value given to a variable matches a value within the Google Sheets document, send information from that row to Botmaker to use it as a variable value.