Schedule Instagram & Facebook Stories from Google Sheets (n8n)

Schedule Instagram & Facebook Stories from Google Sheets—hands-free

This n8n workflow automatically publishes your daily Instagram and Facebook Stories based on a queue in Google Sheets. Every run checks for “Ready” items, uploads them to both platforms, and records the outcome in a History tab—so you always know what was posted and when.

What this workflow does

• Runs on a schedule using an n8n schedule trigger at your configured time (daily).
• Reads story entries from Google Sheets from the “Story” tab, selecting rows where the day-of-week flag is true and Status is set to Ready.
• Logs execution context by adding a workflow execution timestamp to each story item.
• Routes by media Type (Image or Video) and uploads each item as an Instagram Story and Facebook Story via Upload Post API.
• Validates upload results by splitting the uploader response into individual results and checking whether each upload succeeded.
• Writes to “History” in Google Sheets, including story ID, media URL, platform, execution time, and either the upload timestamp (success) or Not Uploaded (failure/unknown type).

Use cases

• Marketing teams pre-plan weekly Story content in Google Sheets and push it automatically.
• SaaS operators batch-post daily promotions without manual Instagram/Facebook uploads.
• Automation engineers maintain a reliable content pipeline with execution logs for auditing.

Technical details

• Integrations: Google Sheets (OAuth) and Upload Post API (upload-post.com).
• n8n nodes used: if, set, switch, split out, sticky note, google sheets.
• Required setup: Upload Post credentials configured with Instagram account + Facebook Page, plus Facebook Page ID and target platforms (Instagram/Facebook).
• Row requirements: Each “Story” row must include a publicly accessible media Url and a Type value of exactly Image or Video.