We are developing chatbot and we have a specific requirement to save data to Spreadsheet.
[login to view URL] Agent called User Registration and collect following information from user
Sex- Male or Female
Is your whatsapp? no if not then collect whatsapp no if yes then save number as whatsapp
What is your top health concern
Dietary preference-- Vegetarian/Eggitarian/Omnivarian
Do you agree terms? Yes
Date as a system data
[login to view URL] Spreadsheet with above field.
[login to view URL] Webhook in google sheet using Apps [login to view URL] it as webapps and collect above data.
4. Once data is saved Reply to user that you are registered.( you can send reply to user first and then save data for quick response to user.)
5. Email admin that new user registered.