Adjust Agenty input when a sheet table changes
When table columns or inferred formats change, update the input configuration for the agent that relies on that table.
Trigger
Table Schema Changed
Polling trigger that detects when a table's schema changes in Google Sheets. Monitors columns added/removed/renamed and inferred type/format changes. Uses snapshot-based diffing to compare schemas between polls.
Action
Update Input by Agent ID
Tool to update agent input by agent id. use when you need to modify an agent's input source (url, manual data, list, or agent) after verifying the agent id.
Why this helps
A changed table structure can disrupt an agent's source setup, and the mismatch may go unnoticed.
- Respond to table column or inferred format changes.
- Keep an agent's input configuration aligned with its source.
- Reduce time spent spotting and fixing structural mismatches.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Agenty once in the Notis portal.
- 2Create an automation in the portal or tell Notis the outcome in plain language.
- 3In one instruction, identify the existing agent and explain how its input should change when the table schema changes.
- 4Pick the Table Schema Changed trigger and choose where run reports should go.
- 5Test with one real schema change and review the agent input configuration.
Questions about this workflow
Does this rewrite the table schema?
No. The trigger detects schema changes in Google Sheets, and the action updates an Agenty agent's input.
What if a new column has an unknown meaning?
Provide the intended interpretation in your instruction or review the run report before relying on the updated input.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Agenty. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Agenty actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Clone Agent by ID
Tool to clone an existing agent by its id. use when you need to duplicate an agent's configuration and optionally start the clone immediately.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Agent
Tool to create a new agent. use when you need to add an agent with configuration and optional auto-start.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Get Agent Templates
Tool to fetch all public agent templates and sample agents. use when listing available templates for users to select.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Delete Agent by ID
Tool to delete a single agent by its id. use when you need to permanently remove an agent after confirming it exists.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Fetch all agents
Tool to fetch all active agents under an account. use after authenticating when you need to list agents with pagination and sorting.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get Agent by ID
Tool to fetch details of a specific agent by its id. use when you need full agent configuration before taking further actions.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Update Agent by ID
Tool to update an agent's configuration and settings by agent id. use when you need to modify an existing agent after retrieving its current settings. example: "update agent 123 with new name and tags."
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Create API Key
Tool to create a new api key. use when you need to provision access credentials for the api.
Connect any two apps with Notis in the middle.
Google Sheets and Agenty, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Agenty.