01What syncing a sheet actually means
If your leads, bookings, prices or stock levels already live in a Google Sheet, you have a working data source without buying anything. The title of this post is an opinion, not a statistic: we have not counted how many automations start in a spreadsheet, and we publish no such figure. The claim we can make is narrower. A sheet is a cheap place to write a process down, so it is a sensible place to start. Before you pick a tool, decide the direction. Rows can come into the sheet from somewhere else, such as a form. Rows can leave it, such as a new row that should create a contact or send an email. Or you want both, which is the hardest of the three, in our view. Each direction has a different documented route, and the rest of this post goes through them in order.
- Into the sheet: form answers, orders and enquiries arrive as rows
- Out of the sheet: a new or changed row triggers an email, a CRM entry or a message
- Both ways: the same fact lives in two places, so decide which copy wins when they disagree
- We have no count of how many automations begin in a spreadsheet, and we state none
02Four ways to connect a sheet, and what each page says
Google Forms is the simplest. In Forms you open Responses, then Summary, choose More, then Select destination for responses, and pick a new or existing spreadsheet (support.google.com/docs/answer/2917686). Unlinking stops new responses and leaves the existing data in place. Apps Script is the next step. Google's triggers page (developers.google.com/apps-script/guides/triggers) lists simple triggers such as onEdit, and installable triggers for open, change, form submit and time-driven runs. Simple triggers cannot access services that require authorization and cannot run longer than 30 seconds. The same page says script executions and API requests do not cause triggers to run, and gives the example that Range.setValue() does not fire onEdit. So if another tool writes into your sheet, an onEdit script will not notice. No-code tools are third. Zapier's Google Sheets page lists 7 triggers, including New Spreadsheet Row, Updated Spreadsheet Row and New or Updated Spreadsheet Row, and marks some as instant and others as polling, every 15 minutes on the Free plan. Make lists Watch New Rows and Watch Changes, and says Watch Changes sees only edits made in the Google Sheets app and needs a webhook set up with the Make add-on or a script. n8n has an app node listing actions such as Append Row, Update Row and Get Row(s), and a separate Google Sheets Trigger node with the events Row added, Row updated and Row added or updated. How each tool bills is in our post on Zapier, Make and n8n, so we skip prices here. The fourth route is the Sheets API with your own code.
- Google Forms: form to sheet, one direction, set up from the Responses tab
- Apps Script: triggers for edit, change, form submit and timed runs, but edits made by a script or the API fire none
- Zapier: 7 Google Sheets triggers listed, some instant, some polling every 15 minutes on the Free plan
- Make: Watch New Rows and Watch Changes; the latter sees only edits made in the Google Sheets app and needs a webhook set up with the Make add-on or a script
- n8n: an app node with actions such as Append Row, Update Row and Get Row(s), and a separate Google Sheets Trigger node with the events Row added, Row updated and Row added or updated
- All pages were opened on 20 October 2026. Vendors change them, so check before you build
03Limits to check before the sheet becomes your system
Google publishes the numbers. A spreadsheet created in or converted to Google Sheets holds up to 20 million cells or 100MB (support.google.com/drive/answer/37603). Apps Script allows 6 minutes per execution, and total trigger runtime of 90 minutes a day on a consumer account or 6 hours a day on Google Workspace. That page, updated 3 September 2026, says quotas are subject to change without notice (developers.google.com/apps-script/guides/services/quotas). The Sheets API allows 300 read and 300 write requests a minute per project, and 60 of each per user per project. Calls over the quota return HTTP 429 (developers.google.com/workspace/sheets/api/limits). A worked example, our arithmetic and not a Google figure: if a flow writes each new order as its own request from one user's credentials, the 61st order in the same minute goes over the 60-request limit. In our view you meet other problems before the cell cap: two people editing one row, a renamed column that breaks the flow, a script edit that fires nothing. That is our judgement, not a statement from Google.
- Spreadsheet size: up to 20 million cells or 100MB (support.google.com/drive/answer/37603)
- Apps Script: 6 minutes per execution; trigger runtime 90 minutes a day (consumer) or 6 hours a day (Workspace)
- Sheets API: 300 per minute per project and 60 per user per project, for reads and for writes; over the quota returns HTTP 429
- Signs to move off the sheet, in our view: a renamed or moved column breaks the flow, or records arrive faster than one account can write them
04Where PROOF48 is the wrong choice
If all you need is a form that fills a sheet, use Google Forms and stop there. If you can build one or two flows yourself, a no-code subscription costs far less than AUTOMATE, which is 2,997 EUR a month. AUTOMATE lists everything in GROWTH, an AI website chatbot that qualifies and books, DM and email auto-responders, booking automation with a CRM, automated review management and two custom automations a month. It does not list Google Sheets, and it does not cover WhatsApp or phone. PROOF48 has published no case study of a Google Sheets sync, so we have no result to quote. Where we fit is the business whose sheet has grown into the system and now needs replacing. That is a web app, from 5,000 EUR, with its own timeline, and larger or custom projects may need a deposit as agreed in our terms. Our post on the signs you need a web app rather than a website covers that line. Standalone automation work is scoped and priced on request through the start page.
- A form that fills a sheet: use Google Forms, skip PROOF48
- One or two flows you can build yourself: buy a no-code subscription, skip AUTOMATE
- AUTOMATE lists no Google Sheets feature and no WhatsApp or phone coverage
- A sheet that has become the system is a web app project, from 5,000 EUR, and a deposit may be agreed for larger work
A rotisserie order that does not pass through a sheet
Rotiseria Baba Novac takes orders through Stripe checkout with pickup slots and sends a confirmation email through Resend on every order. Its stack lists PostgreSQL, a database, and the build includes an admin view the kitchen uses during service. We do not claim the restaurant ever kept orders in a spreadsheet, and we hold no figures on its order volume or on what the system saved, so we state none. The only lesson we draw is narrow: in our view, when orders, payments and kitchen staff all depend on one record, that record belongs in a purpose-built system rather than a sheet.
See the build: Rotiseria Baba NovacQuestions, answered
Can Google Sheets update my other apps automatically?
Through a trigger, yes. Apps Script has installable triggers for change, form submit and time-driven runs, and Zapier and Make list triggers for new rows. Each has its own limits, described above.
Why did my onEdit script not run when another tool added a row?
Google's triggers page says script executions and API requests do not cause triggers to run, and uses Range.setValue() as its example. An onEdit trigger reacts to edits made by a person in the sheet.
How big can a Google Sheet get?
Google's help page says up to 20 million cells or 100MB for spreadsheets created in or converted to Google Sheets. It states no limit on columns or tabs on that page.
Does PROOF48 set up Google Sheets syncs?
AUTOMATE does not list Google Sheets, and we have published no case study of one. It includes two custom automations a month, and standalone work is scoped and priced on request. Tell us the workflow and we say whether it is worth building or worth a subscription you run yourself.
Where PROOF48 fits
Decide the direction first: rows into the sheet, rows out of it, or both. Google Forms, Apps Script, Zapier, Make, n8n and the Sheets API each cover part of that, with limits their own pages state, such as 20 million cells per spreadsheet and 60 write requests a minute per user in the API. Edits made by a script or the API do not fire an onEdit trigger. PROOF48's AUTOMATE does not list Google Sheets, so check your workflow against its contents before you assume a fit.
Cosmin Tiu · Founder, PROOF48
Cosmin has worked in online marketing and software development since 2018, and has built with AI every day since January 2023. He still writes code from scratch daily, in Python, React, Rust and C#. PROOF48 ships business websites in 48 hours and invoices afterwards, so every opinion on this blog was paid for in real builds, not in theory.