Carry spreadsheet opt-outs into EmailOctopus
A recorded opt-out can prompt the corresponding unsubscribe action without another manual handoff.
Trigger
Cell Range Values Changed
Fires when values in a monitored cell range change.
Action
Unsubscribe Contact
Unsubscribes a contact from a mailing list while keeping their record.
Why this helps
An opt-out noted in a sheet can be overlooked when someone still has to update the email list separately.
- Reduce the chance an opt-out stays only in a spreadsheet.
- Promptly unsubscribe the identified contact from the intended list.
- Keep a run report of the automation's handling.
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, explain how an opt-out is represented in the watched range and how to identify the contact email.
- 4Pick the Cell Range Values Changed trigger and choose where run reports should go.
- 5Test with one real opt-out example and verify the contact is unsubscribed from the intended list.
Questions about this workflow
What causes the workflow to run?
It runs when values change in the specified cell or range in Google Sheets.
What information does Notis need to unsubscribe someone?
The changed values need to identify the contact by email and give enough context to select the intended EmailOctopus list.
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.