Templates / Auto-publish Facebook posts from Google Sheets with Slack & email alerts

Auto-publish Facebook posts from Google Sheets with Slack & email alerts

Ready for 3.0

by Rahul Joshi ✓ · 463 views · created 2025-11-06 · Social Media

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 10 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, Facebook Graph API, Slack and Microsoft Outlook.

How it runs

Trigger: On Google Sheets events.

  1. Filter Pending Posts (Code Node) (Code): runs custom JavaScript code
  2. Prepare Post Data (Edit Fields (Set)): sets 3 fields: caption, image_url, status
  3. Publish Post to Meta (Facebook Graph API) (Facebook Graph API): uses Facebook Graph API
  4. Check Publish Success (If): checks a condition and branches into true / false
  5. Notify Success in Slack (Slack): uses Slack
  6. Send Success Email (Outlook/SMTP) (Microsoft Outlook): uses Microsoft Outlook
  7. Notify Failure in Slack (Slack): uses Slack
  8. Send Failure Email (Send Email): sends an email over SMTP
  9. Update Post Status in Google Sheet (Google Sheets): append or update

Services it uses

Google SheetsFacebook Graph APISlackMicrosoft Outlook

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (9)

From the author

📊 Description Simplify your social media publishing process by automating post scheduling from Google Sheets directly to Meta (Facebook Pages). 📅💬 This workflow detects pending posts, uploads images with captions to your Facebook Page, updates the sheet…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.