n8n Facebook Graph API Workflow: Schedule Posts from Google Sheets

Schedule Facebook Page posts from Google Sheets—automatically, reliably, and with status tracking

This n8n workflow reads pending post entries from your Google Sheets, generates publish-ready Facebook messages (including SpinTax and hashtags), posts them to your Facebook Page via the Facebook Graph API on an hourly schedule, and writes the success/failure results back to the sheet.

What this workflow does

• Runs hourly using an n8n Schedule Trigger.
• Reads rows from the “Contents” tab in your Google Sheets document.
• Filters for Status = “Pending” and checks the optional Scheduled Time to ensure posts are published only when they’re due.
• Prepares the post content by expanding SpinTax in the Content field and appending Campaign Tags as hashtags.
• Prevents duplicates by skipping content that duplicates previously posted entries.
• Publishes to Facebook by posting the message (and optional link) to the target Facebook Page feed using the Facebook Graph API.
• Updates Google Sheets results:
  • If Facebook returns a post ID: sets Status = “Posted”, writes the published post ID, a live post URL, and the publish timestamp.
  • If the post fails or returns no ID: sets Status = “Failed” and records the error message.

Use cases

• Social media teams coordinating content in Google Sheets and publishing to a Facebook Page on schedule.
• SaaS operators running lightweight n8n automation for repeatable Facebook posting with clear audit trails.
• Automation engineers needing robust API-based publishing with per-row success/failure logging.

Technical details

• Nodes / integrations: Schedule Trigger, Google Sheets, if, code, Facebook Graph API.
• Required sheet columns: at minimum Status, Content, Scheduled Time, Campaign Tag (and a valid Page ID per row, or a default Page ID in the workflow code).
• OAuth setup: Google Sheets credentials + Facebook access token with Page publishing permissions.