need to pull Chatbot survey data to Google Sheets tally

  • 17 March 2023
  • 1 reply

Hello! I’m super new with creating Zaps. I stumbled upon using a Zap to help me accomplish pulling my survey data from Chatbot into a Google Sheet.

My survey is working but I don’t know if I have the Zap set up correctly. My trigger is New message in Chatbot. Action is Create spreadsheet Row in Google Sheets. I’ve used the attributes in Chatbot to match up with my column headers in my Worksheet. 

When I run a test and fill out the survey, the Google sheet doesn’t contain survey data. I can run a Zap test and the Worksheet puts my field attributes in the cells, it appears my Zap is set up correctly. Do I have the wrong Trigger or Action set? 

What am I doing wrong? 

Thank you. 

1 reply

Userlevel 7
Badge +9

Hey there, @groovywriter! Welcome to the Zapier community - we’re so excited to have you!

Hmm, it can be few different things! Google Sheets can be a bit particular when it comes to setup though. First, I’d recommend checking out this article to make sure your spreadsheet is setup to work with Zapier.

Here’s another one for troubleshooting when a zap won’t trigger that could be useful! 

Finally if none of these do the trick, sometimes sharing screenshots of your trigger and action setup (with any personal details removed) can help the community troubleshoot with ya. 🙂

I hope some of this helps! Keep us posted though. 🤗