Chatbot replies mein Google Sheet data kaise use karein

Google Sheets se data fetch karein aur use WhatsApp par chatbot replies mein use karein

Updated 25 June 2026

Google Sheet Data Fetch aapke chatbot ko Google spreadsheet se information pull karne aur usse WhatsApp replies mein use karne deta hai. Ek customer message bhejta hai, bot unka number aapki spreadsheet mein dhoondhta hai, matching data fetch karta hai (order details, pricing, status — kuch bhi), aur automatically uske saath reply karta hai.

Video: https://www.youtube.com/watch?v=gmORCEzt0fM

Step 1: Apna Google Account connect karein

Settings & Integration → Sign in with Google par jaayein aur apna Google account connect karein.

Apni spreadsheet add karein — Add Existing Sheet par click karein, spreadsheet ID paste karein (Google Sheets URL mein /d/ aur /edit ke beech ki lambi string), apna Google account select karein aur save karein.

Step 2: Custom Fields create karein

Aapko custom fields ki zarurat hai jo data store karenge jo aapka chatbot spreadsheet se fetch karta hai. Har column ke liye ek custom field create karein jise aap use karna chahte hain.

Manage Subscribers → Manage → Manage Custom Fields par jaayein aur fields create karein jo aapki spreadsheet columns se match karein (jaise, "order_id", "order_name", "price").

Tip: Custom fields create karne ke details ke liye Managing Customer Data with Custom Fields dekhein.

Step 3: Ek Data Fetch campaign create karein

Settings & Integration → Google Sheet Data Fetch par jaayein aur Create par click karein.

Google Sheet Data Fetch campaign — select spreadsheet, search field, and map columns to custom fields

Campaign Name — Ise ek pehchanne wala naam dein (jaise, "Fetch Order Details").

Select Spreadsheet — Step 1 mein connect kiya gaya Google Sheet choose karein.

Search By — Choose karein ki spreadsheet mein customer ko kaise dhoondhein. Number select karne ka matlab hai ki bot customer ke WhatsApp number ko aapki sheet mein number column se match karega. Yeh sabse common option hai kyunki number automatically available hota hai.

Map Data — Spreadsheet columns ko apne custom fields se link karne ke liye Map Data par click karein. Har column ke liye jise aap fetch karna chahte hain, column header aur matching custom field select karein. Jitni zarurat ho utni mappings add karein.

Verify Connection par click karein to confirm karein ki data sahi se fetch ho raha hai, phir Save.

Step 4: Ise bot flow mein use karein

Bot Manager → Bot Reply → Create par jaayein. Apne chatbot ko naam dein aur keyword trigger assign karein (jaise, "order details").

Flow mein ek Google Sheet Data Fetch component add karein aur abhi create kiya gaya campaign select karein. Phir ek text block add karein jo reply mein aapke custom fields use kare — jaise, "Your order ID is {{order_id}}, item: {{order_name}}, price: {{price}}."

Bot flow with Google Sheet Data Fetch component and custom field reply

Bot reply using custom fields from Google Sheet data

Bot save karein aur WhatsApp par keyword bhejke test karein. Bot aapki spreadsheet se data fetch karta hai aur custom field values ke saath reply karta hai — aur real time mein update hota hai jab aap spreadsheet change karte hain.

Related articles

How to Import Contacts from Google Sheets — Google Sheets connect karein aur contacts import karein

How to Create a Keyword-Based WhatsApp Chatbot — Bot flow fundamentals aur keyword triggers

External HTTP API Integration in Bot Flow — Bots ko external APIs se connect karein

More in Integrations