Email Performance Tracking: Daily Batch Read and Reporting
Every morning, Notis reads all sent emails from Hubspot and logs key metrics (opens, clicks, bounces) to Airtable. You wake up to a daily email performance report without manual checking or data exports.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Read Batch Emails
Retrieves a batch of hubspot email objects by their internal ids or values of a specified unique property, allowing targeted property selection, including historical data.
Why this helps
Email performance is scattered across Hubspot. Checking metrics manually every day is tedious. Monthly reports require data exports and manual compilation.
- Daily email performance report delivered to Airtable automatically
- Spot trends and issues in real time
- Reduce time spent checking metrics manually
- Build historical data for better analysis
Setup
Build it in a few focused steps.
- 1Connect your Hubspot and Airtable accounts to Notis.
- 2Tell Notis: 'Every morning at 8 AM, read all emails from Hubspot sent in the last 24 hours and log their open rates, click rates, and bounce rates to my email metrics Airtable base.'
- 3Set 'notis_cron' with daily frequency.
- 4Pick a Notis channel for notifications.
- 5Notis will report email metrics automatically each day.
Questions about this workflow
What email metrics are tracked?
Opens, clicks, bounces, unsubscribes, click-through rate, open rate, and any custom tracking parameters you set in Hubspot.
Can I filter emails by campaign or sender?
Yes. You can tell Notis to report only on emails from specific campaigns, senders, or with certain tags.
How far back does the daily report look?
By default, it reports on emails from the last 24 hours. You can customize the lookback window.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Hubspot. A trigger fires from one place; an action lands in another.
Airtable triggers
Hubspot actions
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Add asset association
Associates an existing asset ('form', 'object list', or 'external web url') with a specified hubspot marketing campaign.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Add token to event template
Adds a new custom data token to an existing event template for a specified hubspot application, optionally populating a crm object property if objectpropertyname is provided.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Archive email
Archives the hubspot email specified by `emailid` by moving it to the recycling bin, making it inaccessible unless restored.
View Created
Triggers when a new view is created in an Airtable base.
Archive a batch of emails by ID
Archives multiple hubspot crm emails by id; ids must exist as archiving is irreversible.
View Deleted
Triggers when a previously known Airtable view is deleted.
Archive a batch of quotes by id
Archives a batch of existing, non-archived quotes by their ids; this action is irreversible and useful for managing outdated or irrelevant quotes.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Archive batch of companies by id
Archives a batch of companies by their unique ids; targeted companies must exist, not be previously archived, and this api operation is irreversible.
Archive batch of contacts by id
Archives a batch of existing contacts by their hubspot crm ids, rendering them inactive; this action is irreversible via the api and requires manual restoration or a separate unarchive endpoint.
Archive batch of deals by id
Archives a batch of existing deals by their unique hubspot ids, removing them from active views and reports (soft delete); archived deals may be restorable.
Connect any two apps with Notis in the middle.
Not just Airtable and Hubspot. 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 Hubspot.