Google Sheets Automation, Workflows & Approvals
Run Google Sheets on autopilot. Keep the veto.
52 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, no 3am stomach-drop wondering what shipped while you slept.
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 52 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.