CONTENT CREATION

Monthly best-of: repurpose top 3 posts into a carousel digest

Each month it ranks your blog posts by traffic, turns the top three into a single round-up carousel, and publishes it across your social platforms as a best-of recap.

CategoryContent Creation
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonthly schedule fires
  • ActionRank posts by pageviews from analyticsGoogle BigQueryBigQuery
  • LogicSelect top three and pull hooks
  • ActionGenerate best-of round-up carouselImage generation
  • ActionArchive deck to DriveGoogle DriveGoogle Drive
  • OutputPublish recap carousel to social platformsSocial publishing

What it does

Once a month it looks back at your published posts, ranks them by traffic, and builds a single best-of carousel summarizing the top three. The recap deck is published across your social platforms as a monthly highlight.

When to use it

Use it when you want a recurring, low-effort engagement post that also drives clicks back to your strongest content. Ideal for newsletters and brands that benefit from a steady monthly cadence.

How it works

  1. 1A monthly schedule triggers the run.
  2. 2The flow queries BigQuery analytics to rank last month's posts by pageviews.
  3. 3A logic step selects the top three and pulls a one-line hook for each.
  4. 4A carousel is generated with a cover slide plus one branded slide per featured post.
  5. 5The deck is archived to Google Drive for the record.
  6. 6The best-of carousel is published to the connected social platforms with a recap caption.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect Image generationManaged Nano Banana image renders, metered per image.
  3. 3
    Connect Google DriveDocs, sheets, slides, files.
  4. 4
    Connect Social publishingCross-post to X, LinkedIn, Instagram, TikTok, and 4 more in one call.
  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.