Built in

Google Sheets

Read spreadsheets one Google account can open: targets, budgets and mappings kept in Sheets. It asks only for read access and cannot list your files, so you name each spreadsheet by ID.

What the connection reaches

Spreadsheet metadata and sheet titles
Cell values of one or several ranges
Read only

Status: Built into the pipeline SDK
Connection class: GoogleSheetsConnection
Credential: Google account that can open the spreadsheets

Connect Google Sheets

Three steps, the same for every connection. The credential goes to the platform, never into the repository or pipeline code.

Declare it in connections/connections.py

connections/connections.py

from segmentstream.connections import GoogleSheetsConnection connections = (    GoogleSheetsConnection(key="google_sheets"),)

2
Deploy
```
$ segmentstream deploy
```
3
Connect
Open the connection in the console and sign in with the Google account that can open the spreadsheets, or authorise it from the terminal. Tokens are refreshed by the platform; pipeline code never sees them.
```
$ segmentstream connection authorize google_sheets --open
```

Use it

Code asks for the connection by its key. The platform adds the credential on the way out.

pipeline/ingestion/…

import segmentstream as s with s.get_connection("google_sheets").get_http_client() as client:    response = client.get(        f"/spreadsheets/{spreadsheet_id}/values:batchGet",        params={"ranges": "Budget!A1:F40"},    )    response.raise_for_status()

Or ask your agent

“Load the budget tab of our planning spreadsheet every morning.”

Part of these solutions

Internal tools and dashboards

Pages and dashboards on your records and data

More in Data & files

SupabaseBuilt inTables and views of a Supabase project.ApifyBuilt inScrapers and crawlers, with results paged into your warehouse.AirtableVia APIBases, tables and records.NotionVia APIDatabases and pages shared with your integration.

All integrations →

Enterprise pilot

Want Google Sheets set up for you?

Our forward-deployed engineers build one solution on your data, in your own workspace, as code you own. Tell us what you run today and what you want; your note goes straight to our founder.

One solution, on your data, in your own workspace
First version live in two weeks
Parity proven before anything is switched off
Fixed scope and price, credited to your contract if you continue

Not ready for a pilot? Send the form anyway with your question. An engineer will reply, not a sales rep.

How the pilot works

Connect what your company runs.

Start a pilot

Our engineers build the first version on your data in two weeks, at a fixed price.

Or join the waitlist for self-serve:

Self-serve opens to the waitlist first.