How to in Zapier
- Create Zap: In Zapier, click the orange Create Zap button. Name the Zap for lead capture (e.g., Chatbase Leads to Google Sheets).
- Select Trigger App: Choose Chatbase and set Trigger Event to Form Submission.
- Connect Chatbase: Click Sign in to Chatbase in Zapier and enter your API Key from Chatbase Settings.
- Configure API Key: Paste the API Key into the Zapier field and continue.
- Obtain Chatbot ID: In Chatbase, copy the Chatbot ID from Chatbot Settings.
- Enter Chatbot ID: Paste the ID into Zapier's Chatbot ID field.
- Test Trigger: Run Test Trigger to fetch a sample lead.
- Add Action: Add Google Sheets as the action and choose Create Spreadsheet Row.
- Connect Google Sheets: Sign in to Google, select Drive > Your Spreadsheet > Worksheet.
- Map Fields: Map Chatbase lead fields to the correct sheet columns.
- Test Action: Test the action to ensure a new row is created.
- Publish Zap: Turn on the Zap by toggling the switch or clicking 'Turn on'.
- Verify End-to-End: Submit a test lead via your Chatbase bot and confirm the new row appears in Google Sheets.