MARKETING
Auto-Send a Win-Back Email After Three Missed Opens
Daily, finds subscribers who haven't opened the last three consecutive newsletters in BigQuery, sends each a personalized win-back email via Gmail.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionFind subscribers with three consecutive missed opensBigQuery
- LogicPersonalize win-back template per subscriber
- ActionSend win-back emailGmail
- OutputLog outreach to Airtable suppression listAirtable
What it does
This workflow acts on a clear disengagement pattern — three straight non-opens — and intervenes automatically. It identifies the exact subscribers who crossed that line, sends each a personalized win-back message, and records the outreach so the same person isn't pinged again next cycle. It converts a passive churn signal into a concrete recovery action without manual list-pulling.
When to use it
Use it when you want a hands-off re-engagement step for subscribers showing early churn behavior, before they fully lapse or unsubscribe. Best for lists where a single, well-timed nudge has a track record of reviving readers.
How it works
- 1A daily schedule starts the run.
- 2BigQuery returns subscribers whose last three sends all show no open and who have no logged win-back in the cooldown window.
- 3A logic step assembles each subscriber's name and last-engaged date into the email template.
- 4Gmail sends the personalized win-back email per subscriber.
- 5Each send is written to an Airtable suppression log with a timestamp.
- 6The log feeds back into the next day's query so contacted readers are excluded.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect GmailRead, draft, send, label.
- 3Connect AirtableBases, tables, views, automations.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
Agentic UTM Taxonomy Steward: Detect, Explain, and Propose Fixes
An agent reviews the full backlog of campaign links in Airtable, reasons about taxonomy drift beyond rigid rules, drafts standardized replacements for malformed UTMs.
Slack UTM Check: Paste a Link, Get an Instant Verdict
Lets marketers drop a tracking URL into a Slack channel and get an immediate threaded reply that says whether the UTMs are valid, what is wrong, and a corrected suggestion.
Backlink Outreach Drafter for Verified Mentions
Picks verified, high-authority unlinked mentions from Airtable, drafts a personalized backlink-request email for each.
Source-Authority Verifier for Mention Provenance
Takes a queue of detected brand mentions and runs an agent that verifies whether each source is a legitimate, authoritative publisher versus a scraper or syndication copy.
Unlinked Brand-Mention Detector with Authority Scoring
Scans the web for fresh brand mentions, filters to ones that name you without linking back, scores the publishing domain's authority.
Weekly Brand-Mention Provenance Digest to Notion
Aggregates the week's tracked mentions from Airtable into a single summarized report covering new opportunities, authority distribution, and outreach progress.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.