WhatsApp Sales

Record WhatsApp enquiries in Google Sheets automatically

Stop copying chats into a spreadsheet by hand. Every time a customer taps your WhatsApp link and is sent to an admin, a row with the time, the admin and a reference code lands in your Google Sheet.

iLiBuat.Link Team7 min read

Key takeaways

  • With WhatsApp Sales Router, every tap on your WhatsApp link is assigned to an admin. The Google Sheets export adds each one as a row.
  • A reference code such as IB-7F3A21C9D0 can be added to the customer’s first message, so you can match each chat with its row.
  • Each row is a routed tap, not a confirmed chat or sale. Add your own columns for status and order value.
  • Sales Router is on Creator and higher. The Google Sheets export is on Pro (5 spreadsheets), Business (15) and Agency (15).
On this page5
  1. 1. How it works
  2. 2. What each row contains
  3. 3. Match each chat to its row with a reference code
  4. 4. What the sheet does and doesn’t show
  5. 5. Set it up

At the end of the day someone scrolls through three admins’ WhatsApp chats and types the new enquiries into a spreadsheet: time, which admin, which promo. It takes an hour, it is always behind, and the numbers never quite match.

If your chats already go through a WhatsApp link that splits them between admins, the spreadsheet can fill itself.

Customer taps your link

Chat opens with Ayu

Hi, is the 1 kg pack still available?

Ref: IB-7F3A21C9D0

New row in your sheet

IB-7F3A21C9D0

Tap, chat with an admin, new row. The reference code ties the chat to the row.

How it works

WhatsApp Sales Router sends each customer who taps your link to one admin in your sales team, by turn or by working hours. Every time it does, iBuat.Link records the assignment. The Google Sheets export writes each assignment into a spreadsheet you choose, a few moments later.

If you need the split itself first, start with how to split WhatsApp chats between several admins.

What each row contains

ColumnExampleUse it for
Time2026-10-01 09:15Busy hours, daily totals
TeamJakarta SalesComparing teams or branches
AgentAyu, or FallbackLoad per admin, and taps outside working hours
Linkpromo-igWhich link or promotion the customer came from
CampaignPayday OctoberTotals per campaign
Assignment ModeROUND_ROBINHow the admin was chosen
Sticky ReusednoWhether a returning customer went back to the same admin
Reference TokenIB-7F3A21C9D0Matching the row with the chat

WhatsApp leads

TimeAgentLinkRef
09:15Ayuask-salesIB-7F3A21C9D0
09:31Bimaask-salesIB-3QX8LD
10:02Ayupromo-igIB-9VN4TR
21:47Fallbackpromo-igIB-2HC6WE
One row per routed tap, with the admin and the reference code.

Match each chat to its row with a reference code

The source reference is on by default in every sales team; you can check it in the team’s Closing tracking settings. The customer’s first WhatsApp message then ends with a short code such as “Ref: IB-7F3A21C9D0”, and the same code appears in the row. When the chat turns into an order, the admin searches the sheet for the code and fills in the result.

What the sheet does and doesn’t show

A row means a customer tapped your link and was sent to an admin. It does not prove they sent the message: some people open WhatsApp and change their mind. The export also never contains the customer’s phone number or what they wrote, because a link doesn’t receive those.

That is why the reference code and your own Status column matter: together they turn “taps” into “chats” and “orders” you can count. To record closed sales with their value, see how to know which ads actually sell on WhatsApp.

Set it up

  1. 1

    Create a sales team and a Sales Router link

    Add your admins and their WhatsApp numbers, then create a short link with Sales Router as the destination. Use that link in your bio, ads and Bio Page buttons.

  2. 2

    Connect Google Sheets

    Open Integrations, go to the Google Sheets tab and click Connect Google Sheets to link your Google account. Pick the spreadsheet in Google’s own file picker; iBuat.Link can only open that one file.

  3. 3

    Choose the worksheet and team

    Pick the tab that receives the rows. You can connect one spreadsheet per team, or one for all teams.

  4. 4

    Send a test row

    Use the test button, open the sheet and check that the row arrived.

The Google Sheets export guide covers each screen in detail. Want a Telegram alert for every new chat as well? This n8n workflow sends the alert and adds the row.

Frequently asked questions

Does the sheet include the customer’s phone number?+

No. A link never receives the customer’s number or message, so the rows contain the time, team, admin, link, campaign and reference code only.

Which plans can use this?+

WhatsApp Sales Router is on Creator and higher. The Google Sheets export needs Pro (up to 5 spreadsheets), Business or Agency (up to 15).

What if Google is slow or unavailable?+

The customer is never delayed: rows are written in the background and retried. If the spreadsheet is deleted or access is removed, the export log shows it as failed.

Can I add my own columns?+

Yes, to the right of the first eight. The export always appends the same eight columns in the same order and doesn’t read your headers.

Let the spreadsheet fill itself

Split WhatsApp chats between your admins and get every routed tap as a row in Google Sheets.

Share