Push your data to a Google Sheet

Connect Google Sheets

Before you can push anywhere, you need to connect Google Sheets as an additional platform. This is separate from Google Ads — Sheets uses a different OAuth scope (drive.file) and its own connection card on the dashboard.

1. Open Connections and click Connect Google Sheets.
2. Sign in with the Google account that owns the Sheet you want to use.
3. Approve the permission prompt.

You can use a different Google identity for Sheets than the one you used for Google Ads — most users do.

Pick or create a Sheet

You have two options when you set up a destination:

• Pick an existing Sheetusing the Google Picker. Only Sheets you select via the Picker become accessible to Crowflow — we can’t see anything else in your Drive.
• Create a new Sheet from scratch. Crowflow makes a fresh Sheet, names it, and remembers its ID.

Either way, the result is the same: a destination row pointing at a specific spreadsheet ID. You can have multiple destinations (Pro plan) — useful for sharing different views with different clients.

Choose a tab name

Default tab name is Crowflow data. You can change it to anything you like. If the tab doesn’t exist when the push runs, Crowflow creates it. If it does, Crowflow writes there.

REPLACE vs APPEND

Each destination has a mode:

• REPLACE(default) — every push clears the tab and writes the full filtered window from scratch. Good when you want your tab to reflect “the last 30 days” and not grow indefinitely.
• APPEND— every push adds only rows newer than the latest date already in the tab. Good for archival, year-over-year reporting, or when your Sheet feeds a chart you don’t want to disturb.

You can flip modes any time from the destination card on the dashboard. The next push respects the new mode.

Filters

By default, every destination receives every platform and the last 30 days. You can narrow it from the destination card:

• Platforms— restrict to Google, Microsoft, or Meta (or any combination). Leave all on for “everything.”
• Days— choose a rolling window from 7 to 90. Useful when one Sheet is for “this week” and another for “this quarter.”

When the push runs

A push runs automatically right after a successful sync — so once Crowflow has new data, your Sheet has it too within seconds.

You can also trigger a push manually from the destination card if you’ve, say, just changed the filter window and want to see it reflected immediately.

Why drive.file is the right scope

Crowflow uses the drive.fileOAuth scope — the narrowest one Google offers for the Sheets API. It’s a non-sensitive scope, which means:

• We can only access Sheets you create with Crowflow or explicitly pick via the Google Picker.
• We cannot list, search, or read anything else in your Drive.
• Even our database doesn’t store a way to discover other Sheets you own — we only know about the ones you’ve told us about.

This is intentional: the right level of trust for a tool you install once and forget about. See our Security § OAuth for more.