Facebook Graph API and Slack integration

📊 Description Automate your content repurposing workflow by transforming long-form articles, blogs, and newsletters into short, high-signal, AI-ready social media snippets. ✍️🤖 This workflow fetches pending content from Airtable, generates 30-word snippets, data points, and quote-style insights using GPT-4o-mini, and updates the original record with all generated fields. If Facebook is selected as a target platform, the workflow automatically posts the best snippet via the Meta Graph API and logs the result. Perfect for content, marketing, and social media teams scaling daily publishing without manual rewriting. 🚀📣 🔁 What This Template Does 1️⃣ Fetches “pending” long-form content from Airtable. 📥 2️⃣ Processes all records in batches to avoid rate limits. 🔁 3️⃣ Sends full content + metadata to GPT-4o-mini to generate structured snippets. 🤖 4️⃣ Ensures valid JSON output via the structured parser. 📐 5️⃣ Updates Airtable with: — 30-word snippets — data points — quote insights — a recommended primary snippet — timestamps & status 6️⃣ Checks if Facebook is selected as a posting platform. ⚙️ 7️⃣ Automatically publishes the recommended snippet using the Meta Graph API. 📤 8️⃣ Updates Airtable again with post status + response. 📝 9️⃣ Sends a success notification to Slack with full details. 💬 ⭐ Key Benefits ✅ Automates creation of platform-ready social media snippets ✅ Produces AI-friendly, high-signal content that works for LLM discovery ✅ Eliminates manual rewriting for LinkedIn, Facebook, Twitter, Instagram ✅ Automatically posts to Meta if selected — hands-free publishing ✅ Maintains clean, structured content in Airtable for future reuse ✅ Saves time for marketing, growth, and social teams 🧩 Features Airtable integration for content fetch + update GPT-4o-mini AI snippet generation Structured JSON parser for clean, reliable AI output Auto-detection of selected social platforms Facebook Graph API publishing Slack notifications for success Scheduled automation for hands-free daily processing Full audit trail with timestamps 🔐 Requirements Airtable Personal Access Token OpenAI API key (GPT-4o-mini) Facebook Graph API credentials (for auto-posting) Slack API credentials n8n with LangChain nodes enabled 🎯 Target Audience Content marketing teams repurposing long-form content Social media managers publishing daily posts Growth teams optimizing content for AI search engines Agencies producing content at scale for multiple clients

📊 Description Automatically analyze your Instagram posts’ engagement and audience sentiment using GPT-4 to uncover top-performing content and improvement opportunities. 💬📈 This workflow fetches your latest Instagram posts using the Facebook Graph API, evaluates likes, comments, and tone, then generates structured performance insights. The results are logged into Google Sheets, shared via Slack alerts, and emailed through Outlook — empowering your social media team with daily, AI-powered engagement intelligence. 🚀 What This Template Does 1️⃣ Trigger – Runs daily at 10 AM to fetch the latest Instagram posts. ⏰ 2️⃣ Data Fetching – Uses the Facebook Graph API to extract post data, captions, likes, and comments. 📲 3️⃣ Formatting – Cleans and structures post and comment data for analysis. 🧩 4️⃣ AI Evaluation – GPT-4 analyzes engagement metrics and comment sentiment to score post performance. 🤖 5️⃣ Decision Routing – Flags high- and low-performing posts for separate processing. ⚙️ 6️⃣ Notifications – Sends positive performance summaries or negative alerts to Slack. 💬 7️⃣ Logging – Records engagement metrics, sentiment labels, and AI recommendations in Google Sheets. 📊 8️⃣ Reporting – Emails detailed performance summaries to the marketing team via Outlook. 💌 Key Benefits ✅ Automates social performance tracking across Instagram posts ✅ Provides AI-driven sentiment and engagement insights ✅ Flags top or underperforming content for immediate action ✅ Delivers Slack and email reports for team visibility ✅ Centralizes analytics in Google Sheets for trend tracking Features Facebook Graph API integration for Instagram post and comment retrieval GPT-4 sentiment and engagement evaluation Structured JSON insights and recommendations Slack alerts for both positive and negative performance Google Sheets data logging with trend metrics Outlook email reporting for management visibility Customizable scheduling and thresholds Requirements Facebook Graph API credentials connected to your Instagram Business account OpenAI API key for GPT-4 or GPT-4o-mini Slack Bot token with chat:write permissions Google Sheets OAuth2 credentials with edit rights Microsoft Outlook OAuth2 credentials for email delivery Optional environment variables for IDs: SHEET_ID, SLACK_CHANNEL_ID, OUTLOOK_EMAIL Target Audience Marketing and social media teams optimizing engagement 📣 Agencies managing multiple Instagram accounts 🧑‍💼 Analysts tracking performance metrics and audience tone 📊 Brands automating daily performance reports 📅 Step-by-Step Setup Instructions 1️⃣ Connect your Facebook Graph API to your Instagram Business Account. 2️⃣ Add OpenAI API credentials (use GPT-4 model for best results). 3️⃣ Configure Slack for team notifications and specify the channel ID. 4️⃣ Link Google Sheets and set your sheet ID for data logging. 5️⃣ Connect Microsoft Outlook for daily performance email reports. 6️⃣ Adjust the schedule (default: 10 AM daily) to suit your workflow. 7️⃣ Run a test once, verify data mapping, and enable automation. ✅

