SOCIAL MEDIA

Weekly Evergreen Recycle Performance Report

Aggregates the past week's recycled-post results from Airtable, has AI write a plain-English summary of what worked and what's decaying.

CategorySocial Media
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule kicks off report
  • ActionRead week's recycle results from AirtableAirtableAirtable
  • LogicRoll up performers, decliners, totals
  • ActionGenerate narrative summary with AIOpenAI
  • OutputPublish report page to NotionNotionNotion

What it does

Gives your team a readable weekly readout on how the evergreen engine is performing. It rolls up the week's recycled posts and their engagement from Airtable, asks OpenAI to summarize trends, top performers, and posts trending toward retirement, then publishes a formatted report to Notion.

When to use it

Use it when stakeholders want visibility into the recycling program without digging through a spreadsheet. Running it every Monday gives a steady cadence of insight on which evergreen content is still earning its slot.

How it works

  1. 1A weekly schedule kicks off the report.
  2. 2The past week's recycle results and engagement metrics are read from Airtable.
  3. 3A logic step rolls the data into top performers, decliners, and overall totals.
  4. 4OpenAI turns the rollup into a plain-English narrative with callouts and recommendations.
  5. 5The finished report is published as a new page in Notion for the team.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect NotionPages, databases, comments.
  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.