Sync Clari to Google Sheets with n8n
Keep a Google Sheet in lock-step with Clari — one-way and two-way patterns.
Key takeaways
- Scope Clari credentials tightly, per environment.
- Prefer webhooks over polling wherever Clari supports them.
- Make every workflow idempotent — Clari will retry, and so will you.
- Version workflow JSON in Git, not just inside n8n.
This is the definitive n8n guide to Clari for revenue intelligence teams. You'll learn the exact node-by-node setup, the patterns that survive production, and the pitfalls that trip up most first-time builders. Every step is copy-pasteable.
Why this matters for Clari
Most Clari automations fail not because n8n can't handle the load — it can — but because the auth, retries and idempotency were bolted on after launch. Here we do it right from step one.
The workflows below have been tested against real Clari accounts with volume. They favour clarity over cleverness, so you can hand them off to a teammate on day two.
- Uses only stock n8n nodes plus HTTP Request
- Idempotent by design — safe to replay
- Alerts on failure to a channel your team watches
Setup and credentials
Open Credentials → New → Clari. Use a dedicated service account, not a personal token. Scope it to the minimum permissions your workflow needs — you can widen later, you cannot easily narrow.
Test the credentials against a read-only endpoint before you save. A bad credential is the single most common cause of silent failure in production.
The workflow, step by step
Drag the Clari trigger onto the canvas. Set the polling interval or, better, wire it to a webhook. Add a Set node right after to normalise the payload — you'll thank yourself when the schema changes.
Downstream, add a Merge or IF node to branch on record type. Keep each branch short — a workflow that fits on one screen is a workflow you can debug at 3am.
- Trigger
- Normalise (Set)
- Branch (IF / Switch)
- Act
- Log
- Alert on error
Production hardening
Turn on the Error Workflow so every failure lands in your incident channel with the payload attached. Add a dedupe key based on the Clari record ID and store recent IDs in Redis or Postgres for 24 hours.
Version your workflow. Export the JSON on every meaningful change and commit it to Git — n8n's built-in versioning is convenient, but Git is the source of truth your ops team will trust.
Frequently asked questions
- Do I need a paid Clari plan?
- Most n8n workflows work on Clari's free or lowest paid tier. Rate limits, not features, are the usual blocker.
- How do I test safely?
- Create a sandbox Clari account or workspace. Never point a test workflow at production Clari data — even a "read-only" workflow can hit quotas.
- Can I self-host n8n for this?
- Yes. For Clari workloads under ~10k events/day a single n8n instance is fine. Beyond that, switch to queue mode with Redis.
- Where should logs go?
- Send workflow logs to your existing observability stack — Datadog, Grafana or a Postgres table you already query.