Sign-up sheet to the city database
Rows from a Google Form response sheet are loaded each hour into a PostgreSQL table used by the recreation department.
Office & spreadsheetsConnector
Google Sheets integration
for city departments
Google Sheets is where many city teams keep lists that don't have a system yet: event sign-ups, sandbag pickup logs, tree planting requests or a weekly status sheet for council offices.
Pre-built connector
Google Sheets
- Tier
- Pre-built connector
- Category
- Office & spreadsheets
- Sign-in
- Google service account (JWT)
- Paging
- single response
§ Overview
What connecting Google Sheets does.
SentraBridge reads rows from a sheet as records and adds a row for each record a flow sends. A sheet can feed the city database or 311, or receive a daily list from another system. Values pass through without being stored; run history keeps counts.
- Rows: Read rows in a range, like Sheet1, as records.
- Header row: Column headers become field names for the Map step.
- New rows: Append one row per record a flow sends.
What SentraBridge can do with Google Sheets
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Rows (set range, e.g. Sheet1) | list | create | — |
§ Use cases
What cities connect Google Sheets for.
Daily list for a council office
Each morning, yesterday's 311 requests in one council district are added as rows to that office's sheet.
Volunteer roster to Mailchimp
New volunteers in a sheet are added to a Mailchimp audience for the parks newsletter.
Quick status sheet
Open work orders from the city database are written to a shared sheet that managers already check.
§ How it works
How to connect Google Sheets
- 01Get accessCreate a Google Cloud service account and download its JSON key.
- 02Add the connectionEnable the Google Sheets API in that project.
- 03Preview real recordsShare the sheet with the service account's email address.
- 04Turn it onSet the spreadsheet ID and range, then preview rows.
§ Often connected with
Google Sheets and the rest of city hall.
Systems cities commonly connect with Google Sheets, each with its own connector page.
Sentra 311§ FAQ
Google Sheets integration questions
Can Google Sheets sync with a SQL database?
Yes. A flow reads sheet rows and upserts them into SQL Server, PostgreSQL or MySQL, or reads database rows and adds them to a sheet.
Can SentraBridge update existing rows?
The connector reads rows and appends new ones. For two-way edits, keep the system of record in a database and refresh the sheet from it.
Why a service account?
It lets SentraBridge sign in without a person's Google login. Only sheets shared with its email address are reachable.
§ Next
Related connectors
Connect Google Sheets to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.