Mark list milestones from a changing sheet metric
Let a meaningful change in your sheet become a clear segmentation marker for your email list.
Trigger
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
Action
Create Tag
Creates a tag on a mailing list for contact organization.
Why this helps
Milestones tracked in a spreadsheet are easy to notice late, leaving list organization and follow-up behind.
- Notice when a monitored total or count changes.
- Create a tag that makes a list milestone easier to recognize.
- Reduce manual checks of spreadsheet metrics.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and EmailOctopus once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the outcome in plain language from any channel.
- 3In one instruction, state what the aggregate represents and the tag name to create when its value changes.
- 4Pick the Aggregate Metric Changed trigger and choose where run reports should go.
- 5Test with one real metric change and confirm the tag is created on the intended list.
Questions about this workflow
Which metrics can trigger this workflow?
The event supports SUM, COUNT, AVG, MIN, or MAX on a target column, optionally filtered by a search column and value.
Does this tag individual contacts automatically?
The selected action creates a tag on a list. It does not apply that tag to individual contacts.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Emailoctopus. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Emailoctopus actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Contact
Add a new contact to a mailing list.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create List
Create a mailing list to organize email contacts.
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
Create Field
Creates a custom field on a mailing list.
Cell Range Values Changed
Fires when values in a monitored cell range change.
Delete Contact
Permanently delete a contact and its list data; this cannot be undone.
Conditional Format Rule Changed
Fires when conditional formatting rules are added, changed, or removed.
Delete List
Delete a mailing list and all its contacts permanently; this cannot be undone.
Data Validation Rule Changed
Fires when data validation rules are added, changed, or removed.
Create Tag
Creates a tag on a mailing list for contact organization.
Developer Metadata Changed
Fires when developer metadata is added, changed, or removed.
Get All Lists
Retrieve all mailing lists in the account.
Filtered Range Values Changed
Fires when values in a filtered range change.
Get Recent Campaigns
Retrieves recent campaigns from your EmailOctopus account.
Connect any two apps with Notis in the middle.
Google Sheets and Emailoctopus, 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 Emailoctopus.