Skip to main content
Choose Google Sheets on a schedule to write each run into a spreadsheet in your own Google Drive. It is the channel for live dashboards and pivots: point Stockful at a sheet you already built, or let it create files for you.

​
Connect your Google account

Pick Google Sheets as the channel, then Connect Google and approve access. The connection is per user: each staff member connects their own Google account, and a schedule delivers through the account of whoever set it up, into that person’s Drive. Stockful only ever touches files it created or that you hand it through the picker. It cannot see the rest of your Drive.

​
Choose how it writes

The When the report runs setting decides what happens on every run: The first three write into a spreadsheet you already have, so you can layer pivot tables, charts, or a dashboard on top and have Stockful refresh the data. The last one is the hands-off option when you just want a file per run.

​
Pick the target

  • Overwrite / Add rows / New tab each run: choose an existing spreadsheet with Choose spreadsheet. For overwrite and append you then pick the tab to write into. For a new tab each run you set the tab name (see templates below).
  • New file each run: choose a Drive folder and a file name.

​
Templates

The file name (new file mode) and the new tab name accept these tokens:
  • {report_name} the report’s name
  • {schedule_name} the schedule’s name
  • {date} the run date in your store’s timezone, for example 2026-08-04
  • {time} the run time in your store’s timezone, 24-hour, for example 14-30-05
Add {date} so each run stays unique, or {time} as well to separate multiple runs on the same day, for example {report_name} {date} {time}.

​
Formatting

The Formatting options tidy the output:
  • Include a header row writes the column labels as the first row.
  • Freeze and bold the header pins and emphasises row one.
  • Format number columns shows numeric columns as numbers, so they sum and chart correctly. Values are written as plain text where they aren’t numbers, so a leading = is never run as a formula.
  • Auto-size columns fits each column to its content.
  • Add a run date column (append mode) prefixes each run’s rows with the run date, so you can tell runs apart in the continuous table.

​
Send now

Send now works for Google Sheets schedules, so you can fire a test delivery on demand and check the result before the first scheduled run.