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 timestamp. |
| Client name | column B | Map clientName. |
| Client email | column C | Map clientEmail. |
| Status | column D | Map status (SUCCESS / PARTIAL_SUCCESS). |
| Accounts connected | column E | Map connectionSummaryText. |
| Ref | column F | Map 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.
- Add a Google Sheets → Add a Row module (Airtable: Create a Record), pick your spreadsheet, and map the six fields per the table above.
- 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 connectionAssets[] between the webhook and the sheet, and map platform, type, name, connectionStatus and accessLevel as extra columns.