Create a Benchmark Email list when a new sheet is added
Starting a new audience or campaign project often means setting up the same structure twice. Use a new sheet as the cue to create its corresponding Benchmark Email list.
Trigger
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
Action
Create Contact List
Tool to create a new contact list. use after planning list name and optional description.
Why this helps
A new worksheet can be ready for data while the matching email list is still waiting to be created.
- Create a matching list when a worksheet is added
- Make list setup part of the same repeatable workflow
- Spend less time switching between spreadsheet and email tools
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Benchmark Email once in the Notis portal.
- 2Create a new automation and give it a clear name.
- 3In one instruction, tell Notis to create a Benchmark Email contact list based on the new worksheet and specify any naming convention or description.
- 4Pick the New Sheet Added in Google Spreadsheet trigger and choose where run reports should go.
- 5Test with one real new worksheet and review the created list.
Questions about this workflow
Does this copy worksheet rows into the list?
No. The action creates a contact list. Use a separate workflow with the new-row trigger to add contacts.
Can I control the list name?
Yes. Include your preferred naming convention and any description in the instruction.
What starts the workflow?
The New Sheet Added in Google Spreadsheet trigger detects a newly added worksheet tab.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Benchmark email. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Benchmark email actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Delete Contact From List
Tool to delete a contact from a specific list by contactid. use when you have list and contact ids. example: "delete contact 2040826674 from list 15257899"
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Contact List
Tool to delete a contact list. use after confirming that the list is no longer in use.
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.
Delete Email Campaign
Tool to delete an email campaign. use when removing a campaign by its id. use after confirming the campaign id is correct.
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 Linked Agency Account
Tool to delete a linked agency account. use when revoking a linked agency account by its id. use after confirming the account id is correct.
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.
Delete Webhook
Tool to delete a webhook from a contact list by its id. use when removing obsolete or invalid webhooks after confirming list and webhook details.
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 All Confirmed Emails
Tool to retrieve all confirmed email addresses for the client account. use after user completes email confirmation flows to fetch final list.
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.
Get Client Account Settings
Tool to get client account settings such as company, language, timezone, and sender info. use when you need to fetch account configuration before sending campaigns.
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.
Get client details
Tool to get client details including profile data, contact count, and plan information. use when verifying account profile and limits.
Connect any two apps with Notis in the middle.
Google Sheets and Benchmark email, 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 Benchmark email.