Follow these steps to automatically store Mini App form data in Google Sheets:
Step 1: Create Bot Flow
- Go to Chatbot → Create Bot Flow
- Add a title
- Click + → WhatsApp Chatbot
- Select trigger: Mini App Submission
- Choose your Mini App
- Enable Previous Submission History (if required)
Step 2: Add Processing Message (Optional)
- Add a message block: “Please wait while we are processing your details.”
Step 3: Connect Google Sheets
- Click Add Automation App → Search “Sheets”
- Select Add Row
- Choose or create Google Authentication
- Select your Spreadsheet
- Select the Sheet (Sub sheet)
Step 4: Map Fields
- Map Mini App fields (Name, Phone, Email, etc.) to sheet columns
- Click Run & Save
Step 5: Confirmation Message
- Add a message block: “Thank you. Your details have been successfully saved.”
- Save and Enable the workflow
Now, whenever a user submits the Mini App form, the data will automatically be added as a new row in Google Sheets.