Export PostgreSQL to Google Sheets
on a schedule, in plain English.

Google Sheets has a hard limit of 10 million cells per spreadsheet. For a table with 20 columns, that's 500,000 rows maximum. rsync.ai warns you at pipeline setup if your query result would exceed the sheet's capacity. For larger datasets, use the postgres-to-s3 pipeline to export to Parquet and query with Athena or BigQuery — Google Sheets is best for operational reports under ~100k rows.

Both modes are supported. Full replace mode clears the sheet and rewrites all rows on each run — safest for reports where the full result set changes (e.g. a daily summary). Incremental append mode appends only new rows, keyed on a monotonically increasing column (id or created_at) — useful for event logs or order feeds where you want cumulative history. You choose the mode in the approve step.

Yes. Each rsync.ai pipeline targets one sheet tab. You can create multiple pipelines pointing to the same spreadsheet but different tabs — e.g. 'orders' tab for the orders query, 'users' tab for the user count summary, 'revenue' tab for the daily revenue rollup. Each pipeline runs on its own schedule independently.

rsync.ai applies the following mapping: INTEGER / BIGINT / SMALLINT → Number (0 decimal places), NUMERIC / DECIMAL → Number or Currency (2 decimal places), REAL / DOUBLE PRECISION → Number (scientific notation for large values), TIMESTAMPTZ / TIMESTAMP → Date+Time (UTC), DATE → Date, TIME → Time, BOOLEAN → Checkbox, TEXT / VARCHAR / CHAR → Text, UUID → Text, JSONB / JSON → Text (serialized as JSON string), arrays → Text (serialized). You can override any format in the approve step.

Service accounts are strongly recommended for scheduled pipelines. OAuth tokens expire and require user re-authorization (typically every 7 days for unverified apps). A service account is a non-human identity that never expires — you share the spreadsheet with the service account email once, and the pipeline runs indefinitely. OAuth is fine for one-off exports or testing. rsync.ai shows you the service account email to share with during setup.

Yes. Describe the schedule in plain English: 'every morning at 8am UTC', 'every Monday at 9am London time', 'every hour', 'every 15 minutes'. rsync.ai converts this to a cron expression and runs the pipeline on that cadence. You can edit the schedule at any time in the UI without touching any config files.

Yes. Mark any column as `masked` — rsync.ai replaces the value with a SHA-256 hash or omits the column entirely from the Sheets export. You can also exclude columns at the SQL query generation step: 'Export orders but exclude the customer_email and phone columns.' rsync.ai removes those columns from the SELECT before running the query.

Yes. The full rsync.ai stack runs on your own infrastructure via `docker compose up`. Your PostgreSQL credentials and Google OAuth tokens or service account keys are stored in a Postgres control plane you also host — nothing leaves your network. License is Elastic License 2.0 — free to self-host, cannot be resold as a managed service.