The problem: A team member submits content. Someone copies it into HubSpot, formats it, builds the email, and sends it for approval. Repeat 20 times a month. Sound familiar?
For one of our nonprofit clients — a member association that regularly publishes announcements, event invites, and program updates to its community — this manual handoff was eating hours every week and introducing errors along the way. We built a lightweight automation that eliminated it entirely, using tools they already had: Airtable, Zapier, and HubSpot Marketing Hub.
Here's how it works — and how you can build it too.
The Problem in Detail
The client's communications team was managing content submissions from program staff across multiple departments. Staff would email or message in their copy, a comms coordinator would manually create a new marketing email in HubSpot, apply the right template, paste in the content, and route it for review.
The bottlenecks:
- No standardized format for incoming content, so copy was inconsistent
- Emails got created with the wrong template or missing fields
- No audit trail of who submitted what, or when
- The coordinator was a single point of failure
The Stack
- Airtable — intake form + submission database
- Zapier (Code by Zapier) — the logic layer that hits the HubSpot API
- HubSpot Marketing Hub Professional — email drafts, templates, and sending
How It Works
Step 1: Airtable Intake Form
We built an Airtable form with structured fields that map directly to the HubSpot email:
- Subject line
- Preview text
- Headline
- Body copy
- CTA text and URL
- Audience / list segment
- Send date (target)
When a staff member submits the form, it creates a record in an Airtable base. Clean, auditable, timestamped.
Step 2: Zapier Trigger
The Zap triggers on new records in the Airtable base. Zapier picks up the submission the moment it lands.
Step 3: Code by Zapier — Clone + Populate
This is the key step. Rather than creating an email from scratch (which the HubSpot API makes complicated), we:
- Clone a master template email using the HubSpot Marketing Emails API (POST /marketing/v3/emails/{id}/clone)
- Update the cloned email with the submitted content fields (PATCH /marketing/v3/emails/{id})
The Code by Zapier step contains a short JavaScript function that:
- Pulls field values from the Airtable trigger
- Makes the clone call to HubSpot with your API key
- Takes the returned new email ID
- Patches it with subject, preview text, and internal name
- Returns the new email's URL for logging
The result: a fully-named, properly-templated draft email sitting in HubSpot within seconds of submission.
Step 4: HubSpot Review Queue
The draft lands in Marketing → Email with a naming convention that makes it easy to find (e.g., [SUBMISSION] Program Update – 2026-05-28). The comms coordinator reviews, drops in any final edits, and schedules or sends.
What This Eliminated
|
Before |
After |
|---|---|
|
Manual email creation in HubSpot |
Auto-generated draft on submission |
|
Inconsistent copy formatting |
Structured fields enforce consistency |
|
No submission history |
Full audit trail in Airtable |
|
Coordinator as bottleneck |
Coordinator becomes reviewer only |
|
~2–3 hours/week on email setup |
~0 hours — it's just there |
What to Watch Out For
Template email ID. The clone approach depends on a "master" template email in HubSpot that stays intact. If someone deletes it, the Zap breaks. Keep it clearly labeled (e.g., [DO NOT DELETE] Master Email Template) and document the ID somewhere accessible.
HubSpot API rate limits. For high-volume orgs, be aware of HubSpot's API limits. This setup handles standard association volumes (dozens of emails/month) with no issues.
Duplicate protection. Add a filter step in Zapier or a status field in Airtable to prevent re-triggering if a record gets edited after submission.
Is This Right for You?
This pattern works well if you have:
- A team that regularly creates the same type of email (announcements, newsletters, event invites)
- Multiple contributors submitting content to a central comms person
- HubSpot Marketing Hub (Starter or above)
- Zapier at a plan that supports Code by Zapier (Professional or above)
It also generalizes beyond email — the same Airtable → Zapier → HubSpot pattern works for creating deals, enrolling contacts in workflows, or generating tasks in your CRM.
Want to Build This?
Tapp Network specializes in HubSpot automation and content operations for associations and nonprofits. If you want to implement something like this — or audit what your team is doing manually that could be automated — get in touch.