📊 Description Streamline Facebook Messenger inbox management with an AI-powered categorization and response system. 💬⚙️ This workflow automatically classifies new messages as Lead, Query, or Spam using GPT-4, routes them for approval via Slack, responds on Facebook once approved, and logs all interactions into Google Sheets for tracking. Perfect for support and marketing teams managing high volumes of inbound DMs. 🚀📈 What This Template Does 1️⃣ Trigger – Runs hourly to fetch new Facebook Page messages. ⏰ 2️⃣ Extract & Format – Collects sender info, timestamps, and message content for analysis. 📋 3️⃣ AI Categorization – Uses GPT-4 to identify message type (Lead, Query, Spam) and suggest replies. 🧠 4️⃣ Slack Approval Flow – Sends categorized leads and queries to Slack for quick team approval. 💬 5️⃣ Facebook Response – Posts AI-suggested replies back to the original sender once approved. 💌 6️⃣ Data Logging – Records every message, reply, and approval status into Google Sheets for analytics. 📊 7️⃣ Error Handling – Automatically alerts via Slack if the workflow encounters an error. 🚨 Key Benefits ✅ Reduces manual message triage on Facebook Messenger ✅ Ensures consistent and professional customer replies ✅ Provides full visibility via Google Sheets logs ✅ Centralizes team approvals in Slack for faster response times ✅ Leverages GPT-4 for accurate categorization and natural replies Features Hourly Facebook message fetch with Graph API GPT-4 powered text classification and reply suggestion Slack-based dual approval flow Automated Facebook replies post-approval Google Sheets logging for all categorized messages Built-in error detection and Slack alerting Requirements Facebook Graph API credentials with page message permissions OpenAI API key for GPT-4 processing Slack API credentials with chat:write permission Google Sheets OAuth2 credentials Environment Variables: FACEBOOK_PAGE_ID GOOGLE_SHEET_ID GOOGLE_SHEET_NAME SLACK_CHANNEL_ID Target Audience Marketing and lead-generation teams using Facebook Pages 📣 Customer support teams managing Messenger queries 💬 Businesses seeking automated lead routing and CRM sync 🧾 Teams leveraging AI for customer engagement optimization 🤖 Step-by-Step Setup Instructions 1️⃣ Connect Facebook Graph API credentials and set your page ID. 2️⃣ Add OpenAI API credentials for GPT-4. 3️⃣ Configure Slack channel ID and credentials. 4️⃣ Link your Google Sheet for message logging. 5️⃣ Replace environment variable placeholders with your actual IDs. 6️⃣ Test the workflow manually before enabling automation. 7️⃣ Activate the schedule trigger for ongoing hourly execution. ✅

📊 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 status, and sends real-time notifications via Slack and email — keeping your marketing team always in sync. 🚀 What This Template Does 1️⃣ Trigger – Monitors a Google Sheet for new or pending posts every minute. ⏰ 2️⃣ Filter – Identifies the latest “pending” entry for publishing. 🔍 3️⃣ Extract – Captures post details like caption, image URL, and ID. 🧾 4️⃣ Publish – Uploads the post to your Meta (Facebook) Page using the Graph API. 📤 5️⃣ Validate – Confirms success or failure of the post operation. ✅ 6️⃣ Notify – Sends instant Slack and email updates on publishing status. 💌 7️⃣ Update – Marks the published post as “Completed” in Google Sheets. 📊 Key Benefits ✅ Hands-free publishing from Google Sheets to Meta ✅ Instant Slack and email alerts for post outcomes ✅ Prevents duplicate or failed post uploads ✅ Centralized content tracking and status updates ✅ Improves consistency and speed in social media operations Features Google Sheets trigger for post scheduling Facebook Graph API integration for auto-posting Slack and Outlook notifications for success/error alerts Automatic sheet updates post-publication Error handling and reporting for failed posts Requirements Google Sheets OAuth2 credentials Facebook Page Access Token via Graph API Slack Bot token for notifications Outlook or SMTP credentials for email updates Target Audience Marketing teams managing Facebook content calendars 📆 Social media managers seeking automated posting 📣 Agencies coordinating client content delivery 📋 Teams tracking campaign publishing performance 📊

