How to Import User Input Flow Data In Google Sheet

You can import your user input data into your google sheet directly using BotSailor. For this action create a user input flow in any channel (Whatsapp, Facebook, Instagram, Telegram, Website chat). Then select the google sheet at the user start bot flow. In this document we will show you how you can create a user input flow and collect data directly to your google sheet. To Learn How to Connect Google Sheet with BotSailor - refer to this article here- How to Connect and Import Google Sheet

Why Save Input Flow Data into Google Sheets?

• Real-time data collection into a centralized database.
• No manual work, no downloading, uploading, or importing needed.
• Automate CRM updates, lead nurturing, and sales tracking.
• View, edit, analyze your data anytime inside Google Sheets.
• Integrate with other tools like Zapier, CRMs, and Reporting Platforms easily.

Whether it’s capturing leads, booking appointments, or collecting survey responses, BotSailor and Google Sheets makes it 10x easier and faster!

Step 1: Set Up User Input Flow in BotSailor

Now, create a flow to collect user information.

• Go to Bot Manager → Flow Builder.
• Click Create New Flow.
• Design your flow with Input Flow Elements:
  
  
• Ask for Name → Save to Custom Field Name
• Ask for Email → Save to Custom Field Email
• Ask for Phone → Save to Custom Field Phone

 Make sure every piece of data you want to save is collected into a Custom Field.

Step 2: Add Google Sheet Inside Input flow

After collecting inputs:

• Drag and drop the User Input flow
• Double click on it to configure.
• Set up the following:
• Select Google Sheet: Choose the Sheet where you want to send data.
  

Step 3: Test and Activate

Before going live:

• Test the flow by sending a sample conversation to yourself.
• Complete the inputs.
• Check your Google Sheet  the new row should appear automatically with the inputted data.

If everything looks correct, your user input flow is now connected to Google Sheets!

Final Checklist Before Publishing

✅ Google Sheet connected properly.

✅ Input fields saved into matching custom fields.

✅ All mappings in “Google Sheet Data Submit” element are correct.

✅ Test the flow once to ensure smooth submission.

Benefits of Sending User Input to Google Sheets

•  Centralized lead database
•  Real-time data collection
•  Easy integration with CRM or email marketing tools
•  Backup and record-keeping for all collected data
•  No manual data entry needed

FAQs

Do I need to connect my Google account before saving user inputs?

Yes. You must first connect your Google account via Settings → Google Sheets Integration in BotSailor before you can send any collected user input data into a Sheet.

Can I use an existing Google Sheet instead of creating a new one?

Yes. You can import any existing Google Sheet by using the Sheet ID from the URL.
Just make sure the sheet has clean, alphanumeric column headers without spaces.

What kind of data can I save into Google Sheets?

You can save any type of user input collected through Input Flow Elements, such as:

Full name
Email address
Phone number
City or country
Service interests
Product preferences
Custom notes or survey answers

How do I match user input fields with Google Sheet columns?

When setting up the Google Sheet Data Submit element:

Each Sheet Column must be mapped to a BotSailor Custom Field.
Example:
Sheet Column: Email → Custom Field: {{subscriber.email}}
Mapping ensures that the user responses are saved under the correct columns.

Can I send multiple user inputs into Google Sheets in one submission?

Yes. You can collect multiple user inputs in your flow and submit them all together into a single row inside the selected Google Sheet.

What happens if the field mapping is incorrect?

If the mapping is wrong:

Data might not appear in the correct columns.
Or, data could fail to submit altogether.

 Always double-check your mappings carefully during setup.

Will data sync automatically if a user updates their input later?

No. BotSailor only sends user data at the time of flow submission.
If a user updates information later, you need to trigger a new submission manually through a flow.

Can I use multiple Google Sheets for different flows?

Yes. You can create and connect multiple Sheets and use different sheets for different chatbot flows based on your campaign or project needs.

Does BotSailor require any special permission to access my Google Sheets?

When you connect Google Sheets:

BotSailor only asks for permission to view, create, and manage spreadsheets linked through the app.
It cannot access your Gmail or other unrelated Google account data.