MySQL data in Google Sheets,
on the schedule you set.

Google Sheets has a hard limit of 10 million cells per spreadsheet and a practical row limit of around 200,000–500,000 rows per tab before performance degrades noticeably. For most use cases — daily order reports, weekly product summaries, monthly billing exports — this is more than enough. If you need more, consider MySQL → PostgreSQL or MySQL → S3 as a destination, and use Sheets only for summary/aggregated views.

Both modes are supported. Full replace clears the tab and rewrites all rows on every run — simple and always consistent. Incremental mode appends rows where a timestamp or auto-increment column (e.g. `created_at`, `id`) is greater than the last synced value. Incremental is faster for large tables but doesn't update or delete existing rows — use full replace if rows in your MySQL table can change after insert.

Yes. You can set up multiple rsync.ai pipelines pointing to different tabs in the same spreadsheet — for example, one pipeline writes `orders` to the 'Orders' tab, another writes `products` to the 'Products' tab, and a third writes an aggregated summary to the 'Dashboard' tab. Each pipeline runs on its own schedule independently.

MySQL INT, BIGINT, SMALLINT → Number. DECIMAL, FLOAT, DOUBLE → Number (or Currency if the column name contains 'price', 'amount', 'total', 'cost'). DATETIME, TIMESTAMP → Date with time. DATE → Date. TINYINT(1) → Checkbox. VARCHAR, CHAR, TEXT → Text. JSON, BLOB → Text (serialised as string). You can override any mapping in the column review step.

OAuth uses your personal Google account — rsync.ai redirects you through Google's consent screen and receives a refresh token scoped to the specific spreadsheet. Best for personal use or quick setup. Service account is recommended for production: create a service account in Google Cloud Console, download the JSON key, and share the target spreadsheet with the service account email (e.g. rsync-writer@your-project.iam.gserviceaccount.com). The service account gets editor access to only that spreadsheet.

You describe the schedule in plain English: 'every morning at 9am', 'every hour', 'every 15 minutes', 'on weekdays at 8am UTC'. rsync.ai converts this to a cron expression. The minimum interval is 5 minutes (Google Sheets API rate limits make shorter intervals unreliable). You can also trigger a manual run at any time from the rsync.ai UI.

Yes. In the column review step you can mark columns as excluded (not written to Sheets at all), hashed (SHA-256 of the value), or truncated (first N characters only). This is useful when a business team needs access to order data in Sheets but should not see raw customer email addresses or phone numbers.

Yes. rsync.ai runs on your own infrastructure via `docker compose up`. Your MySQL credentials and Google service account key are stored in a Postgres control plane you host. Row data flows directly from your MySQL instance to Google Sheets — nothing transits rsync.ai's servers. License is Elastic License 2.0 — free to self-host, cannot be resold as a managed service.