Segment-to-BigQuery Zap Recipe

Step-by-step Zapier workflow that forwards key events into BigQuery without maintaining custom infrastructure.

How to use it

Set your `events` table schema using the included JSON and then activate the zap.
Use alongside the Activation Metric Planner to keep metrics consistent.

What you get

Zapier setup checklist with trigger/action mappings.
BigQuery table schema (JSON).
Fallback instructions if you outgrow Zapier.

BigQuery schema excerpt

[{
  "name": "event_name",
  "type": "STRING",
  "mode": "REQUIRED"
}, {
  "name": "occurred_at",
  "type": "TIMESTAMP",
  "mode": "REQUIRED"
}, {
  "name": "payload",
  "type": "JSON",
  "mode": "NULLABLE"
}]

Need the editable version? Email hello@crackerstack.com with the resource name and we’ll share the template.