How to Save Chatbot User Inputs in Google Sheets via MSG91

With MSG91’s Google Sheets plugin, you can seamlessly store user responses from your chatbot into a connected Google Sheet. Follow the steps below to get started:

✅ Step 1: Set Up Your Chatbot Flow

1. Open your MSG91 Chatbot in Hello Ticketing and chat center.

2. Create a new flow or use an existing one.

3. Add a series of message cards (e.g., text questions) to collect user responses.

4. For each question, save the responses in variables. Refer this doc to understand how to create custom variables to store user response.
   

Example:
Create message cards for the following questions and save responses as:

✅ Step 2: Prepare Your Google Sheet

1. Open Google Sheets from your Google account.

2. Create a new spreadsheet and add column headers that match the information you want to collect.
   

Example column headers:

• Name

• Country

• Car

• Hobby

(Make sure they correspond to the variables above.)

✅ Step 3: Connect Google Sheets Plugin in MSG91

1. Go back to your chatbot flow in MSG91.

2. From the right-side panel, click on Connections.

3. Drag and drop the "Plugin" card onto your chatbot flow (canvas area).
   

✅ Step 4: Configure the Plugin

1. Click on the Plugin card → Add Flow → Select Google Sheets.

2. Connect your Google Account (use the same account where your spreadsheet was created).

3. From the dropdown:

   • Select your Google Sheet

   • Choose the correct worksheet (e.g., Sheet1)
     

4. The columns from your sheet will now auto-populate below.

5. Enable the “Fill with AI” checkbox.

6. Click Test:

   • Enter sample values for each column.

   • Save and confirm that these values appear in your sheet.

7. If successful, click Create.
   

✅ Step 5: Map Variables with Sheet Columns

1. On the Plugin card, click the bullet point icon, then click the pen/edit icon.
   

2. You will now see a key-value mapping format like this:

{
 "Name": "{{customer_name}}",
"Country": "{{country_selected}}",
"Car": "{{car_selected}}", 
"Hobby": "{{user_hobby}}"
}

3. Make sure the keys match your sheet’s column headers, and the values match your variable names (surrounded by double curly brackets).
   

4. Save the configuration.

🎉 You’re Done!

Now, whenever a user interacts with your chatbot and fills out the flow, their responses will be automatically logged into your Google Sheet in real time.

🛠 Need Help?

If you face any issues:

• Double-check your variable names and column headers

• Ensure the Google Sheet is accessible via the connected account

• Schedule a Meeting or drop an email at [email protected]