Auto-Generate Your Monthly Review Email
First of the month? Notis creates a Gmail draft summarizing your Airtable wins, metrics, and goals for the month ahead.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
Why this helps
Founders often forget to document progress or send updates, leading to miscommunication with investors or teams.
- Monthly updates ready to send with minimal edits
- Celebrate progress without extra work
- Built-in accountability for goals and metrics
Setup
Build it in a few focused steps.
- 1Connect Airtable and Gmail to Notis.
- 2Create an automation: 'On the 1st of each month at 8am, create a Gmail draft with my Airtable summary.'
- 3Specify which tables or views to include (e.g., 'completed tasks', 'revenue', 'customer count').
- 4Notis auto-calculates totals, highlights, and trends from your data.
- 5Edit the draft with extra context or insights, then send to stakeholders.
Questions about this workflow
Can I see graphs or charts in the draft?
Notis includes numbers and summaries in the email. For detailed charts, you can link to Airtable dashboards.
What if I want the draft on a different day?
Pick any day of the month. You can also do weekly or quarterly reviews.
Can I compare this month to last month?
Yes. Notis can include month-over-month trends if your Airtable has historical data.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Gmail. A trigger fires from one place; an action lands in another.
Airtable triggers
Gmail actions
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Modify email labels
Adds and/or removes specified gmail labels for a message; ensure `message id` and all `label ids` are valid (use 'listlabels' for custom label ids).
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Create label
Creates a new label with a unique name in the specified user's gmail account.
View Created
Triggers when a new view is created in an Airtable base.
Delete Draft
Permanently deletes a specific gmail draft using its id; ensure the draft exists and the user has necessary permissions for the given `user id`.
View Deleted
Triggers when a previously known Airtable view is deleted.
Delete message
Permanently deletes a specific email message by its id from a gmail mailbox; for `user id`, use 'me' for the authenticated user or an email address to which the authenticated user has delegated access.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Fetch emails
Fetches a list of email messages from a gmail account, supporting filtering, pagination, and optional full content retrieval.
Fetch message by message ID
Fetches a specific email message by its id, provided the `message id` exists and is accessible to the authenticated `user id`.
Fetch Message by Thread ID
Retrieves messages from a gmail thread using its `thread id`, where the thread must be accessible by the specified `user id`.
Connect any two apps with Notis in the middle.
Not just Airtable and Gmail. Any combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Gmail.