Skip to content

Last updated

Spreadsheets and files · data connector

Automated Google Sheets reports, delivered on schedule

Rahoto connects to Google Sheets through Google sign-in with read-only access to your sheets and Drive. Paste the spreadsheet's link, and each tab becomes its own dataset; by default the first row names the columns. When a sheet's columns change, the connection follows the change.

Connect Google Sheets Read connection guidance

What Rahoto reads

The tabs of your spreadsheet

Columns and types are read from the sheet itself, with the first row naming the columns unless you say otherwise.

How you connect

What you need before connecting

Sign-in
Google sign-in (OAuth)
Access requested

https://www.googleapis.com/auth/spreadsheets.readonly , https://www.googleapis.com/auth/drive.readonly

You provide
  • The spreadsheet link (optional)
Defaults
  • Header row: the first row names the columns
  • Empty rows: skipped
  • Cell values: read as formatted in the sheet

Connectors read from your sources and are read-only by default. See the connection guidance for the steps.

How it refreshes

Refreshed on your schedule

Refresh mode: Snapshot, follows schema changes.

  • On each scheduled run Rahoto takes a fresh snapshot of the data and rebuilds the report from it.
  • You can preview the data before you bind it to the page.
  • When the source's columns change, the connection follows the change.
  • Before an issue goes out, Rahoto checks the pages and notices when a source changed shape.

Where the report goes

Delivered where your readers already work

Slack
thread or channel
Teams
channel post
Email
inline or attached
Web
viewer or embed
Webhook
your endpoint
S3
bucket drop
Drive
shared folder
SFTP
your server

Web publishing is on every plan; the other seven channels come with every paid plan. PDF, PowerPoint and PNG travel on any of them.

An example report

Monthly report from a shared sheet

On the date the sheet is due each month, built from Google Sheets.

  1. A cover with the month
  2. Headline figures from named columns of the sheet
  3. A chart for each part of the sheet that matters to the reader
  4. A table of the rows the reader needs to see
  5. A page of notes

The structure of a report, with no figures shown. You design the pages; Rahoto binds them to the data and sends them on schedule. See finished examples in the sample gallery.

Connect Google Sheets and set the schedule

Bind it into the document, check a run, and choose where it goes.

Start 14-day trial Read connection guidance