SOCIAL MEDIA
Chase guests weekly for clips still awaiting clip-rights approval
On a weekly schedule, finds clips logged but not yet approved in Airtable, then emails each guest a reminder listing exactly which quotes need their sign-off.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires
- ActionQuery pending clips past grace window in AirtableAirtable
- LogicGroup by guest, skip already-chased this cycle
- ActionEmail each guest their pending quote listGmail
- OutputStamp last-chased date and bump reminder countAirtable
What it does
Keeps approvals from stalling. Once a week it scans the rights tracker for clips that are still pending past a grace period, groups them by guest, and sends each guest a single email listing the specific episode and quotes awaiting their decision with a one-click reply path. It then stamps the chase date so nobody gets pestered twice in the same cycle.
When to use it
Use it when guest approvals routinely go quiet and clips sit unschedulable for weeks. This automates the polite nudge so producers stop manually tracking who hasn't replied.
How it works
- 1A weekly schedule triggers the run.
- 2An Airtable action queries clips where status is pending and the logged date is older than the grace window.
- 3A logic step groups pending clips by guest and skips anyone already chased this cycle.
- 4A Gmail action sends each guest a personalized reminder listing their specific pending quotes.
- 5The output updates each clip's record with the last-chased timestamp and increments a reminder counter.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect GmailRead, draft, send, label.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Social Media workflows
Discord event capacity gate with automatic waitlist promotion
Enforces a seat cap on RSVPs: once an event is full, new sign-ups join a waitlist, and when someone drops out the next person is promoted, notified in Discord.
Tiered Discord event reminder fan-out (24h / 1h / live)
On a schedule, scans upcoming Discord-tracked events and DMs each confirmed attendee staged reminders at 24 hours, 1 hour, and event start.
A/B carousel cover variants from one brief
Takes a single approved brief and uses an LLM to write three distinct cover-slide headlines, renders a carousel cover for each, and logs the variants to Airtable for an A/B test.
Localized carousel variants per target market
From one approved master brief, translates the copy into each target locale, renders a localized carousel per market, and publishes each to its region's platform account.
Carousel render and auto-publish on Slack approval
Renders carousel variants from a brief, posts a preview to Slack for a one-click approve, and on approval publishes the chosen variant to the connected social platforms.
Discord /rsvp slash command with Outlook calendar invite
Lets members RSVP to an event via a /rsvp slash command, captures their status (yes/maybe/no), and sends a matching Outlook calendar invitation or cancellation to their email.
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.