Chat Leads Flow Into Your Excel Spreadsheet on OneDrive

Your company runs on Microsoft 365. Email in Outlook, files on OneDrive, meetings in Teams. Now your website leads land in Excel too, automatically logged by Boei's AI agent with every detail your sales team needs to follow up.

Rows added to Excel on OneDrive

Fits your Microsoft stack

Data stays in your tenant

Enterprise? Schedule a demo →

from 159 reviews

Lead Tracking That Fits Your Microsoft Environment

Plenty of businesses already track leads in Excel. It is familiar, powerful, and lives right alongside everything else in OneDrive. The only friction is getting leads into the spreadsheet. Someone has to manually type in details from every chat conversation, every email inquiry, every WhatsApp message. That manual step is where leads get lost.

Boei eliminates that step. When a customer contacts you through your website, the AI agent collects their details and sends a webhook to Zapier or Power Automate. That data gets inserted as a new row in your Excel table on OneDrive or SharePoint. Name, email, phone, message, channel, page URL, and timestamp all land in the right columns.

Because the file lives on OneDrive, your whole team sees updates in real time. Open it in Excel desktop, Excel Online, or even in Teams. The data is there, formatted in your table structure, ready for pivot tables, charts, or whatever analysis you already do with Excel.

How It Works

Website visitor to Excel row in seconds

Customer Contacts You

A visitor reaches out through your website chat, WhatsApp, contact form, or AI chatbot. They share their question and contact information.

Webhook Sends Lead Data

Boei's AI agent captures the lead details and sends them via webhook. Zapier or Power Automate receives the data and prepares it for Excel.

New Row in Your Excel Table

A row is added to your Excel table on OneDrive or SharePoint with all lead details in the correct columns. Your team sees it instantly in any Microsoft app.

What Microsoft Teams Do With Auto-Logged Leads

Structured Excel Tables for Clean Data

Leads go into a formatted Excel table with headers, data validation, and column types already set. This means your pivot tables, charts, and formulas work immediately on the new data without manual cleanup.

Power Automate Workflows

Use Power Automate instead of Zapier to keep everything in the Microsoft ecosystem. When a new row appears, trigger a Teams notification, send an Outlook email, or update a Planner task. All within Microsoft 365.

Pivot Table-Ready Data

Every row has consistent columns: date, channel, source page, lead type. Your existing pivot tables update automatically. Slice by month, channel, or product interest without reformatting anything.

Shared Workbooks in Teams

Pin the Excel file in a Teams channel so your sales team always has the latest leads visible. Comment on rows, assign follow-ups, and track progress without leaving Teams.

Frequently Asked Questions

Does this work with Excel on OneDrive or SharePoint?

Both. You can target an Excel file stored on OneDrive for Business or on a SharePoint site. Zapier and Power Automate both support creating rows in Excel files stored in either location.

Can I use Power Automate instead of Zapier?

Yes. Boei's webhooks are standard HTTP webhooks that work with any automation tool. Power Automate can receive the webhook and insert rows into Excel using the built-in Excel Online connector.

Does the Excel file need a specific format?

The data should go into a formatted Excel table (Insert > Table). This ensures columns have headers and new rows are properly structured. Your automation tool maps webhook fields to these column headers.

Will this work with the desktop version of Excel?

Yes. The file lives on OneDrive, so changes sync to every place you open it, including Excel desktop, Excel Online, and the Teams embedded viewer. New rows appear within seconds of being added.

What Boei plan supports Excel webhooks?

Webhooks require the Growth plan at $49/month with annual billing. This includes API access, 3 chatbots, 7,000 AI credits, and the webhook functionality needed for the Excel integration.

Is my data secure?

The lead data flows from Boei via webhook to your automation tool, then into your own OneDrive or SharePoint. The Excel file stays in your Microsoft 365 tenant, subject to your organization's security policies and access controls.