Every Chat Lead Logged to Your Spreadsheet Automatically

Millions of businesses track leads in Google Sheets. It works, it is free, and everyone knows how to use it. Now Boei's AI agent fills in your spreadsheet for you, adding a new row every time someone reaches out through your website.

New row for every lead
Custom column mapping
Real-time updates
Andrew Lee David S. Vance W. Grant Nitesh Manav
from 159 reviews

The Spreadsheet CRM That Fills Itself

You do not need a fancy CRM to track leads. A well-organized Google Sheet with name, email, phone, message, and source columns does the job for most small businesses. The problem is getting leads into that spreadsheet consistently. Someone always forgets to log a conversation, and leads slip through.

Boei solves this by making the logging automatic. Every time someone contacts you through your website chat, WhatsApp, email, or any other Boei channel, the AI agent captures their details and sends them to Google Sheets via webhook. A new row appears with their name, email, phone number, the message they sent, which channel they used, and the page they were on.

Your spreadsheet becomes a real-time lead log that you never have to update manually. Filter by date to see today's leads. Sort by channel to see where your leads come from. Share the sheet with your team so everyone has the same view. It is the CRM you already know, powered by AI.

How Leads Get Into Your Spreadsheet

Automatic, accurate, and instant

1

Visitor Starts a Conversation

Someone visits your website and reaches out through the chat widget, WhatsApp button, contact form, or AI chatbot. They share their question and contact details.

2

AI Agent Captures Lead Data

The AI agent handles the conversation, collects name, email, phone if shared, and notes the channel, page URL, and conversation summary.

3

New Row Added to Your Sheet

A webhook sends the data to Google Sheets via Zapier. A new row appears with all lead details in the columns you configured. Your team sees it immediately.

What Small Businesses Do With Their Lead Sheet

Lead Tracking Without a CRM

Not ready for HubSpot or Salesforce? A Google Sheet with automatic lead logging gives you 80% of what a CRM does at zero cost. Sort, filter, and follow up from a tool you already use every day.

Conversation Logging for Compliance

Some industries need records of customer interactions. Every conversation gets logged with a timestamp, customer details, and the full exchange. Your compliance team gets an auditable log without extra software.

Daily and Weekly Lead Summaries

Use Google Sheets formulas or pivot tables to create automatic summaries. How many leads this week? Which channel brings the most? What pages convert best? The data is already there.

Custom Column Mapping

Map any data the AI extracts to your own columns. Company name, industry, product interest, budget range, whatever your sales process needs. The AI pulls it from the conversation and slots it into the right column.

Frequently Asked Questions

How does the Google Sheets connection work?

Boei sends lead data via webhook when someone contacts you through any channel. Zapier receives the webhook and appends a new row to your Google Sheet. You configure which columns get which data in the Zapier setup.

Can I use an existing Google Sheet?

Yes. You point Zapier to any existing Google Sheet and map the webhook data to your column headers. No need to create a new spreadsheet or change your current format.

What data gets logged for each lead?

By default: name, email, phone number (if provided), message content, channel used, page URL, timestamp, and conversation summary. You can add custom columns for any additional data the AI extracts.

Will it create duplicate rows for returning visitors?

Each conversation creates a new row by default. If you want to avoid duplicates, you can configure your Zapier workflow to check for existing rows by email and update them instead of creating new entries.

What Boei plan do I need?

Webhook integrations require the Growth plan at $49/month with annual billing. This includes 3 chatbots, 7,000 AI credits, API access, and 3 agent seats alongside webhook functionality.

Is Google Sheets reliable enough for lead tracking?

For most small businesses, absolutely. Google Sheets handles thousands of rows without issues, offers real-time collaboration, and integrates with everything. It is the most accessible lead tracker available, and with Boei filling it automatically, you never miss a lead.

Your Best CRM Might Be the Spreadsheet You Already Have

Let Boei fill your Google Sheet with every lead, every conversation, every channel. Automatically.

7-day free trial • No credit card required • Works with any Google Sheet