Turn every new blog post into ready-to-use social posts
When you publish a blog or newsletter post, AI writes three short social posts about it and adds them to your posting sheet.
What you need
- Your blog or newsletter RSS link (beehiiv, Substack, and WordPress all have one)
- An OpenAI API key
- The sheet from the social-posts recipe, or any sheet
Steps
Watch your own feed
Trigger on new items in your RSS feed. Checking once a day is enough.
Write the posts with AI
Send the title, link, and description to OpenAI. Prompt idea: "Write 3 different social posts about this article for beginners. Under 220 characters each. Plain language, no hashtag spam, include the link."
Add them to your queue
Add the posts to your Google Sheet with an empty date and status. Edit them, add dates, and the social-posts recipe publishes them.
Build it in your tool
RSS > Watch RSS feed items (daily), OpenAI > Create a completion, Google Sheets > Add a row.
RSS Feed Trigger (daily), OpenAI, Google Sheets (Append row).
RSS by Zapier > New item in feed, ChatGPT/OpenAI step, Google Sheets > Create row.
- n8n workflowDraft file: it imports into n8n (checked with n8n 2.43) but has not been run with real accounts yet. In n8n: create a workflow, open the menu, choose Import from file, then connect your own accounts.Download .json
- Make blueprintComing once this recipe has been built and tested in Make. Follow the Make notes above for now.Not yet
What it costs per month
| Tool | Monthly usage | Cheapest plan that fits |
|---|---|---|
| MakeCheapestPricing page | 46 credits How we counted30 daily checks + 8 x 2 (AI, add row) = 46. |
FreeFree plan |
| n8nPricing page | 8 executions How we countedn8n only starts an execution when there's a new post. |
$24/moCloud Starter plan$20/mo billed yearlyOr $0 for the software if you self-host the free Community Edition (you pay for your own server). |
| ZapierPricing page | 16 tasks How we counted8 x 2 actions = 16. |
$29.99/moProfessional 750 plan$19.99/mo billed yearlyMulti-step Zap, so the free plan (two steps only) doesn't work. |
Assumption: 8 new posts a month, checked once a day. Prices in USD, checked 2026-10-17 on the official pricing pages. The plan shown is the cheapest that covers this recipe alone; if you run several automations, add their usage together.
This recipe uses OpenAI. The AI usage is billed separately by OpenAI on your own API key and is not included above. See OpenAI API pricing.
Watch out for
- Edit the AI posts before publishing so they sound like you.
- Pairs well with the recipe Schedule social posts from a Google Sheet.