Cue + Google Sheets
SpreadsheetsThe short version
There are three honest ways to get Cue data into Google Sheets: download a CSV from your analytics and open it in Sheets (any plan, ten seconds), have Zapier add a row whenever a code is created or changed (Business plan, no code), or have a developer set up a sheet that tops itself up with scan numbers on a schedule. Most teams start with the CSV and add automation when the copy-paste gets old.
Works on: CSV export on every plan; automatic updates on Business and Enterprise
What you can do with Google Sheets
A campaign tracker that fills itself in
Every new code lands as a row in your sheet — name, link, date — via Zapier. The tracker your team already uses stays complete without chasing anyone.
Scan numbers for the weekly meeting
Download a CSV of scans by code, campaign, location, or device from Cue analytics and drop it into Sheets — charts and pivot tables work straight away.
A living dashboard
A developer can set up a sheet that pulls fresh scan totals from Cue on a schedule — open the sheet, see this week's numbers, no exporting at all.
Before you start
- For CSV export: any Cue plan — it's built into analytics.
- For automatic logging of new and changed codes: a Cue Business plan and a Zapier account (see our Zapier guide — it's the same 15-minute setup with Google Sheets as the action).
- For scheduled scan-number updates: a developer with an hour, using Cue's developer access.
Set it up
Start with the CSV
In Cue, open Analytics, choose the view you want (a code, a campaign, a date range) and click export. Open the file in Google Sheets — done.
Automate new-code logging with Zapier
Follow our Zapier guide to connect Cue to Zapier, then choose "Google Sheets → Create Spreadsheet Row" as the action. Every code created in Cue becomes a row in your sheet from then on.
Go fully automatic if you need it
For scan totals that update themselves on a schedule, ask your developer to use Cue's developer access (Dashboard → API) with Google's Apps Script — point them at Cue's developer docs.
Good to know
- Cue doesn't send a message per scan, so a sheet can't tick up live scan-by-scan. Scheduled updates (say, hourly or daily totals) cover almost every real reporting need.
- CSV export works on every plan and every analytics view — it's the fastest route to a one-off report.
- The Zapier route logs codes as they're created or changed; it doesn't carry scan numbers. Combine it with the CSV or a scheduled pull for the full picture.
Questions, answered
- Can my Google Sheet update live with every scan?
- Not scan-by-scan — Cue doesn't send per-scan messages. A developer can set the sheet to refresh scan totals on a schedule (hourly or daily), which serves the same purpose for reporting.
- Do I need a paid Cue plan to get my data into Sheets?
- No — CSV export from analytics works on every plan, including free. Automatic updates (Zapier logging or scheduled refresh) need a Business plan, because those use webhooks and developer access.
- What's the easiest place to start?
- The CSV. Export the analytics view you want, open it in Sheets, and see if that covers your reporting. Add Zapier or a scheduled refresh only when the manual step becomes a chore.