Skip to main content

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

 

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.


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 ????


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? 


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 ;)


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. 


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

 


Reply