How to Send Data to Google sheet once mini app is submmited ?

1. Create a New Mini App Flow

• Go to the platform, click “Create New Flow”.

• Enter a flow name, select a relevant category (e.g., sign up, appointment), and choose your WhatsApp channel.

2. Design the Welcome Screen

• Use the mini apps dashboard to access components.

• Drag and drop:

  • Title field: Set the main title.

  • Optional image: Upload a logo or banner if desired.

  • Text field: Label as “Enter your name”.

  • Number field: Label as “Enter your phone number”.

  • Email field: Label as “Enter your email”.

• Add a footer column to enable future actions like data saving or navigation.

3. Create a Submission Confirmation Screen

• Click “Add Screen” to make a second screen.

• Title it (e.g., “Thank you”).

• Add a body field to display submitted details (map variables accordingly).

• Optionally, add a photo column.

• Rename the button to “Submit” and set its action to “Submit”.

4. Set Data Submission Actions

• On the welcome screen footer, set the action type to “Data Exchange”.

• For navigation, choose “Flow Submission” to ensure data is passed to the thank you screen seamlessly.

5. Save and Apply Flow

• After building, click “Save & Apply” to store the flow in your CRM. (Note: This does not publish to Meta yet.)

6. Test the Mini App Flow

• In the mini apps dashboard, click “More” then select “Send Test Message” for testing purposes.

• Create a new board flow, click the plus icon, choose “WhatsApp Chatbot”.

• Set “Mini App Submission” as the trigger, select your WhatsApp channel, and the mini app you created.

• Add a block to show “Submission History” and a “Send Message” block (e.g., “Please wait while we are getting your details”).

7. Automate Data Entry Into Google Sheets

• Add an automation app, search for Google, select “Google Sheets”, then choose “Add a Row”.

• Authenticate via Google by signing in and selecting the right account.

• From the drop-down, choose the target spreadsheet and sheet.

• Map fields: connect your mini app’s name, phone, and email to the correct columns in Google Sheets.

• Save the mapping.

8. Finalize and Confirm

• Add another “Send Text Message” block with a final confirmation (e.g., “Thank you. Your details have been successfully saved.”).

• Save the flow.

9. Live Test and Verify

• Run the test; check your Google Sheet to ensure data enters instantly as a new row from the WhatsApp mini app submission.

This process enables simple automation for collecting WhatsApp user inputs and storing them efficiently in a spreadsheet for easy management and follow-up