Table of Contents

How to insert a row to Google Spreadsheet by Zapier

Alexander Gao Updated by Alexander Gao

Prepare Landbot
  1. First we have to build a bot flow in your bot to collect the information you need to send to Zapier, like name, email, age, etc.

The information that we collect, will be stored in variables, that we will sent to Zapier.

As in the example below, we are storing the name input in the variable @name, that we will use later.

  1. Then let's set a Trigger automations block.

Create Zap trigger
  1. After set a trigger automation block, let's open Zapier:

  1. We need to do is click on the button Make A Zap:

  1. Search the option Webhook (webhooks by Zapier) and select it:

  1. On the dropdown Trigger Event, choose the option Catch Hook and press continue:

  1. Copy the Webhook URL, so that we can use it in the next steps, and press CONTINUE.
  1. On the following screen, don't press the Test trigger button yet (we will do it after a few more steps).
Prepare Landbot request to Zapier
  1. Go back to Landbot, and paste in the Trigger automation block the URL that you have copied from the Zap.
    Please add it to the URL field in the Trigger automation block.
  1. Scroll down and go to the Set data (variables) to be sent section of the Trigger automation, where you can set test values:
  1. And click on Test webhook trigger button:
  1. If you scroll down, you will see the response from Zapier:

  1. If you see the Status code as 200, and the status as "success", this means that our request was successfully sent.

Check the data of the request (test) in Zapier
  1. Go back to Zapier.
  2. Click on the button Test trigger, to check the information that we have sent from the Webhook Test:

  1. Once we press Test trigger you will see the page below, with the variables and values we used in the test:
As you can see, the @name, @email, and @age are the same as we sent to Zapier:This is how the trigger works, we send variables to Zapier, they receive, and when we try to test it as we did in step 15, it will be shown.

After we turn on Zap, the whole progress will be doing automatically.
  1. So far the part of trigger is done.
    However, after the trigger we have to set up the actions we want to trigger on Zapier. Please keep in mind that this set up is done in your Zapier account, not in Landbot.

Now let's press continue

Insert a new row to Spreadsheet

The second part of this integration is setting up an action triggered by a Zap.

As we said before, we will use Google Spreadsheet as an example.

  1. Choose Google Sheets:

  1. Then set the action event you need to use. We will use "Create Spreadsheet Row" in our example.
  1. Then log into your Google Account:
  1. Then we must select the Spreadsheet, the sheet, and finally the variables we want to use.
    We have added as columns to add the information the values "name", "email" and "age".
  1. Finally we can test our trigger and action integration!

  1. Click on Test & Continue,

  1. A simple test is done, but we still have to check our spreadsheet to see if it's what we want!
Webhook is a premium function of Zapier, unless you can turn on it, otherwise just click on test the request in Trigger automation block of Landbot won't send the information right to the Sheet.

Here are they! Exactly what we want to put in.

How did we do?

Zapier Integration Dashboard

How to generate a document with PDFMonkey by Zapier

Contact