Shata Solutions
← Back to marketplace
Marketing Automation

Email Campaign

Launch segmented Mailchimp campaigns from Airtable briefs with dynamic content blocks.

Automation overview

What this automation does

This automation starts when airtable campaign row status changes to `Ready`. It hubspot pull segment list, openai personalize preview text, and klaviyo create & schedule campaign, then slack performance snapshot 24h post-send after approval. AI handles generation and decision logic in the middle of the flow.

Trigger
Airtable campaign row status changes to `Ready`
Main actions
HubSpot pull segment list → OpenAI personalize preview text …
Final outcome
Slack performance snapshot 24h post-send after approval
Execution time
1–3 minutes
Apps used
5 integrations
AI-powered
Yes
Difficulty
Intermediate
AIIntermediate
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Airtable
Campaign brief ready
Step 1
HubSpot
Pull segment list
AI
OpenAI
Personalize preview text
Step 3
Klaviyo
Create & schedule campaign
Result
Slack
Performance snapshot
Step-by-step

How each step runs

  1. 1
    AirtableTrigger
    Campaign brief ready

    Airtable campaign row status changes to Ready

  2. 2
    HubSpot
    Pull segment list

    Export HubSpot list for campaign segment

  3. 3
    OpenAI
    Personalize preview text

    GPT-4o personalizes preview text per segment persona

  4. 4
    Klaviyo
    Create & schedule campaign

    Mailchimp campaign with UTM; test to Gmail QA list first

  5. 5
    Slack
    Performance snapshot

    Slack performance snapshot 24h post-send after approval

Apps used

Connected applications

Airtable

Pulls

HubSpot

Pulls

OpenAI

Pulls

Klaviyo

Pulls

Slack

Pulls

Summary

Automation summary

Trigger
Airtable campaign row status changes to `Ready`
Inputs
Airtable campaign row status changes to `Ready`, Business Name, Notification Email, Timezone
Outputs
Slack performance snapshot 24h post-send after approval, OpenAI personalize preview text, Klaviyo create & schedule campaign
Business goal
Automate email campaign end-to-end with accurate app routing.
Execution frequency
Real-time on event
Estimated runtime
1–3 minutes
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Airtable, HubSpot, Klaviyo, OpenAI, AI provider API
Benefits

Why use this automation?

Save ~3 hours/week

Remove repetitive steps from Email Campaign so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Faster response times

Events trigger immediate actions instead of waiting for someone to check a queue.

Requirements

What you need to get started

Required apps

  • Airtable
  • HubSpot
  • Klaviyo
  • OpenAI

Required accounts

  • Active Airtable workspace with API access
  • Active HubSpot workspace with API access
  • Active Klaviyo workspace with API access
  • Active OpenAI workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OpenAI or compatible AI provider API key
  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)
  • Permission to send prompts to your AI provider

Estimated setup time

  • 1 hour including app authorization and test run
  • Difficulty: Intermediate

Optional apps

  • Gmail (optional)
  • Slack (optional)

Automation runtime

Activate this template

PartialSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~15 min

Required connections

  • Airtable(required)
    PreviewAirtable: workflow actions run in preview
    Missing
  • HubSpot(required)
    PreviewHubSpot: workflow actions run in preview
    Missing
  • OpenAI(required)
    Missing
  • mailchimp(required)
    Previewmailchimp: workflow actions run in preview
    Missing
  • Missing connection: Airtable
  • Missing connection: HubSpot
  • Missing connection: OpenAI
  • Missing connection: mailchimp
Manage all connections →View all installations →

Workflow summary

Trigger
Airtable campaign row status changes to `Ready`
Steps
5 nodes
Required apps
4
Optional apps
1

Trigger

New row trigger

Activate this workflow to provision the trigger endpoint.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FeaturedAIPremiumIntermediatePartial1 hour setup4.83.1k installs · 296 reviews
Customize for My Business
Analytics

Template performance

41.5k
Views
3.1k
Installs
641
Favorites
4.8
Avg rating
7.4%
Conversion
1 min
Setup time
93%
Success rate
87
Trending score
Most used integrations
AirtableHubSpotOpenAI

Airtable campaign row status `Ready` pulls segment from HubSpot list export, merges hero copy and product blocks from brief fields, GPT-4o personalizes preview text per segment persona, creates Mailchimp campaign with UTM parameters, sends test to QA Gmail list, and on approval schedules STO send with performance snapshot to Slack 24h post-send.

Some steps run in preview until their integrations go live.

Required apps
AirtablePreviewHubSpotPreviewOpenAILiveMailchimpPreview
Optional apps
SlackLive
All integrations
AirtableHubSpotOpenAIMailchimpSlack
Workflow preview

How Email Campaign runs

1
Trigger
Map brief to template
2
Process
AI decision layer
3
Action
airtable
4
Notify
Alert & log
AirtableHubspotOpenaiMailchimpSlack
Setup steps

Get started in 5 steps

  1. 1
    Connect campaign stack

    Airtable, HubSpot lists, Mailchimp, OpenAI, Gmail QA list, Slack.

  2. 2
    Map brief to template

    Mailchimp template ID, hero image URL, CTA link, product grid slots.

  3. 3
    Configure segmentation

    Each Airtable row links HubSpot list ID or Mailchimp segment tag.

  4. 4
    Set QA approval gate

    Test send to QA; Slack approve button schedules production send.

  5. 5
    Run pilot campaign

    One segment, verify merge tags and UTM on all links.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Brand VoiceselectProfessionalNo
Slack Channeltext#generalNo
FAQ

Frequently asked questions

A/B subject lines?

Enable on Airtable row; Mailchimp A/B config with 4-hour winner pick.

Unsubscribe compliance?

Mailchimp footer mandatory; workflow blocks send without list legal address.

Arabic RTL emails?

RTL Mailchimp template branch when brief language field is Arabic.

Re-send to non-openers?

Optional day-3 branch with alternate subject to non-open segment.

Get started

Customize Email Campaign for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.