MARKETING
Daily Abandoned-Cart Digest with Trend Snapshot
Runs each morning to pull yesterday's expired Stripe checkouts, summarize lost revenue and top abandoned products, and email the marketing team a digest.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily morning schedule fires
- ActionList Stripe checkouts expired in last 24hStripe
- LogicAggregate lost revenue and rank top abandoned products
- ActionAppend daily totals to trend sheetGoogle Drive
- OutputEmail digest to marketing teamGmail
What it does
This workflow gives the marketing team a daily pulse on abandonment. Every morning it queries the prior day's expired Stripe checkouts, tallies total lost revenue, ranks the most-abandoned products, and emails a clean digest so the team can spot patterns instead of reacting cart by cart.
When to use it
Use it when you want a recurring read on cart-abandonment health rather than per-event automation. It surfaces problem products, pricing friction, and week-over-week trends that single-cart alerts hide.
How it works
- 1A daily schedule trigger fires each morning at a set time.
- 2The flow lists all Stripe checkout sessions that expired in the previous 24 hours.
- 3A logic step aggregates the results: total lost value, count of abandoned carts, and the top abandoned line items by frequency.
- 4The flow appends the day's totals as a row in a Google Sheet to build a running trend history.
- 5Gmail sends the digest email to the marketing team with the day's numbers and a link to the trend sheet.
Set it up
What you configure once, before turning it on.
- 1Connect StripeCustomers, subscriptions, payments.
- 2Connect Google DriveDocs, sheets, slides, files.
- 3Connect GmailRead, draft, send, label.
- 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.