SOCIAL MEDIA

Daily Brand Sentiment Digest with Trend Callouts

Each morning it aggregates the prior day's brand mentions, computes a sentiment breakdown and spots emerging themes.

CategorySocial Media
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule fires
  • ActionPull last 24h of mentionsApify
  • ActionClassify sentiment and cluster themesOpenAI
  • LogicCompute breakdown and trend shift
  • ActionWrite narrative digestOpenAI
  • OutputEmail digest to leadershipGmailGmail

What it does

This workflow rolls a full day of brand mentions into one executive-friendly summary. It tallies how many mentions were positive, neutral, and negative, surfaces the recurring topics driving each bucket, and flags any sentiment swing versus the prior day. The result is emailed as a clean digest so leaders see the social pulse without scrolling feeds.

When to use it

Use it when stakeholders want a once-a-day read on brand health rather than a live firehose. It pairs well with a real-time triage workflow: the triage handles individual fires, this gives the strategic overview.

How it works

  1. 1A daily morning schedule triggers the run.
  2. 2Apify pulls all mentions from the previous 24 hours.
  3. 3OpenAI classifies each mention's sentiment and clusters them into themes.
  4. 4A logic step computes the positive/neutral/negative breakdown and compares it to the prior day to flag notable shifts.
  5. 5OpenAI writes a concise narrative digest with the top themes and callouts.
  6. 6Gmail sends the formatted digest to the leadership distribution list.

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 GmailRead, draft, send, label.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.