Blog

Build a Webhook Audit Log in Google Sheets

By Published Updated

Google Sheets is useful when support, operations, finance, or QA needs webhook data in a shared, searchable table.

FastHook receives the provider event, runs a sequential Workflow, and calls the Google Sheets Append Values Action. Google Sheets is an Action provider, not a Destination type.

The Sequential Workflow

Create a Source for the provider, then add the Google Sheets Append Values Action to a Workflow. Each step finishes before the next step starts, so filtering and transformation happen before the row is appended.

Build a Google Sheets workflow

Create a sequential Workflow that writes selected webhook fields to Google Sheets.

A sequential FastHook Workflow maps provider data into a Google Sheets Action.
Flow
Provider webhook
  -> FastHook Source
  -> sequential Workflow
  -> google_sheets.append_values
  -> Google Sheets row

Connect Google Sheets

Open Actions, choose Google Sheets, and connect the Google account that can edit the target spreadsheet. Credentials remain in the connected account instead of being copied into a Destination config.

In the Workflow editor, add Google Sheets → Append Values and select the spreadsheet and worksheet.

  • Grant the connected Google account edit access to the spreadsheet.
  • Select the spreadsheet and worksheet from the Action resource fields.
  • Use a separate connected account when production ownership should not depend on a personal account.

Create The Source

Create a FastHook Source and paste its URL into Stripe, Shopify, GitHub, Typeform, HubSpot, or your own application. Send one representative test event so the Workflow editor can expose real payload fields.

Source URL
https://hook-xxxxxx.fasthook.io/

Map Fields Into A Row

Map only the fields people need. The Append Values Action accepts an ordered row, so stable identifiers, event type, customer details, amount, and timestamps can become predictable columns.

The value composer can combine fixed text with fields from the Source or an earlier Workflow step.

Example row mapping
customer.email
customer.name
order.id
order.total
order.currency
event.type

Send A Test Event

Activate the Workflow, send a test webhook to the Source URL, and inspect the Workflow run. The Google Sheets Action should append one row after all preceding steps succeed.

Test webhook
curl -X POST "https://hook-xxxxxx.fasthook.io/"   -H "Content-Type: application/json"   -d '{"customer":{"email":"ada@example.com"},"order":{"id":"ord_123","total":49},"event":{"type":"order.created"}}'

Control Volume And Duplicates

A spreadsheet is not a high-volume event database. Add Workflow filters before the Action and keep a stable provider event or object id in the row so duplicate replays are easy to detect.

If several side effects are needed, place them as explicit sequential Workflow steps and review each step result in the run history.

Debugging Checklist

  • Confirm that the provider request reached the Source.
  • Confirm that the Workflow is active and its filters accepted the event.
  • Open the failed Workflow step and inspect the Google API response.
  • Check the connected account, spreadsheet permission, selected worksheet, and mapped row values.
  • Before replaying a failed run, confirm that the sheet does not already contain the row.

Related articles

Next