Broadcast new opportunities to your team in seconds
New row in your sheet? Team gets an email. No Slack ping, no manual copy. Notis handles the broadcast.
Trigger
New Rows in Google Sheet
Fires when new rows are added to a sheet.
Action
Send Email
Immediately sends an email; sending is irreversible.
Why this helps
Manually copying opportunity details into team emails or Slack wastes time and misses people. Opportunities sit unassigned until someone notices.
- Instant team notification for every new opportunity
- Formatted email with all relevant details
- No manual forwarding or retyping
- Everyone stays aligned on new prospects
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Gmail to Notis.
- 2Create an automation: 'When a new row is added to my Opportunities sheet, send an email to [Team Lead or Distribution List] with the opportunity details.'
- 3Set the trigger to 'New Rows in Google Sheet' and select your opportunities sheet.
- 4Specify the recipients (individual emails, Gmail distribution list, or look up from a sheet column).
- 5Test by adding a new opportunity row and confirm the email reaches your team.
Questions about this workflow
Can I send to different people based on the opportunity type?
Yes. Use conditions like 'if the category is Enterprise, email the VP. If it's SMB, email the sales manager.' Notis routes based on your rules.
What if I want to include attachments?
Reference files stored in a sheet column (Google Drive links or S3 paths) and Notis will attach them to the email.
Can I exclude certain rows from triggering emails?
Yes. Set conditions in your prompt, like 'skip if the source is not-yet-qualified' to avoid notification noise.
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.