Google Sheets
What Paperbeam reads from Google Sheets, the read-only access it asks for and why, filters, and the beats it feeds.
Data
Read-only OAuth
A metrics sheet (bookings tracker, KPI log): each dated row becomes numbers for the paper.
What we read
- Metric values
Only the reporting window of each edition is read. Paperbeam stores derived facts and short excerpts, not copies of your Google Sheets data, and keeps raw evidence only for your retention period.
Access we ask for, and why
| Scope | Why |
|---|---|
spreadsheets.readonly | Read the one range you choose |
All access is read-only. You can revoke it from Google Sheets at any time, or disconnect the source in Paperbeam.
Connect Google Sheets
- Go to Sources and choose Google Sheets.
- Click Continue to Google Sheets and approve the read-only access in the window that opens.
- The credential is encrypted before it is stored and never shown again. Use Sync now on the source’s page to see what it collects from the last 24 hours, and set filters there.
You need the admin or owner role in Paperbeam, and enough permission in Google Sheets to grant read access to the data listed above.
Filters
Set on the source’s page at Sources›Google Sheets. Filtered-out data is never collected.
| Filter | Effect |
|---|---|
| Spreadsheet | Required. The sheet's link or id. |
| Range | Required. A1 range whose first row is headers and first column is a date. |
| Date column | Optional. Header of the date column; the first column by default. |
| Metric columns | Optional. Headers of the columns to report. Leave empty for every numeric column. |
| Unit | Optional. e.g. USD for money columns. |
To keep specific people, channels or topics out of the paper across all sources, use exclusion rules and the never-mention list in House style.
Beats
Google Sheets is a source for:
Stories land in whichever of your sections fits them best.