Who's it for Marketing teams, agencies, and businesses who regularly create tens or hundreds of Facebook ads and store their creative assets in Google Drive. Perfect for teams who want to stop doing manual work of uploading and setting up ads. What it does This workflow automates the entire Facebook ad creation process from a simple form submission. Users provide a Google Drive link to their media file, ad copy, and target URL through a form. The workflow then automatically fetches the media from Google Drive, creates a new Facebook ad with proper naming conventions (matching the Drive file name), applies tracking parameters, and publishes it to the specified ad set. It sends Slack notifications upon successful ad creation or if errors occur. How it works User submits a form with Google Drive media link, ad set name, ad text, and destination URL Workflow authenticates and fetches the image/video from Google Drive Creates a Facebook ad with the media, using the Drive filename as the ad name Applies UTM tracking parameters automatically Disables Facebook's automated rules to maintain manual control Sends status updates via Slack (success or failure notifications) Requirements Self-hosted n8n instance Google Drive account with API access Facebook Business Manager with active ad account(s) Slack workspace for notifications How to customize the workflow Connect multiple Facebook ad accounts for agency use Modify the form fields to include additional ad parameters Customize Slack notification messages and channels

Who’s it for This workflow is for marketing teams, performance marketers, and media buyers running Facebook (Meta) Ads who want to stay on top of creative performance without manually checking Ads Manager every day. What it does The workflow automatically monitors Facebook Ads performance at the ad creative level and sends real-time Slack notifications when key metrics cross your thresholds. It tracks CTR, CPC, ROAS, spend, and conversions over a rolling time window, then flags: Underperformers** (e.g. CTR below 0.5% for 2 days). Top performers** (e.g. ROAS above 5x). What business value this workflow provides Faster detection of problems** Instead of waiting for a weekly report, you know within a day (or whatever window you configure) if an ad’s CTR is tanking or if spend is producing poor ROAS. That prevents wasted budget. Highlighting winners** When an ad’s ROAS is high (e.g. >5x), you get an instant Slack ping. You can then shift budget to scale it before performance fades. Reduced manual monitoring** Normally someone has to log into Meta Ads Manager daily, filter by campaign/ad, export CSVs, check CTR/ROAS, then write up notes. That’s time-consuming and error-prone. Automating this means you spend less time gathering data and more time making decisions. Team visibility** Posting to Slack means the whole marketing team is aligned on what’s working and what isn’t, without sharing dashboards or CSVs around. How it works Workflow trigger (manual or scheduled). Fetch ad-level insights from the Facebook Ads API. A Code node normalizes metrics (CTR %, CPC, ROAS, spend, conversions). Compare against your CTR and ROAS thresholds. If conditions are met, send a Slack block message with ad name, ID, spend, CTR, CPC, ROAS, and the reasons it was flagged. How to set up In the Edit Fields node, set your act_id (Facebook Ad Account ID) and campaign_id. Adjust ctr_min, roas_top, and lookback_days to fit your goals. Connect your Slack credentials and set the channel for alerts. Requirements A Facebook (Meta) Ads account with API access. Slack workspace with a bot/app that has chat:write permission. n8n credentials for both services. How to customize Add ad thumbnails by including creative in the insights fields. Extend the workflow to automatically pause underperforming ads.

