SOCIAL MEDIA
Weekly Review Theme Digest to Airtable and Slack
Aggregates a week of App Store and G2 reviews, clusters them into recurring themes with sentiment trends, logs the breakdown to Airtable.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule trigger
- ActionCollect week of app-store reviewsApify
- ActionScrape recent G2 reviewsFirecrawl
- ActionCluster into themes with sentimentOpenAI
- ActionLog theme rows to AirtableAirtable
- OutputPost digest summary to SlackSlack
What it does
Replaces manual review-reading with a weekly intelligence report. It gathers every review from the past seven days across sources, groups them into themes (pricing, performance, onboarding, etc.), tracks how sentiment is shifting week over week, stores the structured data in Airtable for trend tracking, and sends a digestible summary to Slack.
When to use it
Use this when leadership or product wants the signal from reviews, not the individual replies. Pairs well with a separate real-time reply flow that handles individual responses while this one handles the macro picture.
How it works
- 1A weekly schedule trigger fires (e.g. Monday morning).
- 2Apify collects the past week's App Store reviews and Firecrawl scrapes recent G2 reviews.
- 3An OpenAI step clusters all reviews into recurring themes with per-theme sentiment scores.
- 4Each theme row (volume, sentiment, sample quotes) is written to an Airtable base for historical tracking.
- 5A formatted summary highlighting top themes and notable shifts is posted to Slack.
Set it up
What you configure once, before turning it on.
- 1Connect ApifyActors, scrapers, datasets.
- 2Connect FirecrawlCrawl, scrape, structured extract.
- 3Connect OpenAIModels, embeddings, files.
- 4Connect AirtableBases, tables, views, automations.
- 5Connect SlackChannels, DMs, threads, mentions.
- 6Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 7Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 8Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Social Media workflows
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.
Multi-Platform Comment Escalation Router
Ingests inbound comments and replies from your connected social platforms, classifies each for legal or PR risk.
Post-event Discord attendance recap and host digest
After a synced calendar event ends, reconciles who RSVP'd against who actually showed, posts a thank-you recap in Discord, and emails the host a digest of attendance and no-shows.
Agent-Driven Comment Policy Review Queue
An agent reviews ambiguous comments against your brand's response policy, decides whether to auto-clear, draft a reply for approval, or escalate, and routes its decision…
Carousel render with brand-safety pre-check
Before rendering, an LLM checks the brief copy against brand and policy rules; clean briefs render and archive to S3, flagged briefs route to a review queue instead.
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.