How to integrate data from your bot into Google spreadsheet?

how to integrate bot data into Google Sheets
how to integrate bot data into Google Sheets

Published by:

Eran Soroka

In the previous post, we learned how to build a data collection bot – to define the collected data and to store it. Today, we’ll go to the next stage – chatbot integration with Google Sheets.

At, we enable integrations of the collected data into various CRMs and databases, but let’s start with a common one – Google Spreadsheet.

Via Zapier, you can send all the data to a spreadsheet. You need to have a Zapier account (it’s free for the first 5 integrations, or Zaps). 

And, of course, you’ll need to create a new spreadsheet. Now, let’s go to work.

1st stage: Creating the email address for integration

1. On Zapier, click on Create Zap

Here, we’ll integrate the Email Parser with Google Spreadsheets. So start with choosing the Email Parser (you’ll also need an account there – you can use your regular Zapier account)

2. Go to the Email Parser by Zapier, then choose the “Trigger Event” – what will trigger the action.

In this case, when a conversation concludes, it will create a new email, so we’ll go with New Email – then, click “continue

bot sheets 1

3. Create a new Zapier Email Parser account, or connect your relevant Zapier Email Parser account here.

bot sheets 2

bot sheets 3


After that, click Continue

4. Click on the
On the page that was open, click on “create mailbox

bot sheets 4

5. Copy the mailbox’ address, for example this one:

bot sheets 5

2nd stage: Creating the mail’s template

6. Go back to the bot, to the send email component, and paste the address into the address row

sheets 6

7. Run the bot’s best-case scenario (“happy path”) once, in the test project window, and make sure it reaches the end (the Send Email component). 

After you finished – in the Email Parser window you’ll see an email looking like that:

bot sheets 7

8. Now, catch the full answer that you want to turn into a parameter. A popup window will appear – type the parameter’s name, as you want it to appear

bot sheets 8

9. After clicking “Save” – and repeating the process until all the parameters are named, this is what happens – the previous answers will be replaced with the parameters’ names

sheets 9

10. On the same page, scroll down and click on “Save Address and Template” button.

sheets 10

Now, the template is ready!

3rd stage: testing the template

11. Go back to Zapier. Now, under set up trigger, click on the mailbox, find your relevant mailbox. After it’s set, click Continue

bot sheets 11

12. Now, in the next stage, click on “Test Trigger”. You’re supposed to see a screen like this, approving the process is working. Click “Continue

bot sheets 12

Now it’s time to integrate it into the Spreadsheet!

4th stage: The integration comes alive

13. Choose Google Sheets  from the options.

bot sheets 13

14. Open the “Action event” menu, click on “Create Spreadsheet row

bot sheets 14

15. Choose your Google Spreadsheet account. Now, under “Set up action”, choose your Google Drive, the specific Spreadsheet, and the specific Worksheet

bot sheets 15

16. Remember the parameters we defined earlier (see #8)? Now we’re going to find them inside the test email’s content. If it doesn’t appear right away, click “show all options”, then search for the relevant word or phrase

bot sheets 16

17. Once you found all the parameters, click continue

18. Under “Test Action”, click “Test & Continue”. Once the process is complete, you’ll see this on the screen:

bot sheets 18

And on the Spreadsheet, you’ll see the collected data:

bot sheets 19

19. Click “Turn on Zap”, and this screen will appear:

bot sheets 20

Congratulations! Now, start sending people to talk with the bot, and get all the data you need.

Good luck!

If you still need help – contact us here.


Other guides from cocohub:

How to connect a bot to a phone number?

How to start building your bot?