Okay, here are the "How It Works" and "Setup Steps" for your "Automated Social Media Content Distribution System," presented clearly in Markdown. How It Works (Workflow Stages) ⚙️ This system transforms manual, repetitive tasks into a smooth, automated content distribution pipeline: Content Submission & Trigger: You add a new row to your designated Google Sheet with all the content details (Title, URL, Short_Description, Image_URL, Hashtags, and boolean flags for which platforms to post to). The Google Sheets Trigger node immediately detects this new entry, initiating the workflow. Content Preparation: The Set node takes the raw data from your Google Sheet and formats it into a cohesive text string (social_media_text_core) that is suitable for posting across different social media platforms. Conditional Social Media Posting: A series of If nodes (Check Facebook Post, Check Twitter Post, Check LinkedIn Post) sequentially check your preferences (based on the Post_to_Facebook, Post_to_Twitter, Post_to_LinkedIn columns in your sheet). If a platform is marked TRUE, the corresponding social media node (Facebook, Twitter, LinkedIn) is activated to publish your content. If FALSE, that platform is skipped, and the workflow moves to the next check. Status Update & Notification: After attempting to post to all selected platforms, the Google Sheets (Update) node updates the Publication_Status column of your original row to "Published." This prevents re-posting and provides a clear record. Finally, the Slack (Notification) node sends an alert to your chosen Slack channel, confirming that the content has been successfully distributed. Setup Steps 🛠️ (Build It Yourself!) Follow these detailed steps to build and implement this workflow in your n8n instance: Prepare Your Google Sheet: Create a new Google Sheet (e.g., named "Social Media Posts"). Set up the following exact column headers in the first row: Title, URL, Short_Description, Image_URL, Hashtags, Post_to_Facebook, Post_to_Twitter, Post_to_LinkedIn, Publication_Status Fill in a test row with some sample data, ensuring TRUE/FALSE values for the posting flags. Gather Your API Keys & Credentials: Google Sheets Credential: You'll need an OAuth2 credential for Google Sheets in n8n to allow read/write access to your sheet. Facebook Credential: An OAuth2 credential for Facebook with permissions to post to your selected Page. Twitter Credential: A Twitter API credential (API Key, API Secret, Access Token, Access Token Secret) from your Twitter Developer App. LinkedIn Credential: An OAuth2 credential for LinkedIn with permissions to share updates to your profile or organization page. Slack Credential: A Slack API token (Bot User OAuth Token) for sending messages to your channel. Build the n8n Workflow Manually (10 Nodes): Start a new workflow in n8n. Drag and drop each of the following nodes onto the canvas and connect them as described below: Google Sheets Trigger Name: Google Sheets Trigger Parameters: Authentication: Select your Google Sheets credential. Spreadsheet ID: [Copy the ID from your Google Sheet's URL] Sheet Name: [Your Sheet Name, e.g., 'Sheet1' or 'Content'] Watch For: Rows Events: Added Connections: Output to Set Content Parameters. Set Name: Set Content Parameters Parameters: Values to Set: Add a new value: Type: String Name: social_media_text_core Value: ={{ $json.Title }} - {{ $json.Short_Description }}\nRead more: {{ $json.URL }}\n{{ $json.Hashtags }} Connections: Output to Check Facebook Post. If Name: Check Facebook Post Parameters: Value 1: ={{ $json.Post_to_Facebook }} Operation: is true Connections: True output to Post Facebook Message. False output to Check Twitter Post. Facebook Name: Post Facebook Message Parameters: Authentication: Select your Facebook credential. Page ID: [YOUR_FACEBOOK_PAGE_ID] Message: ={{ $json.social_media_text_core }} Link: ={{ $json.URL }} Picture: ={{ $json.Image_URL }} Options: Published (checked) Connections: Output to Check Twitter Post. If Name: Check Twitter Post Parameters: Value 1: ={{ $json.Post_to_Twitter }} Operation: is true Connections: True output to Create Tweet. False output to Check LinkedIn Post. Twitter Name: Create Tweet Parameters: Authentication: Select your Twitter credential. Tweet: ={{ $json.social_media_text_core }} Image URL: ={{ $json.Image_URL }} Connections: Output to Check LinkedIn Post. If Name: Check LinkedIn Post Parameters: Value 1: ={{ $json.Post_to_LinkedIn }} Operation: is true Connections: True output to Share LinkedIn Update. False output to Update Publication Status. LinkedIn Name: Share LinkedIn Update Parameters: Authentication: Select your LinkedIn credential. Resource: Share Update Type: Organization or Personal (Choose as appropriate) Organization ID: [YOUR_LINKEDIN_ORG_ID] (If Organization type selected) Content: ={{ $json.social_media_text_core }} Content URL: ={{ $json.URL }} Image URL: ={{ $json.Image_URL }} Connections: Output to Update Publication Status. Google Sheets Name: Update Publication Status Parameters: Authentication: Select your Google Sheets credential. Spreadsheet ID: [YOUR_GOOGLE_SHEET_CONTENT_ID] Sheet Name: [Your Sheet Name, e.g., 'Sheet1' or 'Content'] Operation: Update Row Key Column: URL Key Value: ={{ $json.URL }} Values: Add a new value: Column: Publication_Status Value: Published Connections: Receives connections from both Share LinkedIn Update and the False branch of Check LinkedIn Post. Slack Name: Send Slack Notification Parameters: Authentication: Select your Slack credential. Chat ID: [YOUR_SLACK_CHANNEL_ID] Text: New content "{{ $json.Title }}" successfully published to social media! 🎉 Check: {{ $json.URL }} Connections: Output to Update Publication Status. Final Steps & Activation: Test the Workflow: Before activating, manually add a new row to your Google Sheet or use n8n's "Execute Workflow" button (if available for triggers). Observe the flow through each node to ensure it behaves as expected and posts to your social media accounts. Activate Workflow: Once you are confident it's working correctly, turn the workflow "Active" in the top right corner of your n8n canvas.