SOCIAL MEDIA

Brand mention triage: daily reputation digest with themes

Each morning, aggregates the prior day's brand mentions into a themed sentiment digest with top posts and emerging topics.

CategorySocial Media
Enginesim
Difficultyadvanced
Triggerschedule
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule kicks off digest
  • ActionScrape prior day's mentionsApify
  • ActionScore sentiment and cluster into themesOpenAI
  • ActionWrite trend-and-themes digestOpenAI
  • OutputPost digest to Slack channelSlack
  • ActionArchive scored mentions to BigQueryGoogle BigQueryBigQuery

What it does

Rolls up everything said about your brand in the last 24 hours into one readable morning brief. It clusters mentions into themes, tracks the day-over-day sentiment trend, surfaces the highest-reach posts, and calls out any emerging topic worth attention. The digest lands in Slack and the raw data is archived for trend analysis.

When to use it

When leadership and marketing want a reliable daily pulse on brand perception without reading individual posts, and you want a queryable history of sentiment over time.

How it works

  1. 1A daily schedule kicks off the digest run.
  2. 2The prior day's mentions are scraped across platforms via Apify.
  3. 3Sentiment is scored and mentions are clustered into themes by an LLM.
  4. 4The LLM writes a digest: trend versus yesterday, top themes, standout posts, and emerging topics.
  5. 5The digest is posted to the team Slack channel.
  6. 6The scored mentions are appended to a BigQuery table for long-term trend analysis.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect ApifyActors, scrapers, datasets.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Connect BigQueryDatasets, queries, schemas.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.