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
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
Ref: IB-7F3A21C9D0
New row in your sheet
IB-7F3A21C9D0
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
| Column | Example | Use it for |
|---|---|---|
| Time | 2026-10-01 09:15 | Busy hours, daily totals |
| Team | Jakarta Sales | Comparing teams or branches |
| Agent | Ayu, or Fallback | Load per admin, and taps outside working hours |
| Link | promo-ig | Which link or promotion the customer came from |
| Campaign | Payday October | Totals per campaign |
| Assignment Mode | ROUND_ROBIN | How the admin was chosen |
| Sticky Reused | no | Whether a returning customer went back to the same admin |
| Reference Token | IB-7F3A21C9D0 | Matching the row with the chat |
WhatsApp leads
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
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
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
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
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.