Prepare a list field when your sheet structure changes
When your worksheet tabs change to reflect a new kind of work, create a field to capture the detail your list needs.
Trigger
Worksheet Names Changed
Fires when worksheet names change.
Action
Create Field
Creates a custom field on a mailing list.
Why this helps
New categories can appear in a spreadsheet before there's a place to represent them in your email list.
- Detect when worksheet names are added, deleted, or renamed.
- Create a custom field when a new worksheet implies a useful list attribute.
- Reduce the setup gap between spreadsheet organization and list structure.
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 which worksheet-name changes call for a field and what the field should represent.
- 4Pick the Worksheet Names Changed trigger and choose where run reports should go.
- 5Test with one real worksheet name change and verify the custom field on the intended list.
Questions about this workflow
Will any rename create a field?
Describe which changes should prompt field creation. The trigger reports changes to the set of worksheet names.
Can this workflow populate the field for existing contacts?
No. The action creates the custom field; it does not populate or update contact values.
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.