Log every connection to Google Sheets
One spreadsheet row per connection: who connected, when, what they granted. Your access audit trail builds itself. Works the same with Airtable.
Suggested column layout
| Field | Type | Description |
|---|---|---|
| Date | column A | Map data.completedAt. |
| Client name | column B | Map data.clientName. |
| Client email | column C | Map data.clientEmail. |
| Status | column D | Map data.status (SUCCESS / PARTIAL_SUCCESS). |
| Accounts connected | column E | Map data.connectionSummaryText. |
| Ref | column F | Map data.customRef. |
Steps
- Create a sheet with the six headers above in row 1.
- In Make.com, create a scenario with a Webhooks → Custom webhook trigger and copy its URL.
- Paste it in ClientInvite under Settings → API & Webhooks, save, and click Send test event.[SCREENSHOT: API & Webhooks settings tab]
- Add a Google Sheets → Add a Row module (Airtable: Create a Record), pick your spreadsheet, and map the six fields per the table above.[SCREENSHOT: Make.com Google Sheets module with all six columns mapped]
- Run once with a test event, check the row appears, and turn the scenario on.
Want one row per asset instead of per connection? Add an Iterator module on data.assets[] between the webhook and the sheet, and map platform, type, name, and permission as extra columns.