SOCIAL MEDIA

Weekly advocacy digest with suggested posts and a share leaderboard

Every Monday, picks the week's top approved content from Airtable, drafts a suggested LinkedIn post per theme.

CategorySocial Media
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonday morning schedule
  • ActionQuery approved content from past week in AirtableAirtableAirtable
  • ActionTally last week's shares for leaderboardAirtableAirtable
  • LogicDraft one suggested post per top theme
  • OutputPost digest and leaderboard to SlackSlack

What it does

Runs a weekly cadence that surfaces the best approved content, packages suggested LinkedIn posts your team can grab, and recognizes top sharers with a leaderboard to keep advocacy momentum high.

When to use it

Use it when you want a predictable Monday rhythm for employee advocacy: a curated menu of shareable posts plus light gamification, instead of ad-hoc one-off requests.

How it works

  1. 1A Monday schedule fires the workflow.
  2. 2The flow queries the Airtable content table for items approved in the last 7 days, ranked by priority.
  3. 3It reads the share-log table to tally each employee's posts from the prior week and build a leaderboard.
  4. 4An agent drafts one suggested LinkedIn post per top content theme, written to be lightly personalizable.
  5. 5A digest message is assembled with each draft in a copy-ready block and the leaderboard at the top.
  6. 6The digest posts to the advocacy Slack channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    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.