Auto-draft emails for filtered sheet data
Leads matching your criteria? Notis drafts outreach. Filter, review, send. No manual segmentation, no repetitive typing.
Trigger
Filtered Range Values Changed
Fires when values in a filtered range change.
Action
Create email draft
Creates a new email draft.
Why this helps
Manually filtering sheet data, then copying each entry into an email draft wastes hours. Most filtered leads go ignored because the effort feels overwhelming.
- Auto-draft emails for every row matching your filter
- Personalize based on filtered columns
- Review in Gmail before sending
- Handle large lead lists without manual work
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Gmail to Notis.
- 2Create an automation: 'When rows in my [Sheet] match [Filter Criteria], create a Gmail draft with a personalized outreach email.'
- 3Set the trigger to 'Filtered Range Values Changed' and define the filter (e.g., 'Industry equals SaaS AND Funding Status equals Series A').
- 4Describe your outreach template in plain language (e.g., 'start with their company name, mention their recent funding round, ask for a quick call').
- 5Test by adding a lead that matches your filter and confirm the draft appears.
Questions about this workflow
How often does Notis check the filter?
Notis polls periodically (typically every 5-15 minutes depending on your settings) and drafts emails for any new rows that match your filter criteria.
Can I segment different outreach for different filters?
Yes. Create multiple automations, each with its own filter and outreach template. For example, one for VCs, another for agencies.
What if I want subject lines to vary?
Tell Notis in your prompt: 'personalize the subject line with their company name' and Notis will vary it per lead.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Gmail. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Gmail actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Modify email labels
Adds or removes labels on an email message.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create email draft
Creates a new email draft.
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
Batch delete Gmail messages
Permanently deletes multiple Gmail messages without moving them to the trash; this cannot be undone.
Cell Range Values Changed
Fires when values in a monitored cell range change.
Create label
Creates a new email label.
Conditional Format Rule Changed
Fires when conditional formatting rules are added, changed, or removed.
Batch modify Gmail messages
Adds or removes labels on multiple Gmail messages.
Data Validation Rule Changed
Fires when data validation rules are added, changed, or removed.
Delete Draft
Permanently deletes an email draft, which cannot be recovered.
Developer Metadata Changed
Fires when developer metadata is added, changed, or removed.
Delete message
Permanently deletes an email message.
Filtered Range Values Changed
Fires when values in a filtered range change.
Create Gmail filter
Creates a Gmail filter to organize incoming messages automatically.
Connect any two apps with Notis in the middle.
Google Sheets and Gmail, or any other combination from 1,500+ 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 Gmail.