Google Sheet

Updated 4 months ago by Cris Villar

Learn how to configure our Google Sheet integration and perform complex actions without a single line of code: Sheets is now your Landbot's favorite database!

The Google Sheet integration is only available on the Professional and Business plans.
We always recommend creating the Sheet before completing the integration. The style of the sheet needed will vary depending on the action define on the block configurator!
The block configurator keeps loading after selecting the sheet? This means there are no columns in the sheet selected. Move on to your Drive and create some to complete the integration!
As usual, the integration will be activated as the block itself is triggered on the flow so be careful with where you place it! (After asking for the related data but soon enough to make sure visitors go through it!

  1. To configure a Google Sheet integration click on Integrations in the chatbot builder and then on Google Sheets:
  2. Now you need to connect your Google account. Click on the button and you'll be redirected to Google to enter your email, password and give permissions to the app to manage data:
  3. Next, select from the first drop-down the spreadsheet you want to be working with, as well as the specific sheet where your data is:
  4. Now, select the Action. We'll explain now what does each action help you with and how to configure each one of them:
    1. Insert a new row in a sheet. The classic one. This action sends data collected by Landbot to your Sheet. All you have to do is:
      1. Select which column of the spreadsheet (left) corresponds to which field collected by Landbot (right).
        In the example below we're going to send the variable @name to the column "Name".
    2. Update a row in a sheet. With this Action you'll be able to:
      1. Search for a value collected by landbot within a certain column of the spreadsheet (e.g. "a name").
      2. Update another value (column) in the same row with another field collected by Landbot.
        1. Success. Path triggered then the name provided by the visitor exists in the Sheet, so Landbot was able to add the email next to it.
        2. Fail. Path triggered when the name provided doesn't exist.
    3. Get data from a sheet. With this action you can:
      1. Search for a value collected by landbot within a certain column of the spreadsheet (e.g. "email").
      2. Send back to the chat the info of another column in the same row (e.g. "address).
        1. Success. Path triggered then the name provided by the visitor exists in the Sheet, so Landbot was able to add the email next to it.
        2. Fail. Path triggered when the name provided doesn't exist.

How did we do?