MetaVerified Tech Provider

Your DM Leads and Bookings, In a Google Sheet

For everyone who does not run a CRM. Connect Google Sheets and ChatGenius creates a spreadsheet in your own Drive with a Leads tab and a Bookings tab, then appends a row every time somebody shares their email, gives a phone number, or books an appointment in a DM.

Start Free Trial

Creator plan and up  ยท  7-day free trial

Integrated with

How It Works

Connect once. The sheet fills itself from then on.

1

Sign In With Google

One Google sign-in from Settings, then Integrations, then Google Sheets. Nothing to configure, no API key to paste, no column mapping to set up.

2

ChatGenius Builds the Sheet

A new spreadsheet appears in your Drive with a Leads tab and a Bookings tab, columns already in place. Your existing leads are written in straight away, oldest first.

3

Rows Land As They Happen

Somebody shares an email in an Instagram DM, a flow collects a phone number, a customer books a slot in chat. Each one appends a row within seconds of the conversation.

4

The Row Stays Current

Learn more about that person later and their existing row is rewritten rather than duplicated. A booking that moves or gets cancelled updates in place.

What You Get

A spreadsheet you can actually work from, not a dump you have to clean up

Two Tabs, Real Columns

Leads carries Captured At, Channel, Name, Username, Email, Phone and a link back to the conversation. Bookings carries Booked At, Appointment Time, Channel, Name, Email, Phone, Service, Status and the Confirmation Code your customer sees.

One Row Per Person

Email now, phone number an hour later, a name in between. It all lands on the same row instead of scattering across three. The row is found by its Conversation ID cell, so it still works after you have sorted or filtered the sheet yourself.

Bookings That Tell the Truth

Rescheduled, cancelled, completed or no-show all update the booking's own row. The Status column reflects where things actually stand, so you are not reading a sheet full of appointments marked confirmed that nobody attended.

It Arrives Full

Connecting backfills the leads you have already captured, oldest first, up to 500. The sheet is worth opening the minute it exists rather than sitting empty until your next DM.

Two Independent Switches

Leads and Bookings sync separately. Turn one off if you only want the other tab filling up, and turn it back on whenever you want without reconnecting.

It Only Touches Its Own File

ChatGenius asks for a Google permission that covers files it created and nothing else, so the rest of your Drive stays private to you. Values are written as plain text, which means a message starting with an equals sign lands as text and never evaluates as a live formula.

Use Cases

Tattoo Artist

A Booking Sheet You Can Read at a Glance

Consultations booked in Instagram DMs land on the Bookings tab with the date, the service and the confirmation code. When somebody reschedules, that row moves with them, so the sheet you check on Monday morning matches the week you actually have.

Online Coach

One List to Email From

Every follower who shares an email after a reel appears on the Leads tab with the channel and the date. Filter to this month, copy the column, and you have your send list without touching a CRM or exporting a CSV.

Med Spa

Front Desk Without a Login

Share the spreadsheet with whoever runs your front desk. They see new enquiries and today's appointments as they arrive, with a link through to the full conversation, and they never need a ChatGenius seat.

Plan Availability

Feature
Free
Creator
Pro
Business
Google Sheets integration
Lead sync
Booking sync
Connect-time backfill
See full pricing details →

Google Sheets Questions

Which spreadsheet does ChatGenius write to?+
One that ChatGenius creates for you. When you connect, it makes a new spreadsheet in your own Google Drive with a Leads tab and a Bookings tab, already set up with the right columns. You cannot point it at an existing spreadsheet, and that is deliberate: it lets ChatGenius use a permission that only covers files it created, so it never gets access to the rest of your Drive.
What columns are in the sheet?+
The Leads tab has Captured At, Channel, Name, Username, Email, Phone, Conversation and Conversation ID. The Bookings tab has Booked At, Appointment Time, Channel, Name, Email, Phone, Service, Status, Conversation and Confirmation Code. The Conversation column is a direct link back to that conversation in ChatGenius.
What happens if someone gives their email now and their phone number later?+
They stay one row. ChatGenius finds the row that conversation already owns and rewrites it, so you end up with one complete record instead of two half ones. The row is matched by its Conversation ID cell rather than a remembered row number, so it still works after you have sorted, filtered or inserted rows yourself.
Do bookings update when they are rescheduled or cancelled?+
Yes. A booking that is rescheduled, cancelled, completed or marked no-show updates the row it belongs to, matched by its Confirmation Code. The Status column reflects where the booking actually stands rather than staying on confirmed forever.
Does it include the leads I captured before connecting?+
Yes. Connecting writes in the leads you have already captured, oldest first, up to 500 of them, so the sheet is useful the moment it appears. Conversations with no email or phone number are skipped, since they are not leads.
Which plans include the Google Sheets integration?+
Creator, Professional and Business. It is not available on the Free plan. There is no separate charge for it on the plans that include it.
Can I edit the spreadsheet myself?+
Yes. It is your file, in your Drive. Sort it, filter it, add your own columns, build charts off it, or share it with someone who has no ChatGenius login. ChatGenius writes values as plain text rather than formulas, so nothing a stranger types in a DM can evaluate as a live formula in your spreadsheet.
What happens if I disconnect?+
Syncing stops and your spreadsheet stays exactly where it is, in your Drive, with everything already written to it. Reconnecting later creates a brand new spreadsheet rather than resuming the old one, because the permission ChatGenius uses only reaches files it created and it cannot find its way back to a file after being disconnected from it.

Stop Exporting CSVs

Start your 7-day free trial. No credit card required.

Start Free Trial