- \n
- Step by Step Guide\u00a0<\/a><\/li>\n\n\n\n
- FAQs\u00a0<\/a><\/li>\n<\/ul>\n\n\n\n
Step by Step Guide<\/h2>\n\n\n\n
Step 1:<\/strong> Sign in to MsgClub using your Username and Password.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-31.png\")
<\/figure>\n\n\n\nStep 2:<\/strong> You\u2019ll receive an OTP on your registered mobile number.\u00a0 Enter the OTP and click Verify.\u00a0<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-32.png\")
<\/figure>\n\n\n\nStep 3:<\/strong> From the Dashboard, select Verified WhatsApp Service.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-33.png\")
<\/figure>\n\n\n\nStep 4:<\/strong> From the left-hand panel, click on Bot Flow<\/strong>, and then select the Connect Google Sheet<\/strong> option.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-34.png\")
<\/figure>\n\n\n\nStep 5:<\/strong> To add a new spreadsheet, simply click on the Add Sheet<\/strong> button.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-35.png\")
<\/figure>\n\n\n\nStep 6:<\/strong> 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<\/strong> to proceed.<\/p>\n\n\n\n
<\/figure>\n\n\n\nStep 7:<\/strong> A Google authentication window will appear. Select your Google account and click Continue<\/strong>.<\/p>\n\n\n\n
<\/figure>\n\n\n\nStep 8:<\/strong> You may see a message saying \u201cGoogle hasn\u2019t verified this app.\u201d<\/em> This is a common security prompt. To proceed, click on Advanced<\/strong>.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-36.png\")
<\/figure>\n\n\n\nNote:<\/strong> This is a standard Google security prompt for custom integrations.<\/p>\n\n\n\n
Step 9:<\/strong>\u00a0 Then choose Go to msgclub.net (unsafe)<\/strong>.<\/p>\n\n\n\n
<\/figure>\n\n\n\nStep 10:<\/strong> After that, review the permissions requested and click Continue<\/strong> to grant access.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-37-1024x576.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-38-1024x509.png\")
<\/figure>\n\n\n\n<\/figure>\n\n\n\nStep 11:<\/strong> Once you complete this step, your Google Sheet will be successfully connected to MSGClub and ready for use.
<\/p>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-39-1024x576.png\")
<\/figure>\n\n\n\nStep 12:<\/strong> After connecting your spreadsheet, the next step is to link it with your WhatsApp Flow.<\/p>\n\n\n\n
Start by creating a WhatsApp Flow<\/a> and then create a Flow Template<\/a>. <\/p>\n\n\n\n
Step 13:<\/strong> Once that is ready, go to the Bot Flow section<\/strong> from the left side panel.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-40-1024x576.png\")
<\/figure>\n\n\n\nStep 14:<\/strong> Go to the Bot Flow<\/strong> section. You can either:<\/p>\n\n\n\n
- \n
- Click on Create Bot Flow<\/strong> to start a new one, or<\/li>\n\n\n\n
- Open an existing bot flow<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-42-1024x574.png\")
<\/figure>\n\n\n\nStep 15:<\/strong> A pop-up will appear where you can begin creating your bot flow. In new case, start creating the Bot Flow after adding the flow name on the top left corner of the canvas.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-41-1024x576.png\")
<\/figure>\n\n\n\nStep 16:<\/strong> First you need to add an Event,<\/strong> and then you will be able to add triggers by clicking on the small dot on the boxes or you may click on the elements to add them to your flow.
<\/p>\n\n\n\n
Step 17:<\/strong> While adding the trigger in the bot flow, add the required flow template by clicking on the Use It<\/strong> button.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-43-1024x577.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-44-1024x583.png\")
<\/figure>\n\n\n\nThe template will be added to the bot flow on the canvas.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-47-1024x576.png\")
<\/figure>\n\n\n\nStep 18:<\/strong> After adding the template, insert another node in the flow. In the pop-up:<\/p>\n\n\n\n
- \n
- Select Trigger<\/strong><\/li>\n\n\n\n
- Choose Google Spreadsheet<\/strong> as the trigger type<\/li>\n<\/ul>\n\n\n\n
<\/figure>\n\n\n\nStep 19: A configuration pop-up will appear, allowing you to set up your Google Spreadsheet<\/strong>.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-48-1024x581.png\")
<\/figure>\n\n\n\nStep 20: Click on Select Spreadsheet<\/strong>, then choose the sheet where you want the data to be stored.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-49-1024x575.png\")
<\/figure>\n\n\n\nStep 21: <\/strong>Map your flow fields to the matching columns in your Google Sheet, ensuring each field is placed in the correct column.
Example –<\/p>\n\n\n\n\u00a0\u00a0\u00a0\u00a0Integration Column\u00a0 \u00a0 \u00a0 \u00a0 Spreadsheet Column<\/strong>
1. Contact number \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Contact number\u00a0<\/p>\n\n\n\n2. Reply Name<\/p>\n\n\n\n
3. Reply ID ID<\/p>\n\n\n\n
3. Date Date<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-50-1024x577.png\")
<\/figure>\n\n\n\nStep 22:<\/strong> Once everything is configured:<\/p>\n\n\n\n
- \n
- Continue building your flow if needed, or<\/li>\n\n\n\n
- End the flow if this is the final step by adding an End Flow <\/strong>node.<\/li>\n<\/ul>\n\n\n\n
Click on Publish<\/strong> to save your Bot Flow.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-51-1024x579.png\")
<\/figure>\n\n\n\nStep 23: After publishing, your bot will appear in the list of Bot Flows.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-52-1024x578.png\")
<\/figure>\n\n\n\nStep 24: Once your setup is complete, the process becomes fully automated. Every time a user fills out your WhatsApp Flow, their responses will be automatically added as a new row in your connected Google Sheet.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-53-1024x579.png\")
<\/figure>\n\n\n\nFAQs<\/h3>\n\n\n\n
Q. <\/strong>Why should I connect Google Sheets with WhatsApp Flow?<\/p>\n\n\n\n
Ans.<\/strong> 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.<\/p>\n\n\n\n
Q. <\/strong>Do I need to create a Google Sheet before integration?<\/p>\n\n\n\n
Ans.<\/strong> Yes, you must create a Google Spreadsheet in advance and use its URL during the configuration process.<\/p>\n\n\n\n
Q. <\/strong>Why am I seeing \u201cGoogle hasn\u2019t verified this app\u201d?<\/p>\n\n\n\n
Ans.<\/strong> This is a standard Google security warning for custom integrations. You can proceed safely by clicking Advanced \u2192 Go to msgclub.net (unsafe)<\/strong>.<\/p>\n\n\n\n
Q. <\/strong>Is it safe to grant Google permissions?<\/p>\n\n\n\n
Ans.<\/strong> 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.<\/p>\n\n\n\n
Q. <\/strong>Can I connect multiple Google Sheets to different flows?<\/p>\n\n\n\n
Ans.<\/strong> Yes, you can configure different Google Sheets for different bot flows based on your business requirements.<\/p>\n\n\n\n
Q. <\/strong>What type of data gets stored in the Google Sheet?<\/p>\n\n\n\n
Ans.<\/strong> All user inputs captured in the flow\u2014such as name, mobile number, responses, and selections\u2014can be stored in the sheet.<\/p>\n\n\n\n
Q. <\/strong>What should I do if the data is not reflecting in the sheet?<\/p>\n\n\n\n
Ans.<\/strong> You can check the following:<\/p>\n\n\n\n
- \n
- Verify the Google Sheet URL<\/li>\n\n\n\n
- Ensure proper permissions are granted<\/li>\n\n\n\n
- Confirm the flow is correctly configured<\/li>\n\n\n\n
- Reconnect the integration if required<\/li>\n<\/ul>\n\n\n\n
Q. <\/strong>Can I edit the Google Sheet after integration?<\/p>\n\n\n\n
Ans.<\/strong> Yes, you can edit the sheet (e.g., add columns), but ensure that changes do not disrupt the configured mapping.<\/p>\n\n\n\n
Q. <\/strong>Will data be stored in real-time?<\/p>\n\n\n\n
Ans.<\/strong> Yes, data is captured and stored instantly as users interact with the WhatsApp Flow.<\/p>\n\n\n\n
Q. <\/strong>What happens if I revoke Google access?<\/p>\n\n\n\n
Ans.<\/strong> If access is revoked, the integration will stop working, and data will no longer be captured in the sheet.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
This explains how to connect your WhatsApp Flow with Google Sheets in MSGClub using Bot Flow. By setting up this integration, businesses can automatically capture and store user responses from WhatsApp interactions into a structured Google Spreadsheet. From collecting leads and customer details to managing registrations and feedback, this setup ensures all data is recorded… Continue reading How to Connect WhatsApp Flow with Google Sheets in Bot Flow<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,241,12,19],"tags":[954,23,951,950,948,59,949,25,613,34,24,953],"class_list":["post-3220","post","type-post","status-publish","format-standard","hentry","category-chatbot","category-integration","category-verified-whatsapp","category-whatsapp-flow","tag-bot-flow","tag-business-whatsapp","tag-customer-data-management","tag-data-collection","tag-google-sheets-integration","tag-lead-generation","tag-msgclub-chatbot","tag-verified-whatsapp","tag-whatsapp-automation","tag-whatsapp-business-api","tag-whatsapp-flow","tag-workflow-automation","entry"],"_links":{"self":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/comments?post=3220"}],"version-history":[{"count":4,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3220\/revisions"}],"predecessor-version":[{"id":3254,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3220\/revisions\/3254"}],"wp:attachment":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/media?parent=3220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/categories?post=3220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/tags?post=3220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Choose Google Spreadsheet<\/strong> as the trigger type<\/li>\n<\/ul>\n\n\n\n
- Open an existing bot flow<\/li>\n<\/ul>\n\n\n\n
- FAQs\u00a0<\/a><\/li>\n<\/ul>\n\n\n\n