Connectors · Spreadsheet
Pennant + Google Sheets
Not everything lives in a CRM with an API. The Google Sheets connector syncs structured funnel or spend data from a sheet on the same hourly cadence as every other source — a pragmatic bridge for systems Pennant doesn't connect to natively yet.
What syncs
Hourly, backfilled, and PII-free
- Structured rows you maintain in a sheet — funnel records or spend lines
- Pseudonymous identifiers only; the no-PII rule applies to sheets too
- Hourly automated syncs, same as native connectors
TODO: verify with product — confirm the documented sheet format/template before publishing setup specifics.
Every connector, always:
Automated hourly syncs · historical backfills · credentials encrypted at rest (AES-256-GCM) · sync-health monitoring with alerting · zero student PII ingested.
What it unlocks
Questions this connector answers
- Bring in the stragglers
- Legacy systems, vendor exports, or media plans that live outside your CRM can still join the unified view through a maintained sheet.
- One view, even with a mixed stack
- Sheet-sourced data flows into the same funnel, channel, and pacing views as everything else — no asterisks in the dashboard.
- A migration path, not a dead end
- Start with a sheet for a source, switch to a native connector when one exists — the analytics on top don't change.
Running Google Sheets? You're most of the way there.
Bring your setup to a demo and we'll walk through exactly what the connector would sync and what your dashboard would show.