{"id":3183,"date":"2026-04-06T14:35:07","date_gmt":"2026-04-06T09:05:07","guid":{"rendered":"https:\/\/www.msgclub.net\/learn\/?p=3183"},"modified":"2026-04-06T14:35:07","modified_gmt":"2026-04-06T09:05:07","slug":"how-to-connect-whatsapp-flow-with-google-sheets-in-chatbot","status":"publish","type":"post","link":"https:\/\/www.msgclub.net\/learn\/how-to-connect-whatsapp-flow-with-google-sheets-in-chatbot.html","title":{"rendered":"How to Connect WhatsApp Flow with Google Sheets in Chatbot"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>What is Google Sheets Integration in WhatsApp Flow?<\/strong><\/h4>\n\n\n\n<p>Google Sheets Integration in MSGClub Chatbot automatically capturing user responses from WhatsApp Flows and storing them directly into a structured Google Spreadsheet.<\/p>\n\n\n\n<p>From lead generation and customer registrations to feedback collection and appointment bookings, every interaction is recorded in real-time\u2014accurate, organised, and ready to use.<\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>Connect your WhatsApp Flow to Google Sheets and transform everyday conversations into meaningful business insights.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Learn More<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#utility-flow-create-steps-guide\">Step by Step Guide\u00a0<\/a><\/li>\n\n\n\n<li><a href=\"#utility-flow-create-faqs\">FAQs\u00a0<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Step by Step Guide<\/h2>\n\n\n\n<p><strong>Step 1: <\/strong>Sign in to MsgClub using your Username and Password.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"450\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image.png\" alt=\"\" class=\"wp-image-3186\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-300x132.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-768x338.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 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<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-2.png\" alt=\"\" class=\"wp-image-3187\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-2.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-2-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-2-768x432.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 3:<\/strong> From the Dashboard, select Verified WhatsApp Service.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"551\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-1.png\" alt=\"\" class=\"wp-image-3185\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-1.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-1-300x161.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-1-768x413.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 4:<\/strong> From the left-hand panel, click on <strong>Bot Flow<\/strong>, and then select the <strong>Connect Google Sheet<\/strong> option.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"958\" height=\"497\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-3.png\" alt=\"\" class=\"wp-image-3188\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-3.png 958w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-3-300x156.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-3-768x398.png 768w\" sizes=\"auto, (max-width: 958px) 100vw, 958px\" \/><\/figure>\n\n\n\n<p><strong>Step 5:<\/strong> To add a new spreadsheet, simply click on the <strong>Add Sheet<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"923\" height=\"498\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-4.png\" alt=\"\" class=\"wp-image-3189\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-4.png 923w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-4-300x162.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-4-768x414.png 768w\" sizes=\"auto, (max-width: 923px) 100vw, 923px\" \/><\/figure>\n\n\n\n<p><strong>Step 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 <strong>Configure Button<\/strong> to proceed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"250\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-5.png\" alt=\"\" class=\"wp-image-3190\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-5.png 455w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-5-300x165.png 300w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/figure>\n\n\n\n<p><strong>Step 7:<\/strong> A Google authentication window will appear. Select your Google account and click <strong>Continue<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"237\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-6.png\" alt=\"\" class=\"wp-image-3191\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-6.png 480w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-6-300x148.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<p><strong>Step 8:<\/strong> You may see a message saying <em>\u201cGoogle hasn\u2019t verified this app.\u201d<\/em> This is a common security prompt. To proceed, click on <strong>Advanced<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"251\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-8.png\" alt=\"\" class=\"wp-image-3193\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-8.png 481w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-8-300x157.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/figure>\n\n\n\n<p><strong>Note:<\/strong> This is a standard Google security prompt for custom integrations.<\/p>\n\n\n\n<p><strong>Step 9:\u00a0<\/strong> Then choose <strong>Go to msgclub.net (unsafe)<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"249\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-7.png\" alt=\"\" class=\"wp-image-3192\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-7.png 480w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-7-300x156.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<p><strong>Step 10:<\/strong> After that, review the permissions requested and click <strong>Continue<\/strong> to grant access.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-1024x576.png\" alt=\"\" class=\"wp-image-3197\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-1024x576.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-1536x864.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10-1568x882.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-10.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-1024x509.png\" alt=\"\" class=\"wp-image-3196\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-1024x509.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-300x149.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-768x382.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-1536x763.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11-1568x779.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-11.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"249\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-12.png\" alt=\"\" class=\"wp-image-3198\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-12.png 478w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-12-300x156.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<p><strong>Step 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<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-1024x576.png\" alt=\"\" class=\"wp-image-3199\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-1024x576.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-1536x864.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13-1568x882.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-13.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 12:<\/strong> After connecting your spreadsheet, the next step is to link it with your WhatsApp Flow.<\/p>\n\n\n\n<p>Start by <a href=\"https:\/\/www.msgclub.net\/learn\/create-and-send-whatsapp-flow-from-msgclub.html\">creating a WhatsApp Flow<\/a> and then <a href=\"https:\/\/www.msgclub.net\/learn\/create-flow-with-templates-in-msgclub.html\">create a Flow Template<\/a>.\u00a0<\/p>\n\n\n\n<p><strong>Step 13:<\/strong> Once that is ready, go to the <strong>Bot Flow section<\/strong> from the left side panel.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-1024x576.png\" alt=\"\" class=\"wp-image-3200\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-1024x576.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-1536x864.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14-1568x881.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-14.png 1930w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u00a0Then click on the <strong>Default Bot<\/strong> tab.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-1024x577.png\" alt=\"\" class=\"wp-image-3202\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-1024x577.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-1536x865.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16-1568x883.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-16.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To view your chatbots, click on <strong>Show Bots <\/strong>button<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-1024x580.png\" alt=\"\" class=\"wp-image-3201\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-1024x580.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-768x435.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-1536x871.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15-1568x889.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-15.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 14:<\/strong> Either open an existing bot or create a new bot by clicking on the <strong>Create Chatbot <\/strong>button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-1024x575.png\" alt=\"\" class=\"wp-image-3203\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-1024x575.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-1536x863.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17-1568x881.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-17.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 15:<\/strong> In the bot configuration, select <strong>Template with Flow<\/strong> in the case of \u201cOn reply of WhatsApp Template\u201d event.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-1024x576.png\" alt=\"\" class=\"wp-image-3204\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-1024x576.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-768x432.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-1536x864.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18-1568x882.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-18.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 16:<\/strong> Next, move to the <strong>Trigger settings<\/strong>. Here, uncheck the <strong>Template<\/strong> option and enable the <strong>Webhook<\/strong> option instead.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-1024x574.png\" alt=\"\" class=\"wp-image-3206\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-1024x574.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-300x168.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-768x431.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-1536x861.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19-1568x879.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-19.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 17:<\/strong> Then, change the method type to <strong>Google Spreadsheet<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-1024x578.png\" alt=\"\" class=\"wp-image-3205\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-1024x578.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-768x433.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-1536x867.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20-1568x885.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-20.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, click on <strong>Select Spreadsheet<\/strong>.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"579\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-1024x579.png\" alt=\"\" class=\"wp-image-3207\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-1024x579.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-768x434.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-1536x869.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21-1568x887.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-21.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 18:<\/strong> You will see a list of connected sheets. Hover over the sheet you want to use and click on <strong>Use It<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-1024x580.png\" alt=\"\" class=\"wp-image-3211\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-1024x580.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-768x435.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-1536x870.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24-1568x888.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-24.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 19:<\/strong> A pop-up window will appear where you can map the fields from your WhatsApp Flow to the columns in your Google Sheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-1024x578.png\" alt=\"\" class=\"wp-image-3208\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-1024x578.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-768x433.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-1536x867.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22-1568x885.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-22.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Carefully align each field with the correct column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-1024x578.png\" alt=\"\" class=\"wp-image-3209\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-1024x578.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-300x169.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-768x433.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-1536x867.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23-1568x885.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-23.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"579\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-1024x579.png\" alt=\"\" class=\"wp-image-3210\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-1024x579.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-768x434.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-1536x868.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25-1568x886.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-25.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 20:<\/strong> Once the mapping is complete, you will receive a success message.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-1024x582.png\" alt=\"\" class=\"wp-image-3212\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-1024x582.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-768x436.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-1536x873.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26-1568x891.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-26.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"581\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-1024x581.png\" alt=\"\" class=\"wp-image-3214\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-1024x581.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-768x436.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-1536x872.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27-1568x890.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-27.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 21:<\/strong> Click on the <strong>Update<\/strong> button to save your bot configuration.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-1024x575.png\" alt=\"\" class=\"wp-image-3213\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-1024x575.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-300x168.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-768x431.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-1536x862.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28-1568x880.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-28.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 22:<\/strong> Once the bot is saved, it will be visible in the list of chatbots.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-1024x580.png\" alt=\"\" class=\"wp-image-3215\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-1024x580.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-768x435.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-1536x870.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29-1568x888.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-29.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><strong>Step 23:<\/strong> Every time a user fills out your WhatsApp Flow, their responses will be instantly recorded as a new row in your connected Google Sheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"579\" src=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-1024x579.png\" alt=\"\" class=\"wp-image-3216\" srcset=\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-1024x579.png 1024w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-300x170.png 300w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-768x434.png 768w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-1536x868.png 1536w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30-1568x886.png 1568w, https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-30.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">FAQs<\/h3>\n\n\n\n<p><strong>Q. <\/strong>Why should I connect Google Sheets with WhatsApp Flow?<\/p>\n\n\n\n<p><strong>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<p><strong>Q. <\/strong>Do I need to create a Google Sheet before integration?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> Yes, you must create a Google Spreadsheet in advance and use its URL during the configuration process.<\/p>\n\n\n\n<p><strong>Q. <\/strong>Why am I seeing \u201cGoogle hasn\u2019t verified this app\u201d?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> This is a standard Google security warning for custom integrations. You can proceed safely by clicking <strong>Advanced \u2192 Go to msgclub.net (unsafe)<\/strong>.<\/p>\n\n\n\n<p><strong>Q. <\/strong>Is it safe to grant Google permissions?<\/p>\n\n\n\n<p><strong>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<p><strong>Q. <\/strong>Can I connect multiple Google Sheets to different flows?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> Yes, you can configure different Google Sheets for different bot flows based on your business requirements.<\/p>\n\n\n\n<p><strong>Q. <\/strong>What type of data gets stored in the Google Sheet?<\/p>\n\n\n\n<p><strong>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<p><strong>Q. <\/strong>What should I do if the data is not reflecting in the sheet?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> You can check the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verify the Google Sheet URL<\/li>\n\n\n\n<li>Ensure proper permissions are granted<\/li>\n\n\n\n<li>Confirm the flow is correctly configured<\/li>\n\n\n\n<li>Reconnect the integration if required<\/li>\n<\/ul>\n\n\n\n<p><strong>Q. <\/strong>Can I edit the Google Sheet after integration?<\/p>\n\n\n\n<p><strong>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<p><strong>Q. <\/strong>Will data be stored in real-time?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> Yes, data is captured and stored instantly as users interact with the WhatsApp Flow.<\/p>\n\n\n\n<p><strong>Q. <\/strong>What happens if I revoke Google access?<\/p>\n\n\n\n<p><strong>Ans.<\/strong> If access is revoked, the integration will stop working, and data will no longer be captured in the sheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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\u2014accurate, organised, and ready to use. By combining&hellip; <a class=\"more-link\" href=\"https:\/\/www.msgclub.net\/learn\/how-to-connect-whatsapp-flow-with-google-sheets-in-chatbot.html\">Continue reading <span class=\"screen-reader-text\">How to Connect WhatsApp Flow with Google Sheets in Chatbot<\/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":[23,952,951,950,948,59,949,25,30,613,24,953],"class_list":["post-3183","post","type-post","status-publish","format-standard","hentry","category-chatbot","category-integration","category-verified-whatsapp","category-whatsapp-flow","tag-business-whatsapp","tag-chatbot-integration","tag-customer-data-management","tag-data-collection","tag-google-sheets-integration","tag-lead-generation","tag-msgclub-chatbot","tag-verified-whatsapp","tag-whatsapp","tag-whatsapp-automation","tag-whatsapp-flow","tag-workflow-automation","entry"],"_links":{"self":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3183","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=3183"}],"version-history":[{"count":3,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3183\/revisions"}],"predecessor-version":[{"id":3219,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/posts\/3183\/revisions\/3219"}],"wp:attachment":[{"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/media?parent=3183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/categories?post=3183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msgclub.net\/learn\/wp-json\/wp\/v2\/tags?post=3183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}