Weekly Content Recap Workflow

If you're posting to social media consistently, you're sitting on a newsletter every week. This workflow collects what you already wrote, feeds it to Claude, and produces a draft recap newsletter — no rewriting from scratch.

Here's the complete step-by-step, built for Zapier or Make (the steps are the same, the interface is different).

What this workflow does

1. Triggers every Friday at 9am
2. Pulls your posts from the past 7 days (LinkedIn, Twitter/X, or both)
3. Sends them to Claude with a prompt that formats them into a newsletter
4. Saves the draft to Google Docs or Notion
5. (Optional) Sends you a Slack or email notification

Time to set up: about 45 minutes. Time saved per week: 30–60 minutes.

Step-by-step

Step 1 — Trigger: Schedule

Zapier: Use the "Schedule by Zapier" trigger. Set it to Weekly, Friday, 9:00am.

Make: Use the "Schedule" module. Set the interval to 1 week, day: Friday.

Step 2 — Pull your posts

LinkedIn: Use the "LinkedIn" app → "Get Recent Posts by Author." Set the time range to "last 7 days." You'll need to connect your LinkedIn account.

Twitter/X: Use the "Twitter" app → "Search Tweets" with the query from:yourusername. Filter by date in the next step.

If you post to multiple platforms, add a step for each and use a "Merge" or "Concatenate" step to combine the text.

Step 3 — Format the post text

Add a "Formatter" step (Zapier) or a "Text Aggregator" module (Make) to combine all post bodies into one block of text, separated by line breaks.

Step 4 — Send to Claude

Use the Anthropic app in Zapier (search "Claude" or "Anthropic") or the HTTP module in Make pointing to https://api.anthropic.com/v1/messages.

Use this prompt, replacing {{posts}} with the merged post text from Step 3:

Here are my social media posts from this week:

{{posts}}

Write a weekly newsletter recap based only on these posts. 

Format:
- Subject line (under 50 characters, no clickbait)
- Opening sentence (what this week was about, in one line)
- 3–5 short sections, each covering one post or theme
- Closing line inviting a reply or action

Tone: the same voice as the posts above — match it exactly.
Keep the total under 400 words.

Set the model to claude-opus-4-8 or claude-sonnet-4-6. Max tokens: 1000.

Step 5 — Save the draft

Google Docs: Use "Google Docs → Create Document from Text." Name it "Newsletter Draft – ."

Notion: Use "Notion → Create Page." Set the parent to your content calendar database.

Step 6 — Notify yourself (optional)

Add a "Slack → Send Message" or "Gmail → Send Email" step to ping yourself that the draft is ready. Include a direct link to the doc.

Troubleshooting

LinkedIn returns no posts: Check your API permissions — LinkedIn's API requires explicit approval for post-reading scopes.

Claude output is too generic: Your posts may be too short or too varied. Add a line to the prompt: "The newsletter should feel like a personal update, not a content summary."

Draft is too long: Reduce max tokens to 700 or add "Keep each section to 2 sentences max."

Making it yours

The prompt in Step 4 is your artifact. Save it somewhere, run it a few weeks, and edit it based on what comes back. After three or four drafts, it should produce something you send with minimal editing.