Schedule social posts from a Google Sheet
Write your posts in a spreadsheet with a date. Each morning the automation publishes the post that's due and marks it as posted.
What you need
- A Google account
- A LinkedIn profile (works the same way with other networks your tool supports)
Steps
Set up the sheet
Create a sheet with the columns date (YYYY-MM-DD), post_text, status. Write a few posts and leave status empty.
Run once a day
Schedule the automation for the time you want to post, for example 09:00.
Find today's post
Look up the row where date is today and status is empty. If there's no row, stop here.
Publish it
Send post_text to LinkedIn as a post from your profile.
Mark it as posted
Update the row: set status to posted. This stops it from being posted twice.
Build it in your tool
Schedule daily. Google Sheets > Search rows (filter date = today, status empty), LinkedIn > Create a user text post, Google Sheets > Update a row.
Schedule Trigger, Google Sheets (Get rows with filters), LinkedIn (Create post), Google Sheets (Update row).
Schedule by Zapier (every day), Google Sheets > Lookup spreadsheet row, Filter (only continue if found), LinkedIn > Create share update, Google Sheets > Update 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 | 70 credits How we counted30 searches + 20 posts x 2 (post, update row) = 70. |
FreeFree plan |
| n8nPricing page | 30 executions How we countedOne execution per daily run. |
$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 | 70 tasks How we counted30 lookups + 20 x 2 (post, update) = 70. Schedule and Filter are free. |
$29.99/moProfessional 750 plan$19.99/mo billed yearlyMulti-step Zap, so the free plan (two steps only) doesn't work. |
Assumption: One check a day (30 a month) and 20 posts a month. 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.
Watch out for
- Write dates as plain text in YYYY-MM-DD format so the comparison works.
- LinkedIn connections sometimes expire. Check the tool's error emails.