Data transfer Typebot to Google Sheets. ApiX-Drve Hello everyone! My name is John.
Today, I will tell you how to set up integration to transfer new data from Typebot to Google Sheets. This is necessary to automatically transfer new data from Typebot to other systems. For example, in Google Sheets, you can add new rows and conveniently interact with them in the future.
Now let's move on to the setup. First, you need to create a new connection. Next, select the data source system: Typebot.
Now, select the action: get data. At this stage, you need to create a virtual Typebot account in the ApiX-Drve system. In this window, you can change its name or just click continue.
When the connected account appears in the list, select it and click continue. At this stage, you see the URL for receiving data. It is to this URL that new data from Typebot will arrive.
In order to continue setting up, copy the URL and go to your Typebot personal account. Next, go to the bot settings, add another block from the integration section, and select "Webhook. " Click on it and paste the copied URL.
After this, connect the blocks together. Next, you need to generate sending test data to the specified URL. To do this, click "Test the request.
" After successful submission, save the changes. Next, return to the ApiX-Drve system and continue configuration. At this stage, you can set up a data filter.
In this case, there is no need for this, so just click continue. Now you see the data we just generated. If there is no data at this stage, try following the steps described earlier.
If you are satisfied with everything, click continue. At this point, setting up the Typebot data source has been successfully completed. Now you need to move on to setting up the data destination.
Choose the system: Google Sheets. Next, select an action: add row. At this stage, you need to connect your Google Sheets account to the ApiX-Drve system.
In this window, you need to specify the login and password of your Google account. Be sure to check all the boxes. When the connected login appears in the list of active accounts, select it and click continue.
At this stage, you need to select the file and sheet to which new rows will be added. Now you see Google Sheets columns to which you can assign variables from Typebot. In order to do this, click in the field and select a variable from the drop-down list.
Please note that you can use not only variables from the drop-down list but also enter data manually. When all required fields are filled in, click continue. At this point, you see an example of the data that will be sent to Google Sheets as new rows for each new data from Typebot.
If you are not satisfied with something, click edit, and you will go back a step. In order to check the correctness of the settings, click send test data to Google Sheets. After successful submission, go to Google Sheets and check the result.
If you are satisfied with everything, return to the ApiX-Drve system and continue setting up. This completes the setup of Google Sheets as a data destination. Now you need to enable auto-update and select an update interval, for example, once every 5 minutes.
That's all! I wish you successful integration settings and good luck!
