Log website chat enquiries in Google Sheets
Each enquiry your AI chat agent collects is added as a new row, building a log your team can sort, filter and share. See at a glance which visitor questions went unanswered.
Sending enquiries to your tools is part of the Starter, Business and Scale plans. On Free, enquiries wait in Hazelchat. See pricing.
Google SheetsFictional sample
- Date
- 2026-10-17T09:30:00.000Z
- Name
- Alex Example
- alex@example.com
- Message
- Could you fit a team of 12 on Friday evening?
- Last question
- Do you take group bookings?
- Answered
- answered
- Website
- https://your-business.example
- Link
- https://app.hazelchat.co/#contacts/…
What arrives in Google Sheets
Zapier’s public template “Create Google Sheets rows for new Hazelchat enquiries” starts from Hazelchat’s New Enquiry trigger. This is what it puts in Google Sheets:
| In Google Sheets | From the template |
|---|---|
| Drive, spreadsheet, worksheet | You pick them after connecting Google. |
| Columns | Not pre-mapped. Google Sheets shows a sheet’s columns only after you pick it, so give the sheet the headers Date, Name, Email, Message, Last question, Answered, Website and Link, then map each one to the field of the same name. |
Conversation transcripts and your agent’s answers never leave Hazelchat. The link opens the enquiry and its conversation there.
Set it up in four steps
-
In Hazelchat
Switch visitor details on
In Hazelchat Settings, switch visitor details on and leave capture running, so visitors can leave an enquiry.
-
In Hazelchat
Create an API key
Create an API key in the Settings card for Zapier and copy it. It is shown once.
-
In Zapier
Open the template
Open the template in Zapier, connect Hazelchat with that key, then connect Google, pick your sheet and map each column.
-
On your site
Test, then turn it on
Leave a made-up enquiry in your chat, check what arrives, then turn the Zap on. Hazelchat marks each enquiry it sends.
Good to know
Visitor text in cells
A message that starts with
=,+,-or@may be read by Google Sheets as a formula. Keep this log in its own spreadsheet, apart from sheets with figures or private data.Counting unanswered questions
The Answered column holds the word answered or unanswered, never the answer itself. It says whether your agent answered the visitor’s last question before they left their details.
Every field the trigger sends
You can map any of these in the Zap, as well as or instead of the template’s choice.
| Field | What it holds |
|---|---|
id | The enquiry’s id in Hazelchat |
created_at | When the enquiry was saved, as an ISO time in UTC |
name | The name the visitor typed |
email | The email address the visitor typed |
message | The visitor’s note, which may run over several lines |
website | The website the chat ran on: yours, not the visitor’s |
last_question | The visitor’s last question before they left their details |
answered | answered or unanswered: whether your agent answered that question, never the answer itself |
enquiry_url | A link to the enquiry in Hazelchat |
utm_source, utm_medium, utm_campaign, utm_content, ad_click_network, referrer_host, chat_started_on and chat_opened_via | Where the visitor came from and where the chat started, each only when the visitor’s browser reported it |
There is no phone, company or consent field. Name, email, message and last question are what the visitor typed: treat them as untrusted text, and escape them before using them in HTML or email templates.
Other ways to send enquiries
Prefer n8n? Start a workflow with the Hazelchat Trigger and add n8n’s own Google Sheets node after it. Hazelchat publishes no ready-made n8n workflow for this; the n8n guide covers the trigger.
The same trigger has public templates for Slack, HubSpot, Trello and Microsoft Teams. The Zapier guide covers the trigger for unanswered questions, the enquiry search and the draft-answer action.
Your data controls still apply
Enquiries go to Zapier (US) and on to Google Sheets. Pausing capture, turning visitor details off or leaving the paid plans cancels pending deliveries. Revoke the key to stop them.
Deleting an enquiry in Hazelchat cannot remove the copy already in Google Sheets. Delete it there separately.
Every new enquiry, in Google Sheets.
Build your AI chat agent first, from your own pages. Send enquiries on once it answers well. See all integrations.