Skip to main content
Solved

Pulling Whatsapp responses into a spreadsheet


Mikeymike

Hey, I have created a 10 step flow with buttons and text/number inputs. I want to pull the responses into a file (csv, xls, etc). How to do that?

 

Also, if a uk postcode is entered, can a check be made that it is valid? 

Finally, i want to process all the response data in order to calculate a quotation: can that be done ‘on the fly’ or could the responses be dynamically stored in a spreadsheet and the spreadsheet include a calculated quotation column that is returned to the user in real time??

 

Thanks

 

Best answer by Gustavo Boregio

Hey ​@Mikeymike 

  1. Yes, the easiest way to export is using Google Sheets: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration
  2. Yes, you can check post codes, but you’ll need to integrate it with something external. It’s a matter of finding the right API that will validate post codes for you and connecting it.
  3. For quotations, it depends on how complex your calculation is. If it’s something simple than you may be able to do it in Manychat. In most cases, you’ll need something external (could be a Google Sheet, make.com scenario, etc)

Hope this helps!

And if you need help setting this up feel free to ping me, I’ve done similar setups for a bunch of my clients.

View original
Did you find this topic helpful?

Gustavo Boregio
Forum|alt.badge.img+6

Hey ​@Mikeymike 

  1. Yes, the easiest way to export is using Google Sheets: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration
  2. Yes, you can check post codes, but you’ll need to integrate it with something external. It’s a matter of finding the right API that will validate post codes for you and connecting it.
  3. For quotations, it depends on how complex your calculation is. If it’s something simple than you may be able to do it in Manychat. In most cases, you’ll need something external (could be a Google Sheet, make.com scenario, etc)

Hope this helps!

And if you need help setting this up feel free to ping me, I’ve done similar setups for a bunch of my clients.


Mikeymike
  • Channel Explorer
  • July 24, 2025

Hi Gustavo,

many thanks for your response. 

insert row is not inserting a row! I’ve mapped all the manychat fields to the worksheet columns and ‘update’ finds no errors, so…..any ideas ????


Mikeymike
  • Channel Explorer
  • July 24, 2025

insert row is now working...not sure what i did!! however, the field mapping went strange and i had to correct it. I have an insert row, early on in the flow. i had update row later on, but i deleted it. BUT, the update is still happening because later inputted fields are still being populated in the worksheet!! Why? 


Gustavo Boregio
Forum|alt.badge.img+6

Hey ​@Mikeymike glad to hear you worked it out!

And not sure what’s going on, but most likely you have something set wrong or inconsistent data.

Try starting from scratch with a clean Google Sheet and see if this sorts it out ;)


Mikeymike
  • Channel Explorer
  • July 25, 2025

Hi Gustavo,

Thanks for your message. I tried with a clean sheet but its putting update rows as new rows several empty rows down in the sheet. Perhaps its the corrupted field mapping that is the issue. It seems a bit fragile. 


Gustavo Boregio
Forum|alt.badge.img+6

@Mikeymike the integration will insert a new row - which will be the first completely empty row on the sheet.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings