# Chatbase + Zapier: Send Chatbot Leads to Google Sheets > Connect Chatbase to Zapier so every lead your website chatbot collects lands in a Google Sheet with a Slack alert. A how-to guide based on the docs. Source: https://learn.ynteractive.com/content/blog/chatbase-zapier-leads-to-google-sheets · Updated 2026-10-20 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer To send Chatbase leads to Google Sheets, turn on the Collect Leads action in your Chatbase agent, then build a [Zap](https://learn.ynteractive.com/content/glossary/zapier-zap) with the Chatbase trigger **Form Submission** and the Google Sheets action **Create Spreadsheet Row**. Every name and email your [chatbot](https://learn.ynteractive.com/content/glossary/chatbot) collects is then saved as a new row within minutes. You can build the chatbot itself free, step by step, in the [Chatbase: Answer Customer FAQs with an AI Agent](https://learn.ynteractive.com/content/chatbase-ai-agent-answer-customer-faqs) lesson, and learn how a Zap works in [Never Miss a New Client Inquiry using Zapier](https://learn.ynteractive.com/content/zapier-google-forms-to-google-sheets). Last updated October 20, 2026 [Take the free module →](https://learn.ynteractive.com/courses/ai-apps-worth-knowing/36)Module 36 of the free [AI Apps Worth Knowing](https://learn.ynteractive.com/courses/ai-apps-worth-knowing) course, about 15 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 20, 2026 · Updated October 20, 2026 · 5 min read Chatbase · Zapier · Google Sheets · Integration guide **This is a guide, not a hands-on lesson.** It explains the idea and lists the setup steps from Chatbase's and Zapier's own documentation. There's no practice copy to click through here, and Stepthrough hasn't tested every screen on every plan. Screens and plan limits change, so check the links in Sources if a button looks different. ## What business problem does this solve? A website chatbot that collects leads is only useful if someone follows up. Out of the box, Chatbase keeps the leads it collects inside Chatbase. In a small office, nobody checks another dashboard every morning. So a visitor who asked about pricing at 9pm and left an email address waits two days for a reply, or never gets one. Take Brightway Bookkeeping, a made-up four-person firm. Its Chatbase agent answers questions about monthly bookkeeping packages and offers to have someone call. The office manager wants three things: - Every lead in the firm's existing **New inquiries** Google Sheet, next to the leads from the [contact form](https://learn.ynteractive.com/content/glossary/web-form). - A Slack message the moment a lead comes in, so the right person can reply the same day. - No copy and paste. A two-step Zap does all three. The payoff is speed. Small firms that reply to an inquiry within the hour win far more of them than firms that reply the next day. Stepthrough's [speed-to-lead](https://learn.ynteractive.com/content/glossary/speed-to-lead) glossary entry explains why. ## What do you need before you start? You need four things, and getting them ready first saves time in the Zap editor: 1. **A Chatbase agent with lead collection on.** Open the agent, go to **Build > Actions**, choose **Create action** and set up **Collect leads**. Choose the fields to ask for, for example name, email and phone. 2. **Your Chatbase API key.** In the Chatbase dashboard, open **Workspace settings** and choose **API keys** in the sidebar. Copy a key, or click **Create API Key**. Treat it like a password. Stepthrough's [API key](https://learn.ynteractive.com/content/glossary/api-key) entry explains why. 3. **Your Agent ID.** Open the agent, go to **Settings > General**, and copy the ID from the **Agent details** card. 4. **A Google Sheet with a header row.** Use columns such as Date, Name, Email, Phone and Source. Zapier reads row 1 to list the columns you can fill. Zapier's help center says the Chatbase app needs a paid Chatbase plan. Check your plan before you start. Zapier's free plan covers two-step Zaps like this one. ## How do you connect Chatbase to Zapier, step by step? These steps follow Chatbase's Zapier guide. Chatbase's own example sends leads to Google Docs; this one sends them to Google Sheets, which is easier to sort and share. 1. In Zapier, click **Create**, then **Zaps**. In the Zap editor, click **Trigger**. 2. Search for **Chatbase** and choose **Form Submission** as the trigger event. Click **Continue**. 3. Click **Sign in**, paste your Chatbase API key, and confirm. Zapier saves this connection for later Zaps. 4. Paste your **Agent ID** when Zapier asks for the chatbot, then click **Continue**. 5. Click **Test trigger**. Zapier needs at least one real lead, so chat with your agent on your own site first and leave a test name and email. 6. Add an action. Search for **Google Sheets** and choose **Create Spreadsheet Row**. Sign in with the Google account that owns the sheet. 7. Pick the spreadsheet and the worksheet. Zapier shows one box per column header. 8. Map the fields ([field mapping](https://learn.ynteractive.com/content/glossary/field-mapping)): click each box and pick the matching Chatbase value, such as name into Name and email into Email. Type "Chatbase" into Source so you can tell these leads from form leads. 9. Click **Test step**, then check that the row appeared in the sheet. 10. Optional: add a third step, **Slack: Send Channel Message**, with a line like "New chatbot lead: {name}, {email}". A third step needs a paid Zapier plan. 11. Click **Publish**. The [Form Submission trigger](https://learn.ynteractive.com/content/glossary/trigger) fires each time the agent's Collect Leads action captures a lead. On Zapier's free plan, Zaps check for new data about every 15 minutes. Paid plans check more often. ## What else can the Chatbase Zapier app do? The Chatbase app on Zapier has one trigger and one [action](https://learn.ynteractive.com/content/glossary/action): | Type | Name | What it does | | --- | --- | --- | | Trigger | Form Submission | Starts a Zap when your agent collects a lead | | Action | Send Prompt | Sends a message to your chatbot and returns its answer | **Send Prompt** turns the chatbot into a step inside other Zaps. For example, a new email in a shared inbox can be sent to the agent, and its answer, drawn from your own help docs, saved as a draft reply for a person to check. The [Zapier: ChatGPT Drafts Every Reply](https://learn.ynteractive.com/content/zapier-chatgpt-gmail-reply-signatoro-signature) lesson builds the same draft-then-review pattern with ChatGPT, and you can do it hands-on. ## What usually goes wrong? - **The test finds no data.** The trigger only sees leads collected after Collect Leads was turned on. Submit a fresh test lead through the chat, then test again. - **The wrong agent.** Each agent has its own ID. If leads from your main site don't arrive, check the ID in **Settings > General** against the one in the Zap. - **Columns don't show up.** Zapier reads the header row when you pick the sheet. If you add a column later, refresh the fields in the action step. - **Duplicate rows.** People sometimes give their details twice in one chat. Sort by email weekly, or add a Zapier **Filter** step later. - **Privacy.** Leads are personal data. Share the sheet only with people who follow up, and tell visitors in your chat widget that you'll store their details. ## Key takeaways - Chatbase's Zapier trigger is **Form Submission**. It fires when the agent's **Collect leads** action captures a lead. - You connect with a Chatbase API key from **Workspace settings > API keys**, plus the agent's **Agent ID**. - **Create Spreadsheet Row** puts each lead into an existing Google Sheet, and a Slack step adds an instant alert. - The **Send Prompt** action lets other Zaps ask your chatbot a question, which is useful for drafting replies from your own docs. - Zapier's help says a paid Chatbase plan is needed. Check yours before you start. ## Frequently asked questions **Does Chatbase work with Zapier on the free plan?** Zapier's help center says the Chatbase app needs a paid Chatbase plan. Zapier itself has a free plan that covers simple two-step Zaps. **Can I send Chatbase leads to a CRM instead of a sheet?** Yes. Swap the Google Sheets step for your CRM's create-contact action, for example HubSpot or Pipedrive. The trigger stays the same. **Is there a Chatbase app for Make too?** Yes. Make has a Chatbase app with a **Send a Message** module. See [Chatbase + Make: Draft Support Replies from Your Agent](https://learn.ynteractive.com/content/blog/chatbase-make-draft-support-replies). **Where can I learn Zapier from scratch?** The free [Make & Zapier Jump Start](https://learn.ynteractive.com/courses/make-zapier-jump-start) course starts with your first Zap, in a practice copy of the tool. ## Sources - [Chatbase: Zapier integration guide](https://www.chatbase.co/docs/user-guides/integrations/zapier) - [Zapier: Chatbase integrations](https://zapier.com/apps/chatbase/integrations) - [Chatbase in the Stepthrough AI tools directory](https://learn.ynteractive.com/content/ai-tools/customer-support-chatbots#tool-chatbase) ## Build it yourself, free **Chatbase: Answer Customer FAQs with an AI Agent**. A business case for a small firm that answers the same customer questions every week: build a Chatbase AI agent on your FAQ in the real app, make it say when it does not know, test it, get the chat… You do every step yourself in a practice copy of Chatbase, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/chatbase-faq-support-agent) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/chatbase-ai-agent-answer-customer-faqs) ## Free lessons in this post - [Chatbase: Answer Customer FAQs with an AI Agent](https://learn.ynteractive.com/content/chatbase-ai-agent-answer-customer-faqs): A business case for a small firm that answers the same customer questions every week: build a Chatbase AI agent on your FAQ in the real app, make it say when it does… - [Never Miss a New Client Inquiry using Zapier](https://learn.ynteractive.com/content/zapier-google-forms-to-google-sheets): Prospects who wait days for a reply hire someone else. Build a Zap that copies every new client inquiry from Google Forms into your tracking sheet the moment it… - [Zapier: ChatGPT Drafts Every Reply, Signatoro Signs It](https://learn.ynteractive.com/content/zapier-chatgpt-gmail-reply-signatoro-signature): Stop leaving patient emails waiting. Build a Zap where Gmail starts it, ChatGPT writes a personal reply, Signatoro's Get Signature step adds the sender's real… ## Watch it in a free lesson: AI Receipt Extractor: Receipts to Google Sheets with n8n ### AI Receipt Extractor: video walkthrough Full walkthrough · 5:35 · with captions Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. The whole lesson narrated step by step, recorded in Stepthrough’s simulated practice environment. [Watch it with chapters and the full transcript](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets#watch) From the free lesson [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) ## Related terms Plain-English definitions, each with an example from a free lesson. [Zap (Zapier)](https://learn.ynteractive.com/content/glossary/zapier-zap) · [Chatbot](https://learn.ynteractive.com/content/glossary/chatbot) · [Web form](https://learn.ynteractive.com/content/glossary/web-form) · [Chatbot fallback response](https://learn.ynteractive.com/content/glossary/chatbot-fallback-response) · [Delay by Zapier](https://learn.ynteractive.com/content/glossary/delay-by-zapier) · [Edge case](https://learn.ynteractive.com/content/glossary/edge-case) · [Filter (Zapier)](https://learn.ynteractive.com/content/glossary/zapier-filter) · [Formatter by Zapier](https://learn.ynteractive.com/content/glossary/formatter-by-zapier) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Keep reading - [Presentations.AI + Zapier: A Draft Deck for Every Deal](https://learn.ynteractive.com/content/blog/presentations-ai-zapier-draft-deck-for-every-deal): Use Presentations.AI's Zapier actions to turn a new row in your deals sheet into a draft client deck, with a Gmail draft linking to it. A how-to guide. - [tawk.to + Zapier: Log Every Chat Transcript in Sheets](https://learn.ynteractive.com/content/blog/tawk-to-zapier-chat-transcripts-to-google-sheets): Connect tawk.to to Zapier so every finished website chat is logged in Google Sheets and new tickets alert your team in Slack. A how-to guide from the docs. - [How to Learn Zapier: A 5-Step Path for Beginners](https://learn.ynteractive.com/content/blog/how-to-learn-zapier): How to learn Zapier as a beginner: triggers and actions first, one real Zap, testing, then filters and an AI step. Free lessons and official resources. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)