SOCIAL MEDIA

Daily Cross-Platform Sentiment Scorecard

Each morning it aggregates the prior day's brand mentions across platforms, computes a sentiment score and top themes.

CategorySocial Media
Enginesim
Difficultybeginner
Triggerschedule
Steps6
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule
  • ActionScrape prior-day mentionsApify
  • ActionScore sentiment and cluster themesOpenAI
  • LogicRoll up daily score and movers
  • ActionAppend row to scorecard tableCodaCoda
  • OutputPost headline digestDiscordDiscord

What it does

Gives the comms team a steady daily pulse instead of only firefighting. Overnight it gathers every brand mention from the previous 24 hours, computes an overall sentiment score, breaks it down by platform and theme, and logs it as one trend row in a Coda scorecard so you can see drift over weeks.

When to use it

Use it for routine reporting and trend tracking when you want a defensible daily number rather than gut feel. Pairs well with the surge detector: this is the baseline, that is the alarm.

How it works

  1. 1A daily morning schedule starts the run.
  2. 2Apify scrapes the prior day's public mentions across your tracked platforms.
  3. 3OpenAI scores sentiment and clusters mentions into top themes.
  4. 4A logic step rolls everything into a single daily score, per-platform splits, and movers versus yesterday.
  5. 5The result is appended as a new row in the Coda scorecard table.
  6. 6A short Discord digest posts the headline number and the biggest mover.

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 CodaDocs, packs, automations.
  4. 4
    Connect DiscordCommunity channels + voice + bots.
  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.