WhatChimp now allows you to fetch Google Sheet data and use it in chatbot replies in WhatsApp. This feature helps businesses provide quick and relevant responses, or any other stored information.
Prerequisites #
Before you start, ensure you have:
- A WhatChimp account
- A Google account with access to Google Sheets
Table of Contents #
- Setting Up Google Sheets for Chatbot Replies
- Creating a Campaign to Fetch Data
- Integrating Google Sheet Data into Chatbot Replies
- Use Cases and Benefits
- FAQs
Setting Up Google Sheets for Chatbot Replies #
1. Creating Custom Fields #
Before fetching data, you need custom fields to store the retrieved information.
- Go to Subscriber Manager on the WhatChimp dashboard.
- Click Manage Custom Fields under the Manage option.
- Click Create, name the custom field, and select its type.
- Add as many custom fields as needed.
2. Connecting Google Account to WhatChimp #
- From Settings, select Google Sheet Integration.
- Click Sign in with Google and log in to your Google account.
- Add an existing sheet or create a new one.
For a detailed guide on importing Google Sheets, visit here.
Creating a Campaign to Fetch Data #
Once the Google Sheet is connected, create a campaign to fetch data.
- Go to Google Sheet Fetch Data in Settings.
- Select WhatsApp Data Fetch Campaign and click Create.
- Name the API and select the Google Sheet to fetch data from.
- Map Data:
- Choose a Search Data field (e.g., subscriber message).
- Select the Google Sheet column headers and map them to the corresponding custom fields.
- Add as many fields as needed.
- Click Verify Connection to confirm setup.
Integrating Google Sheet Data into Chatbot Replies #
Now, integrate the fetched data into your chatbot responses.
- Go to WhatsApp Bot Manager and click Create Bot Reply.
- Add a keyword-based trigger (e.g., “Plumber”, “Electrician”).
- Select Google Sheet Data Fetch and link it to the campaign.
- Use custom fields in the reply text to personalize responses.
- Save and test your bot.
Example: If a user asks for a plumber, the bot retrieves the plumber’s contact details from the Google Sheet and provides them in the reply.
Use Cases and Benefits #
- Automated Service Queries: Instantly fetch provider details for home services, medical assistance, or support contacts.
- Inventory & Pricing Updates: Share real-time product availability and pricing.
- Personalized Responses: Use stored customer preferences for tailored replies.
- Seamless Data Management: Update information in Google Sheets without modifying bot flows.
FAQs #
1. Can I use multiple Google Sheets?
- Yes, you can integrate multiple sheets and fetch different types of data.
2. What happens if the data isn’t found?
- The bot can be configured to provide a fallback response, such as requesting more details.
3. Can I edit the fetched data before sending a reply?
- No, but you can apply formatting rules in Google Sheets before fetching the data.
4. Is this feature available for all messaging platforms?
- Yes, it works across WhatsApp, Messenger, Instagram, Telegram, and Webchat.
WhatChimp’s Google Sheet integration streamlines chatbot responses, making automation more dynamic and personalized. Whether managing service providers, inventory, or customer preferences, this feature ensures efficiency across all messaging platforms.