Auto-Schedule Social Posts to Buffer From an Airtable Content Calendar
Keep your whole content plan in Airtable and let n8n push each due post to Buffer's queue automatically, so nothing is forgotten and no manual copy-paste is needed.
- 1
Schedule a Daily Check
Add a
Schedule Triggernode set to run every hour. This keeps Buffer's queue in sync with any newly ready rows in Airtable. - 2
Fetch Ready Posts From Airtable
Add an
Airtablenode with operationSearch. Filter with a formula likeAND({Status}='Ready', IS_BEFORE({Publish Date}, DATEADD(NOW(),1,'days')))so only posts due soon are returned. - 3
Push Each Post to Buffer
Add an
HTTP Requestnode inside a loop over the returned records. POST to Buffer'supdates/createendpoint with the posttext, targetprofile_ids, andscheduled_at. Reference the Airtable fields via{{$json["fields"]["Post"]}}. - 4
Mark the Row as Scheduled
Add another
Airtablenode with operationUpdate. Set the record'sStatusfield toScheduledso the same post is never queued twice on the next run. - 5
Activate and Monitor
Activate the workflow and add a test row in Airtable with status
Ready. Confirm it appears in Buffer and the Airtable status flips toScheduled.
Frequently asked questions
How do I attach images?
Store the image URL in an Airtable attachment or URL field and pass it as the `media` parameter in the Buffer request. Buffer will pull and attach the image when publishing.
Can I post to multiple channels from one row?
Yes. Use a multi-select field for channels in Airtable, map each to its Buffer `profile_id`, and send them as an array in a single request.