Google Sheets Automation, Workflows & Approvals
Run Google Sheets on autopilot. Keep the veto.
53 actions16 triggers
A row change fires, a batch update goes out, and the data your whole workflow depends on shifts before you had a chance to review it. Rills proposes every write; you approve.
Interactive. No signup. 14 days free · approvals always free.
Most automation fires first, asks later. Rills shows you the change before it ships.
Every consequential productivity action from Google Sheets arrives on your phone first. Approve in seconds. Decline without explaining yourself. Workflows wait, paused at zero cost, until you decide.
Queue 3
Upsert 34 rows in the Q2 pipeline tracker sheet?
34 rows · filter match: status = 'Pending Review'
Same upsert pattern ran cleanly last Monday
2 rows overlap with records flagged for manual edit
Free to wait. Free to think.
Approvals and logic don't cost a credit. Pause a workflow for three hours or three weeks. The price is the same: zero. You only pay when something real happens: an AI call, an outbound action.
Approve from your phone in five seconds.
Swipe right when you're sure. Decline when you're not. Between meetings, mid-coffee, on the train. No dashboard to babysit, no inbox triage, and no surprise send you find out about after it's already out the door.
Routine cases graduate themselves.
Every approval feeds a confidence score for that exact workflow shape. The obvious cases (the ones you've green-lit fifty times) start running on their own. The judgment calls still come to you.
About Google Sheets automation
Rows get appended, ranges get cleared, and validation rules get rewritten while you're looking the other way. By the time a teammate notices the data is wrong, three downstream reports have already pulled from it.
When Google Sheets runs unsupervised
A single unchecked write to the wrong range can corrupt every formula that reads it, and Google Sheets automation offers no pause between trigger and action.
- New rows trigger fires an upsert that overwrites an existing record you hadn't marked for update, silently dropping the original data.
- Cell range values changed kicks off a batch value update across a filtered range, and the filter conditions were stale from last week's schema.
- Filtered range values changed fires a clear-spreadsheet-values operation on what turns out to be the wrong tab, wiping a client-facing report before anyone noticed.
- Table schema changed triggers a column delete that removes a dimension still referenced in three other sheets.
- Spreadsheet row changed sends an append to a summary tracker that already has duplicate entries, compounding the error with every run.
What Rills does inside Google Sheets
Rills intercepts proposed writes, such as upsert rows, batch update values by data filter, and delete dimension operations, and holds them for your review before any cell in the sheet changes.
The row still gets updated; you just see the proposed change first.
When Google Sheets events should and shouldn't act on their own
Some triggers are routine enough that, over time, Rills confidence scoring can graduate them to autonomous. Others touch data that's too consequential to ship without a human call.
- GOOGLESHEETS_NEW_ROWS_TRIGGER: Appending intake-form submissions to a log sheet is predictable; confidence builds quickly with no judgment required.
- GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGER: A metric shift could mean normal fluctuation or a broken formula; the difference matters and warrants a human look every time.
- GOOGLESHEETS_SPREADSHEET_SEARCH_MATCH_TRIGGER: Matching a search pattern to approve Google Sheets records for a CRM sync is low-risk and a strong candidate for eventual autonomy.
- GOOGLESHEETS_DATA_VALIDATION_RULE_CHANGED_TRIGGER: Validation rules govern what every future row can contain; changing them without review risks breaking the entire productivity layer built on top.
- GOOGLESHEETS_FILTERED_RANGE_VALUES_CHANGED_TRIGGER: Scope of the affected range is hard to predict at runtime, so every proposed write to a filtered range should wait for your call.
What wakes Rills up in Google Sheets
When these events fire, Rills proposes the next move and waits for your call.
GOOGLESHEETS AGGREGATE METRIC CHANGED
Fires when a calculation like sum, count, average, minimum, or maximum changes for a specific column. Use this to trigger alerts or workflows when key metrics shift.
GOOGLESHEETS CELL RANGE VALUES CHANGED
Fires when values change in a specified cell or range of cells. Use this to trigger actions whenever specific data points are updated.
GOOGLESHEETS NEW ROWS
Fires when new rows are added to a spreadsheet. Use this to automatically process, notify about, or sync new data entries.
GOOGLESHEETS NEW SPREADSHEET CREATED
Fires when a new spreadsheet is created. Use this to automatically initialize new spreadsheets with templates, permissions, or integrations.
GOOGLESHEETS SPREADSHEET ROW CHANGED
Fires when a specific row's values change, or when a row you're tracking appears or disappears. Use this to monitor individual records and react to their updates.
What Rills can do in Google Sheets
6 of 53 actions across reads, writes, and updates.
- 01
Execute SQL on Spreadsheet
Query and modify Google Sheets data using SQL syntax, allowing you to perform complex searches, updates, and data transformations without leaving your spreadsheet. This operation automatically recognizes your sheet structure and supports SELECT, INSERT, UPDATE, and DELETE commands.
- 02
Look up spreadsheet row
Search for the first row in a Google Spreadsheet that exactly matches a specific value, automatically locating the data you need without manual scrolling. This helps you quickly find customer records, inventory items, or any specific information stored in your sheets.
- 03
Upsert Rows (Smart Update/Insert)
Intelligently updates existing rows in a spreadsheet by matching a key column, or inserts new rows if no match is found, while automatically handling column mapping and partial updates without disrupting other data.
- 04
Create a Google Sheet
Creates a new Google Sheet in your Google Drive with an optional custom name and location. Use this to quickly set up spreadsheets for tracking, analysis, or collaboration without leaving your workflow.
- 05
Append Values to Spreadsheet
Adds new rows of data to the end of your Google Sheet without overwriting existing information. Perfect for continuously building datasets like customer records, sales logs, or inventory updates.
- 06
Find and Replace in Spreadsheet
Quickly find and replace text, numbers, or formulas across your entire spreadsheet to fix errors, update information, or clean up data in bulk. This saves hours of manual cell-by-cell editing when you need to make consistent changes throughout your sheet.
Common questions about Google Sheets automation
How do I automate Google Sheets row updates without losing control?
Rills watches your sheet for new or changed rows, then proposes the update action before anything writes. You review the proposed change from your phone and approve it. Nothing upserts, clears, or overwrites until you say so.
Can I get mobile approvals before Rills deletes rows or columns?
Yes. Destructive operations like deleting rows or columns sit in your mobile approval queue first. You see exactly what Rills proposes to remove, approve or reject from your phone, and only then does it execute. No accidental data loss.
How do I automate Google Sheets data validation rules safely?
Rills can propose setting or changing data validation rules when a trigger fires, like a new sheet being added or a table schema change. The proposed rule waits for your approval before it applies, so a bad rule never silently breaks a live sheet.
Can Rills notify me before it copies a sheet to another spreadsheet?
Every Google Sheets automation action Rills proposes, including copying a sheet to another spreadsheet, goes into your approval queue. You decide before it ships. If the copy looks wrong, you reject it and nothing moves.
How do I automate Google Sheets reporting without AI messing up my data?
Rills monitors filtered range changes or aggregate metric shifts, then proposes actions like creating a chart or batching value updates. You approve the proposal from your phone before any cell or chart changes. Your spreadsheet stays exactly as you left it until you greenlight the next step.
How is Rills different from Zapier for Google Sheets automation?
Zapier fires and ships. The moment a trigger hits, the action runs. Rills holds the proposed action in a queue and waits for your call. For Google Sheets, that means no row getting deleted, no values getting cleared, and no conditional format rule getting overwritten before you've seen what AI wants to do.
Does Rills support Google Sheets change triggers like new rows or schema changes?
Yes. Rills supports triggers including new rows, row changes, filtered range value changes, table schema changes, new sheets added, and spreadsheet search matches. Each trigger can start a workflow that proposes an action, which then waits for approval before executing.
How much does Rills cost for Google Sheets automation?
Approvals and workflow logic are free. You only pay when Rills executes a real action, like an AI call or an external write to your spreadsheet. Reviewing proposals from your phone, setting up triggers, and building approval flows costs nothing.
Pair Google Sheets with your stack
Cross-tool workflows that propose actions and wait for your approval.