Add qualified, opted-in leads after a sheet metric changes
A changing pipeline metric can be a cue to review lead rows. Notis can add qualifying contacts when the row includes the details and consent your instruction requires.
Trigger
Aggregate Metric Changed
Triggers when an aggregate calculation in a spreadsheet changes.
Action
Create Contact
Add a new contact to a mailing list.
Why this helps
Leads may become ready for follow-up while you are focused on the metric rather than the individual records behind it.
- Use a metric change as a prompt to review underlying lead records.
- Apply your qualification and consent rules before creating a contact.
- Keep the decision tied to data returned from the sheet.
Setup
Build it in a few focused steps.
- 1Connect Google Super and EmailOctopus once in the Notis portal.
- 2Create an automation in the portal or tell Notis in plain language from any channel.
- 3State the qualification rule, consent requirement, and how to identify eligible lead rows before creating contacts.
- 4Pick Aggregate Metric Changed as the trigger and choose where run reports go.
- 5Test with one real metric change and verify that only eligible contacts were added.
Questions about this workflow
Does the aggregate trigger provide every lead's details?
It monitors an aggregate calculation. Your instruction should specify how to review the relevant underlying rows, and the needed data must be available to Notis.
Will a metric change add every lead in the sheet?
No. Instruct Notis to create contacts only when the available row data meets your qualification and clear consent requirements.
What if the metric changes but no lead qualifies?
Have Notis report the result without creating contacts.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Emailoctopus. A trigger fires from one place; an action lands in another.
Google Super 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
Triggers when an aggregate calculation in a spreadsheet changes.
Create Field
Creates a custom field on a mailing list.
Attendee Response Changed
Triggers when an attendee accepts, declines, or tentatively responds to an invitation.
Delete Contact
Permanently delete a contact and its list data; this cannot be undone.
Cell Range Values Changed
Triggers when values change in a specified spreadsheet range.
Delete List
Delete a mailing list and all its contacts permanently; this cannot be undone.
Comment Added (Docs/Sheets/Slides)
Triggers when someone adds a comment to a document, sheet, or presentation.
Create Tag
Creates a tag on a mailing list for contact organization.
Conditional Format Rule Changed
Triggers when spreadsheet conditional formatting rules are added, changed, or removed.
Get All Lists
Retrieve all mailing lists in the account.
Data Validation Rule Changed
Triggers when spreadsheet data validation rules change.
Get Recent Campaigns
Retrieves recent campaigns from your EmailOctopus account.
Connect any two apps with Notis in the middle.
Google Super 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.