All Categories ​>​ Landbot v3 (Bricks) ​>​ Creating a Landbot (v3) ​>​ Builder (v3) ​>​ Integrations > Google Sheets

Integrations > Google Sheets

Updated 1 week ago by Pau Sanchez

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!
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:

  1. 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:
  2. Now, select the Action top perform. 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. "id").
      2. Update another value (column) in the same row with another field collected by Landbot. (e.g. "phone")









        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. "name").




        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.
FAQs & Troubleshooting:

The data is uploading to the wrong column

  • Once the integration is set up in Landbot, any column move or name change in the header of a column, will make the integration stop working properly. After any of this changes the Integration has to be redone from scratch with a new Google Sheets block integration

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!

The method "Get Data From a Sheet", returns a similar value but not the exact one that I was looking for.

  • Currently the Get Data From a Sheet makes a search based on a "Contains" condition. The fix to this problem will be to add another column with the same value, for example, email, but with the "|" symbol like |email@email.com. Use it in the Google Sheet Integration as well. This way, the search will contain all the email address, not just a part of it.

I've created a copy of the sheet and the data isn't uploading in the new sheet

  • If you create a new sheet (or edit anything in the sheet integrated already) but you don't update (and save) the settings in the Google sheet block of your integration, the integration won't work as intended or even might not upload any information at all.

How did we do?