What is Google Sheets Integration in WhatsApp Flow?
Google Sheets Integration in MSGClub Chatbot automatically capturing user responses from WhatsApp Flows and storing them directly into a structured Google Spreadsheet.
From lead generation and customer registrations to feedback collection and appointment bookings, every interaction is recorded in real-time—accurate, organised, and ready to use.
By combining interactive WhatsApp experiences with seamless data capture, this integration helps you eliminate manual work, streamline operations, and gain better visibility into your customer data.
Connect your WhatsApp Flow to Google Sheets and transform everyday conversations into meaningful business insights.
Learn More
Step by Step Guide
Step 1: Sign in to MsgClub using your Username and Password.
Step 2: You’ll receive an OTP on your registered mobile number. Enter the OTP and click Verify.
Step 3: From the Dashboard, select Verified WhatsApp Service.
Step 4: From the left-hand panel, click on Bot Flow, and then select the Connect Google Sheet option.
Step 5: To add a new spreadsheet, simply click on the Add Sheet button.
Step 6: Now, copy the URL of the Google Sheet you want to use and paste it into the provided field. Once done, click on the Configure Button to proceed.
Step 7: A Google authentication window will appear. Select your Google account and click Continue.
Step 8: You may see a message saying “Google hasn’t verified this app.” This is a common security prompt. To proceed, click on Advanced.
Note: This is a standard Google security prompt for custom integrations.
Step 9: Then choose Go to msgclub.net (unsafe).
Step 10: After that, review the permissions requested and click Continue to grant access.
Step 11: Once you complete this step, your Google Sheet will be successfully connected to MSGClub and ready for use.
Step 12: After connecting your spreadsheet, the next step is to link it with your WhatsApp Flow.
Start by creating a WhatsApp Flow and then create a Flow Template.
Step 13: Once that is ready, go to the Bot Flow section from the left side panel.
Then click on the Default Bot tab.
To view your chatbots, click on Show Bots button
Step 14: Either open an existing bot or create a new bot by clicking on the Create Chatbot button.
Step 15: In the bot configuration, select Template with Flow in the case of “On reply of WhatsApp Template” event.
Step 16: Next, move to the Trigger settings. Here, uncheck the Template option and enable the Webhook option instead.
Step 17: Then, change the method type to Google Spreadsheet.
Now, click on Select Spreadsheet.
Step 18: You will see a list of connected sheets. Hover over the sheet you want to use and click on Use It.
Step 19: A pop-up window will appear where you can map the fields from your WhatsApp Flow to the columns in your Google Sheet.
Carefully align each field with the correct column.
Step 20: Once the mapping is complete, you will receive a success message.
Step 21: Click on the Update button to save your bot configuration.
Step 22: Once the bot is saved, it will be visible in the list of chatbots.
Step 23: Every time a user fills out your WhatsApp Flow, their responses will be instantly recorded as a new row in your connected Google Sheet.
FAQs
Q. Why should I connect Google Sheets with WhatsApp Flow?
Ans. Connecting Google Sheets allows you to automatically store user responses in real-time, eliminating manual data entry and making it easier to track leads, responses, and customer interactions.
Q. Do I need to create a Google Sheet before integration?
Ans. Yes, you must create a Google Spreadsheet in advance and use its URL during the configuration process.
Q. Why am I seeing “Google hasn’t verified this app”?
Ans. This is a standard Google security warning for custom integrations. You can proceed safely by clicking Advanced → Go to msgclub.net (unsafe).
Q. Is it safe to grant Google permissions?
Ans. Yes, permissions are required to allow MSGClub to write data into your Google Sheet. Ensure you are using the official MSGClub platform before granting access.
Q. Can I connect multiple Google Sheets to different flows?
Ans. Yes, you can configure different Google Sheets for different bot flows based on your business requirements.
Q. What type of data gets stored in the Google Sheet?
Ans. All user inputs captured in the flow—such as name, mobile number, responses, and selections—can be stored in the sheet.
Q. What should I do if the data is not reflecting in the sheet?
Ans. You can check the following:
- Verify the Google Sheet URL
- Ensure proper permissions are granted
- Confirm the flow is correctly configured
- Reconnect the integration if required
Q. Can I edit the Google Sheet after integration?
Ans. Yes, you can edit the sheet (e.g., add columns), but ensure that changes do not disrupt the configured mapping.
Q. Will data be stored in real-time?
Ans. Yes, data is captured and stored instantly as users interact with the WhatsApp Flow.
Q. What happens if I revoke Google access?
Ans. If access is revoked, the integration will stop working, and data will no longer be captured in the sheet.
2 comments
Comments are closed.