Captured fields
The Sheet stays useful.
- Received timestamp
- Space or room name
- Thread identifier
- Sender name or email
- Message text
- Dedupe key for repeat events
Workflow
Small, auditable setup.
The first version can be delivered as an Apps Script file and a setup checklist. It uses a script lock and simple event dedupe so duplicate webhooks do not create noisy repeated rows.
Example Sheet
Rows a client can filter immediately.
| received_at | space | sender | message | dedupe_key |
|---|---|---|---|---|
| 2026-08-06 14:10 | Support intake | client@example.com | Need help with invoice #1042. | spaces/AAA|1042 |
| 2026-08-06 14:18 | Support intake | team@example.com | Assigned to billing. | spaces/AAA|1043 |
Handoff
What the client receives.
The deliverable can include Apps Script code, Sheet column layout, deployment notes, test cases, and clear next steps for the client's Google Workspace admin.