Facebook Graph API and Gmail integration

🚀 AI Blog & Social Media Publisher – Fully Automated Workflow This workflow is ideal for individuals, marketers, agencies, and brands who want to effortlessly automate the entire blogging and social media process—from idea generation to promotion. Its primary goal is to consistently deliver engaging, SEO-optimized blog posts directly to WordPress, accompanied by professionally crafted social media content ready for Instagram, Facebook, and X (Twitter). No writers, editors, designers, or social media managers required. Save countless hours and resources while boosting your brand's online presence. 🔧 Workflow Capabilities: -Automated Blog Topic Generation: Instantly generates unique, high-value blog ideas tailored to your brand. -SEO Content Creation: Produces comprehensive, 2000–2500 word articles optimized for search engines. -Real-Time Research: Integrates Perplexity AI to ensure factually accurate, authoritative content. -Visual Content Generation: Creates custom, AI-generated featured images via GPT-4, with automatic fallback to Pexels. -WordPress Publishing: Automatically publishes articles directly to WordPress with complete formatting (HTML), meta descriptions, featured images, and proper categorization. -Social Media Automation: Generates and schedules engaging, platform-specific posts for Instagram, Facebook, and X, complete with relevant hashtags, calls-to-action, and links. -Detailed Logging & Reporting: Logs every step transparently into Google Sheets and optionally sends publication reports to Gmail. ⚙️ How It Works: When activated, the workflow checks your content calendar in Google Sheets to avoid duplicate topics. It generates fresh, brand-aligned blog ideas, conducts live research, and creates complete, ready-to-publish articles. It then automatically designs and sources appropriate visuals, publishes content seamlessly to WordPress, and prepares engaging social media posts optimized for each platform. 🛠️ Easy Setup Steps: -Connect your APIs: OpenAI, WordPress, Google Sheets, Gmail, and optionally Pexels. -Replace placeholders (WordPress URLs, Google Sheets ID/tab, workflow IDs). -Customize AI prompts with your brand’s tone, keywords, and CTAs for personalized content. -Configure scheduling to automate daily, weekly, or custom publishing intervals. 📌 Additional Features: -Modular workflow design for easy customization and scalability. -Comprehensive Markdown and PDF setup guides included. -Bonus: Reference placeholders and quick-edit Sticky Notes for effortless adjustments. Launch today. Automate permanently. Amplify your reach effortlessly.

Monthly AI SEO Content Engine: 34 Assets to WordPress, LinkedIn & Socials Summary This workflow is an end-to-end, enterprise-grade content engine. It automates the entire lifecycle of a brand's content marketing: capturing business context via an n8n Form Trigger to generate a master strategy document, using real-time analytics to write 34 targeted assets, packaging them into a styled .docx file for review, and automatically generating images to publish the content across WordPress, LinkedIn, Facebook, and Instagram. Key features Automated Brand Strategy:** Uses an n8n Form Trigger to capture business details and generates a 16-section master Markdown strategy document saved to Google Drive. Data-Driven Content Planning:** Integrates Google Analytics 4 (GA4) and localized Google Trends to identify content gaps (high-bounce pages) and rising topics to inform the content plan. High-Volume AI Generation:** Leverages native n8n Google Gemini nodes to write 34 distinct assets per run: 6 SEO blogs, 12 LinkedIn posts, 8 educational social posts, 4 newsletters, and 4 long-form guides. Native Document Assembly:** Bypasses basic text outputs by dynamically assembling the generated content into a professionally styled, downloadable Microsoft Word (.docx) package with a generated table of contents. AI Image Generation:** Uses Google Gemini 2.5 Flash Image to generate custom, photorealistic featured images and social media graphics for every post natively within the flow. Omnichannel Publishing:** Parses the finalized .docx file, extracts the targeted content, and schedules it automatically to WordPress, LinkedIn, Facebook Pages, and Instagram Business with clamped timestamp validation. Automated Error Logging & Alerts:** Built-in error trapping that sends a detailed summary to your Gmail if any API fails, or if prerequisite files are missing before publishing begins. How it works This template is divided into three distinct pipelines that run sequentially: Pipeline A: Strategy Generation Trigger:** An n8n Form Trigger collects the company name, mission, audience, and core services. Process:** The native Google Gemini node generates a strict JSON strategy object, which a Code node formats into a comprehensive Markdown document. Storage:** The Google Drive node saves this context document directly to the root of your Google Drive. Pipeline B: Content Generation & Assembly Trigger:** Triggered manually via the Pipeline B trigger, or swap in a Schedule Trigger to run monthly. Context Gathering:** Fetches the Markdown strategy from Drive, pulls the last 30 days of GA4 data, and fetches current Google Trends via RSS. Generation:** Google Gemini is prompted in stages: first to build a Content Plan JSON, then to write the batches of blogs, social posts, and guides. Assembly:** A robust Code node compiles the raw text into a valid, styled .zip/.docx file and uploads it to the root of your Google Drive. Notification:** A Gmail node sends the team an email notification with a direct link to the finalized .docx package. Pipeline C: Multi-Platform Publishing Trigger:** Schedule Trigger set to run on the 1st of each month — adjust the time to run after Pipeline B completes. Extraction:** Searches Google Drive for the latest .docx package, unzips it, and extracts the raw XML text. (If missing, it safely aborts and alerts you). Processing:** Code nodes split the text into individual arrays for Blogs, LinkedIn, and Social posts, safely clamping publish dates to prevent API scheduling errors. Media & Publishing:** * Generates an image for each asset using Gemini 2.5 Flash Image. Uploads blog images to WordPress Media and creates a future-dated WordPress post. Publishes text and images natively to LinkedIn, Facebook, and Instagram (via AWS S3 temporary hosting). Nodes used n8n Form Trigger Schedule Trigger Code (Heavy JavaScript for data merging, XML parsing, and DOCX assembly) Google Gemini (Langchain Native Nodes for Text and Image) Google Drive Google Analytics Gmail LinkedIn Facebook Graph API AWS S3 (Temporary public storage for Instagram image ingestion) Compression, Set, If, Merge, HTTP Request (WordPress API) Setup instructions Credentials Setup: You will need active credentials for Google Drive, Google Analytics (OAuth2), Gmail, LinkedIn, Facebook Graph API, AWS S3, and a Google Gemini API key. Your LinkedIn credential must have the openid scope enabled to fetch the user URN dynamically. Run Pipeline A: Run the n8n Form Trigger manually, fill out your company details, and let it generate your initial Markdown strategy file in the root of your Google Drive. Configure Pipeline B: Open the Config: Pipeline B node and enter your GA4 Property ID, notification email address, the direct Drive link to the generated Markdown file, and your preferred Google Trends geographic/language codes. Configure Pipeline C: Open the Config: Pipeline C node and enter your WordPress domain, Facebook Page ID, Instagram Business ID, your S3 bucket details (used to temporarily host images for Instagram), and a notification email address. WordPress Auth: Ensure your WordPress site has Application Passwords enabled to use Basic Auth for the Upload to WP Media node. Activate: Turn the workflow on. Pipeline B and C will run automatically on their schedules. Requirements n8n version 1.60+** (Required for the node types and versions used in this template). AWS S3 bucket with public-read access** (Required to host image URLs temporarily so Instagram's Graph API can fetch them). Google Gemini API credentials** (Budget for ~100k-150k output tokens per monthly run). Google Workspace (Analytics, Drive, Gmail). WordPress site with Basic Auth enabled. LinkedIn account, Facebook Page, and Instagram Business account. Customization ideas Adjust Output Volume:** Modify the JSON prompt in the Build Content Plan Prompt node to generate weekly content (e.g., 2 blogs, 4 social posts) instead of massive monthly batches. Change the Tone:** Update the "Brand Voice" restrictions in the n8n Form Trigger or tweak the system prompts in the Code nodes to match a specific industry style (e.g., highly technical vs. casual). Add Human-in-the-Loop:** Replace the direct link between Pipeline B and C with a Wait node that pauses publishing until a manager clicks an approval webhook link sent via email. Use cases Marketing Agencies:** Scaling monthly content deliverables for multiple clients while ensuring the AI strictly adheres to different brand guidelines. SEO Consultants:** Automating high-volume, keyword-targeted blog clusters backed by Google Analytics gap data. Lean Startups:** Maintaining a massive omnichannel social media and blog presence without hiring a dedicated content team.

Who it's for This n8n workflow is designed for Shopify store owners, e-commerce managers, and digital marketers who want to automate their product promotion across multiple platforms. The workflow automatically creates promotional content for new products and distributes them across various social media and content management platforms. Key Features Automatically detects new Shopify products AI converts product descriptions into clear bullet points Optimizes images for each platform Publishes formatted posts to WordPress Shares content across multiple social platforms Sends notifications after successful posts Requirements Shopify Access Token**: For detecting new products in your store OpenAI API Credentials**: For enhancing product descriptions WordPress API Credentials**: For creating posts and uploading media Social Media Platform Credentials**: Facebook Graph API Telegram Bot API LinkedIn OAuth2 API Discord Bot API Notification Service Credentials**: Gmail OAuth2 Rapiwa API (for WhatsApp) Workflow Steps Shopify Trigger: Detects when a new product is created in your Shopify store Image Processing: Extracts and processes product images from the Shopify data Content Enhancement: Uses OpenAI to convert HTML product descriptions into concise, customer-friendly bullet points WordPress Integration: Creates a blog post on your WordPress site with the product information Multi-Platform Sharing: Automatically shares the product on: Facebook page, Telegram channel, LinkedIn profile and page, Discord channel, Instagram Notification System: Sends completion notifications through multiple channels (Telegram, Gmail, Discord, WhatsApp) Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who it's for This n8n workflow is designed for content curators, digital marketers, and social media managers who want to automate the process of discovering, translating, and publishing news content from multiple reputable sources. It provides a complete end-to-end system capable of reading RSS feeds, extracting articles and images, translating them into a specific language, and automatically publishing the final content to WordPress, Facebook, LinkedIn, and Telegram. Features Reads news from multiple RSS sources (TechCrunch, The - Verge, Analytics India Mag, Wired, The Next Web) Publishes content to WordPress, Facebook, LinkedIn Profile, LinkedIn Page, and Telegram Supports multiple languages with automatic translation (Bengali configured) Extracts article images, resizes them, adds watermarks, and uploads to WordPress Automatically creates WordPress posts and sets featured images Sends notification updates through Discord, Telegram, WhatsApp, and Gmail Runs automatically every hour Processes multiple articles from different feeds at once Requirements Google Translate API credentials for translation WordPress API access for content and media management Social media API credentials (Facebook, Telegram, LinkedIn) Notification service credentials (Discord, WhatsApp, Gmail) Access to the specified RSS feeds Important Notes Workflow runs on an hourly schedule to fetch the latest news Extracts featured images from articles and processes them for publication Content is automatically translated to Bengali (language code: "bn") Images are resized and watermarked before social media posting WordPress posts are created with translated content and featured images Notifications are sent after processing all items from the RSS feeds The workflow includes wait periods to prevent API rate limiting Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Analyze Meta ads with Gemini and Google Sheets Stop manually exporting CSVs and start automating your marketing insights. This workflow is designed for Marketing Agencies, Freelancers, and Media Buyers who want to keep a daily pulse on their Meta (Facebook/Instagram) Ads performance without logging into Ads Manager. It doesn't just scrape data; it uses Google Gemini AI to act as a virtual data analyst. It reviews your campaigns, identifies winning/losing creatives, and writes strategic suggestions for both your agency team and your clients. 🚀 What this workflow does Extracts Data: Wakes up every morning (6:00 AM) to fetch yesterday's Ad and Campaign performance from the Facebook Graph API. Cleans & Filters: Automatically ignores paused or zero-spend campaigns to keep your reports clean. Structuring: Uses a Code node to group Ads intelligently under their respective Ad Sets and Campaigns. AI Analysis: Sends the structured data to Google Gemini. The AI analyzes CTR, CPC, and Spend to identify the "Best Performing Ad" and "Worst Performing Ad" per Ad Set. Reporting: Saves raw Campaign Data to Google Sheets. Saves raw Ad Data to Google Sheets. Saves AI-Generated Insights (Client & Agency suggestions) to a dedicated sheet. Error Handling: If anything breaks (e.g., API token expiry), it instantly sends you an alert via Gmail with the error details. 💡 Key Features Zero-Spend Filter:** Keeps your spreadsheet tidy by excluding inactive ads. Hierarchical Data Processing:** Groups data logically so the AI understands the context of your tests. Dual-Perspective Insights:** The AI generates two types of advice: For the Client: Simple, performance-based updates. For the Agency: Technical optimization tips (e.g., "Pause Ad B, Scale Ad A"). Robust Error Monitoring:** Includes a dedicated error workflow to notify you of failures. 🛠️ Prerequisites To use this template, you will need: Meta/Facebook Developer App:** A System User Access Token with ads_read permission. Google Cloud Console Project:** Enabled APIs for Google Sheets, Gmail, and Vertex AI (Gemini). Google Sheet:** A sheet with three tabs: Campaigns, Ads, and AI_Insights. 📝 Setup Instructions Configure Credentials: Connect your Facebook Graph API and Google accounts in n8n. Set Configuration Node: Open the "Set Configuration" node and paste your Ad Account ID and Email Address for error alerts. Link Google Sheet: Open the three Google Sheets nodes and select your spreadsheet file. Activate: Turn on the workflow and let it run daily! Need help setting this up or want a custom automation for your agency? I specialize in building agentic workflows for consultants and agencies. 📧 Contact me: [email protected]

A production-ready n8n workflow that generates AI avatar videos from images and text using VEED Fabric 1.0, with flexible multi-platform publishing capabilities. Key Capabilities Unlimited Scale Process any number of videos**: Sequential processing ensures each video is fully generated and published before moving to the next Batch processing**: Add multiple video requests to Google Sheet and let the workflow process them automatically No context mixing**: Each video maintains its own configuration throughout the entire pipeline Flexible Publishing Per-video platform selection**: Each video can target different platforms (e.g., Video 1 → Instagram+YouTube, Video 2 → Telegram only) Optional publishing**: Leave PLATFORMS column empty to generate videos without publishing (videos saved to Drive) Supported platforms**: Instagram Reels, YouTube/Shorts, Facebook, Telegram, Threads Platform-specific formatting**: Automatic optimization for each platform's requirements Smart Processing Two TTS providers**: Choose OpenAI or ElevenLabs per video Configurable quality**: Select resolution (480p/720p) and aspect ratio (9:16, 16:9, 1:1) per video Approval workflow**: Review videos before publishing with email approve/reject buttons Error handling**: Automatic error detection with detailed email notifications Status Tracking Real-time status updates**: Google Sheet updates as workflow progresses (new → processing → published) Detailed results**: Per-platform success/failure tracking with post URLs Email reports**: Comprehensive publishing reports with links to all posted content How It Works Input: Add rows to Google Sheet with video details TTS: Generate speech using OpenAI or ElevenLabs Video: VEED Fabric 1.0 creates talking head video Approval: Email with video preview and approve/reject buttons Publish: Sequential publishing to selected platforms Report: Status update in sheet + email with results Requirements Fal.ai API Key (for VEED) Google OAuth (Sheets, Drive, Gmail) TTS: OpenAI or ElevenLabs API Key Social Media credentials (optional, only for platforms you use) Telegram Bot Token (optional, only for Telegram) Node: n8n-nodes-veed Author: VEED.io

Who is this for? This workflow is designed for content creators, social media managers, digital marketers, and business owners who want to automate their content creation and distribution process across multiple platforms. It's perfect for those who regularly create content from PDFs or images and want to streamline their social media posting workflow. Key Features Monitors a specific Google Drive folder for new PDFs or images Extracts text from PDFs or images using AI Optionally generates new images from text using OpenAI's DALL-E Automatically posts content with images to multiple platforms Sends notifications about successful posts Handles different file types with specialized extraction methods Workflow Does This workflow automates monitoring a Google Drive folder for new PDFs and images, extracting content using AI, and distributing it across social media platforms like WordPress, Facebook, Telegram, LinkedIn, and Discord. It can also generate new images from text and sends notifications about successful posts. The process ensures efficient handling of different file types and streamlines content sharing across multiple channels. Requirements Google Drive account with a dedicated folder for content OpenAI API credentials for image generation WordPress API credentials for website posting Social media API credentials: Facebook Graph API Telegram Bot API LinkedIn OAuth2 API Discord Bot API X/Twitter OAuth2 API Gmail credentials for email notifications Rapiwa account for WhatsApp notifications Important Notes Make sure all API credentials are properly configured before running the workflow The workflow handles both PDF and image files differently based on their MIME type Image generation is optional and can be disabled if not needed All social media posting nodes can be individually enabled or disabled based on your needs The workflow includes rate limiting to avoid API restrictions Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who it's for This n8n workflow automatically fetches RSS articles, extracts featured images, and publishes them across multiple social media platforms. The workflow runs on a schedule, processes news articles from an RSS feed, extracts the main image from each article, and posts the content with images to various platforms including WordPress, Facebook, Telegram, LinkedIn, and Discord. Features Scheduled Publishing**: Auto-posts content on your set schedule RSS Integration**: Fetches latest articles from specified sources AI Image Extraction**: Identifies and extracts featured images Image Optimization**: Downloads and resizes for platform-ready display Multi-Platform Posting**: Supports WordPress, Facebook, Telegram, LinkedIn, Discord Notifications**: Confirms posts via WhatsApp, Telegram, Gmail, and Discord Content Validation**: Ensures valid images before posting How It Works The workflow triggers on a schedule to check for new RSS articles It reads the RSS feed from the configured news source Each article's link is processed by an AI agent to extract the featured image URL The image is downloaded and converted to binary data The content is published simultaneously to: WordPress as a blog post with the image set as featured Facebook as an image post Telegram channel as an image post LinkedIn (both personal profile and company page) Discord channel After successful publishing, notifications are sent to multiple channels Requirements OpenAI API credentials** for image extraction using the AI Agent WordPress API credentials** for posting articles and media Facebook Graph API credentials** for page posting Telegram Bot API credentials** for channel posting LinkedIn OAuth2 API credentials** for profile and company page posting Discord Bot API credentials** for channel posting Rapiwa API credentials** for WhatsApp notifications Gmail OAuth2 credentials** for email notifications Important Notes RSS Feed Configuration**: The workflow requires a valid RSS feed URL to function properly Image Processing**: All images are resized to 5000x5000 pixels for consistency Content Validation**: The workflow includes a check to ensure valid image URLs exist before proceeding with posting Platform-Specific Formatting**: Each platform receives appropriately formatted content and image dimensions Notification System**: After successful posting to all platforms, confirmation messages are sent via multiple channels Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who it's for This n8n workflow automatically generates AI-powered content about local news and publishes it across multiple social media platforms. The workflow runs on a schedule, fetches the latest news about a specific topic, creates relevant images with watermarks, and posts the content to various platforms including WordPress, Facebook, Telegram, LinkedIn, and Discord. Features Scheduled Content Generation**: Triggers every 4 hours to create fresh content AI-Powered News Collection**: Uses LangChain agent with OpenAI and SerpAPI to find the latest news about a specific topic (Sirajganj district) Image Generation**: Creates AI images based on the news content using OpenAI's image generation capabilities Watermarking**: Automatically adds branded watermarks to all generated images Multi-Platform Publishing**: Posts content and images to: WordPress (with featured images) Facebook Telegram LinkedIn (both profile and company pages) Discord Notification System**: Sends confirmation messages via WhatsApp (Rapiwa), Telegram, and Gmail after successful posting Content Validation**: Checks if news was found before proceeding with image generation and posting Requirements OpenAI API credentials** for content generation and image creation SerpAPI credentials** for news search WordPress API credentials** for posting articles and media Facebook Graph API credentials** for page posting Telegram Bot API credentials** for channel posting LinkedIn OAuth2 API credentials** for profile and company page posting Discord Bot API credentials** for channel posting Rapiwa API credentials** for WhatsApp notifications Gmail OAuth2 credentials** for email notifications Configure Credentials OpenAI API**: Set up credentials with access to GPT-4 and DALL-E models WordPress API**: Configure access to your WordPress site Social Media APIs**: Set up credentials for Facebook, Telegram, LinkedIn, and Discord Notification Services**: Configure Rapiwa for WhatsApp and Gmail for email Important Notes Topic Configuration**: The workflow is currently set to fetch news about "Sirajganj district", but this can be modified in the "Add tropic" node Image Watermarking**: All images are watermarked with "Sirajganj APP" and Playstore information Content Validation**: The workflow includes a check to ensure news content exists before proceeding with image generation Platform-Specific Formatting**: Each platform receives appropriately formatted content and image dimensions Notification System**: After successful posting to all platforms, confirmation messages are sent via multiple channels Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Description Gain real-time audience intelligence with this cross-platform AI Sentiment Analyzer for Twitter (X) and Facebook. 📊🧠 This workflow consolidates mentions and comments, performs GPT-4o-powered sentiment and keyword analysis, summarizes audience mood, highlights dominant trends, and sends a polished HTML report via email — all automatically. Ideal for marketing and insights teams tracking brand conversations across social platforms. 🚀💬 What This Template Does 1️⃣ Starts manually to fetch the latest Twitter mentions and Facebook post comments. 🕹️ 2️⃣ Merges both datasets into a unified JSON structure for seamless cross-platform analysis. 🧩 3️⃣ Validates incoming API data to ensure completeness before processing. ✅ 4️⃣ Runs a custom JavaScript transformation to normalize all messages and add sentiment placeholders. 🧠 5️⃣ Uses GPT-4o to perform sentiment and keyword trend analysis, returning structured JSON insights. 📈 6️⃣ Parses AI output to extract overall sentiment ratios and detailed post-level analysis. 🔍 7️⃣ Generates a human-readable HTML summary using GPT-4o — featuring emojis, bullet insights, and trend sections. 🎨 8️⃣ Emails the formatted sentiment report directly to the marketing team. ✉️ 9️⃣ Logs API or runtime errors automatically into Google Sheets for transparent monitoring. 🧾 Key Benefits ✅ Provides an automated end-to-end pipeline for sentiment intelligence. ✅ Centralizes Twitter and Facebook audience data in one workflow. ✅ Delivers structured insights ready for dashboards or client reporting. ✅ Generates branded HTML summaries that are ready for emailing. ✅ Improves reliability with built-in error tracking and validation layers. Features Dual-platform integration (Twitter X API + Facebook Graph API). JavaScript logic for merging and normalizing social datasets. GPT-4o-based sentiment classification and keyword extraction. Structured JSON parsing and visualization pipeline. AI-generated HTML summary reports for presentation and sharing. Automated email dispatch via Gmail. Google Sheets logging for audit and debugging. Modular configuration — easily extendable to other social networks. #3 Requirements Twitter OAuth2 credentials for fetching mentions. Facebook Graph API credentials for reading posts and comments. Azure OpenAI (GPT-4o) credentials for sentiment and summary generation. Gmail OAuth2 credentials for automated email delivery. Google Sheets OAuth2 credentials for error logging and tracking. Environment Variables TWITTER_API_KEY FACEBOOK_GRAPH_TOKEN AZURE_OPENAI_API_KEY GMAIL_REPORT_RECIPIENTS GOOGLE_SHEET_ERROR_LOG_ID Target Audience 📈 Marketing and insights teams monitoring audience engagement. 💬 Social media managers analyzing public sentiment. 🧠 Data analysts exploring brand perception trends. 💡 PR and communications teams managing online reputation. 🧾 Operations or automation teams integrating AI analytics into dashboards. Step-by-Step Setup Instructions 1️⃣ Connect all API credentials — Twitter, Facebook Graph, Azure OpenAI, Gmail, and Google Sheets. 2️⃣ Update your Twitter user ID and Facebook Page ID in the respective nodes. 3️⃣ Confirm the merge and validation logic in the Merge Platform Datasets and Validate API Response nodes. 4️⃣ Check that your Azure OpenAI account has GPT-4o access enabled. 5️⃣ Verify the Gmail recipient and test the “Send Email Summary” node for delivery. 6️⃣ Link your Google Sheet with a tab named error log sheet to capture workflow exceptions. 7️⃣ Run the workflow once manually to validate each layer — data, AI response, email delivery. 8️⃣ Optionally, schedule it to run daily or weekly for automated sentiment insights. ✅

Description Automate your weekly cross-platform social media analytics workflow with AI-powered insights. 📊🤖 This system retrieves real-time Twitter (X) and Facebook data, validates and merges the metrics, formats them via custom JavaScript, generates a visual HTML summary with GPT-4o, stores structured analytics in Notion, and broadcasts key results through Gmail and Slack — all in one seamless flow. Perfect for marketing, social media, and growth teams tracking weekly engagement trends. 🚀💬 What This Template Does 1️⃣ Starts on manual execution to fetch the latest performance data. 🕹️ 2️⃣ Collects live metrics from both Twitter (X API) and Facebook Graph API. 🐦📘 3️⃣ Merges API responses into one unified dataset for analysis. 🧩 4️⃣ Validates data completeness before processing; logs missing or invalid data to Google Sheets. 🔍 5️⃣ Uses JavaScript to normalize data into clean JSON structures for AI analysis. 💻 6️⃣ Leverages Azure OpenAI GPT-4o to generate a professional HTML analytics report. 🧠📈 7️⃣ Updates Notion’s “Growth Chart” database with historical metrics for record-keeping. 🗂️ 8️⃣ Sends the HTML report via Gmail to the marketing or analytics team. 📧 9️⃣ Posts a summarized Slack message highlighting key insights and platform comparisons. 💬 Key Benefits ✅ Eliminates manual social media reporting with full automation. ✅ Ensures clean, validated data before report generation. ✅ Delivers visually engaging HTML performance summaries. ✅ Centralizes analytics storage in Notion for trend tracking. ✅ Keeps teams aligned with instant Slack and Gmail updates. Features Dual-platform analytics integration (Twitter X + Facebook Graph). Custom JavaScript node for data normalization and mapping. GPT-4o model integration for HTML report generation. Real-time error logging to Google Sheets for transparency. Notion database update for structured performance tracking. Slack notifications with emoji-rich summaries and insights. Gmail automation for formatted weekly performance emails. Fully modular — easy to scale to other social platforms. Requirements Twitter OAuth2 API credentials for fetching X metrics. Facebook Graph API credentials for retrieving page data. Azure OpenAI credentials for GPT-4o AI report generation. Notion API credentials with write access to “Growth Chart.” Slack Bot Token with chat:write permission for updates. Google Sheets OAuth2 credentials for error logs. Gmail OAuth2 credentials to send HTML reports. Environment Variables TWITTER_API_KEY FACEBOOK_GRAPH_TOKEN AZURE_OPENAI_KEY NOTION_GROWTH_DB_ID SLACK_ALERT_CHANNEL_ID GOOGLE_SHEET_ERROR_LOG_ID GMAIL_MARKETING_RECIPIENTS Target Audience 📈 Marketing and growth teams analyzing engagement trends. 💡 Social media managers tracking cross-channel performance. 🧠 Data and insights teams needing AI-based summaries. 💬 Brand strategists and content teams monitoring audience health. 🧾 Agencies and operations teams automating weekly reporting. Step-by-Step Setup Instructions 1️⃣ Connect all required API credentials (Twitter, Facebook, Azure OpenAI, Notion, Gmail, Slack, Sheets). 2️⃣ Replace the username and page IDs in the HTTP Request nodes for your brand handles. 3️⃣ Verify the JavaScript node output structure for correct field mapping. 4️⃣ Configure the Azure GPT-4o prompt with your preferred tone and formatting. 5️⃣ Link your Notion database and confirm property names match (followers, likes, username). 6️⃣ Add recipient email(s) in the Gmail node. 7️⃣ Specify your Slack channel ID for automated alerts. 8️⃣ Test run the workflow manually to validate end-to-end execution. 9️⃣ Activate or schedule the workflow for regular weekly reporting. ✅

Automated Social Media Content Publishing Factory + System Prompt Composition This workflow is a powerful automation for creating and publishing social media content. It uses AI to generate content and images based on external prompts and schemas, and routes the final posts to various social media platforms. How it Works This workflow operates as a "Content Publishing Factory". It generates platform-optimized content for platforms like LinkedIn, Instagram, Facebook, X (Twitter), Threads, and YouTube Shorts. A key feature is its dynamic system prompt and output schema composition, which pulls content from external Google Docs to ensure consistency. The workflow can also create images to match the content and send the final draft for approval via email before publishing. Use Cases Centralized Content Management**: Store and manage all system prompts and schemas in Google Docs for easy team collaboration and version control. Brand Consistency**: Ensure a consistent brand voice across all social media platforms by centralizing brand guidelines and content rules. Automated Publishing**: Automate content creation, image generation, and publishing, reducing manual effort and design bottlenecks. Fact-checking and Contextual Relevance**: Incorporate real-time research and fact-checking into content to ensure accuracy and relevance. Setup Instructions Google Docs: Create two Google Docs: one for the social media schema and one for the system prompt, and update the respective node IDs in the workflow. API Credentials: Provide credentials for the following services: OpenAI: For the AI agents and content creation. SerpAPI: For the web search tool to perform research. Gmail: For sending content for approval and notifications. Google Drive: For archiving images and final posts. Social Media Platforms: You'll need credentials for the platforms you wish to publish to (X, Instagram, Facebook, LinkedIn, etc.). Image Hosting: The workflow uses imgbb.com to host generated images, requiring an API key. Workflow Logic Routing Agent: The Social Media Router Agent receives a user prompt and uses a toolWorkflow node to route the request to the appropriate content generation workflow. Prompt & Schema Composition: The workflow fetches the system prompt and platform-specific schemas from Google Docs, parses them, and composes a dynamic prompt for the AI agent. Content Creation: The Social Media Content Creator agent uses the composed prompt and a web search tool to generate platform-optimized content and an image suggestion. Image Generation & Archiving: The workflow generates an image from the AI suggestion using an external service and archives both the image and the final post content in Google Drive. Approval Process: The draft content is sent to a Gmail address for approval. Publishing: If the content is approved, the Social Media Publishing Router node directs the content to the correct publishing node for the specified platform (e.g., X Post, Instagram Image, Facebook Post, etc.). Node Descriptions | Node Name | Description | |-----------|-------------| | When chat message received | A trigger node that initiates the workflow based on a chat message. | | Social Media System Prompt | A Google Docs node that retrieves the main system prompt for the AI agent. | | Social Media Schema | A Google Docs node that retrieves the JSON schema for each social media platform's output. | | Social Media Content Creator | An AI agent that generates content based on user prompts, system prompts, and schemas, using a web search tool for research. | | pollinations.ai1 | An HTTP Request node that generates an image from a text prompt using an external service. | | Gmail User for Approval | Sends a draft of the social media post for approval and pauses the workflow until a decision is made. | | Social Media Publishing Router | A Switch node that routes the workflow to the correct publishing node based on the user's selected platform. | | X Post, Instagram Post, Facebook Post, LinkedIn Post | These nodes publish the final, approved content to their respective social media platforms. | Customization Tips You can replace the pollinations.ai image generation service with any other online service that produces an image file. Replace the gpt-4o and gpt-4o-mini models with other LLMs and web search tools to suit your needs. Adjust the content and parameters for each social media platform to better fit your brand and audience. Suggested Sticky Notes for Workflow Start Here**: "Update all Social Media Platform Credentials as required. Adjust parameters and content for each platform to suit your needs". External System Prompt and Schema**: "Create Google Doc for the Social Media Schema and copy the provided schema. Update the Google Doc ID in the Social Media Schema node.". Create Post Image**: "Replace pollinations.ai with any online image generation service that produces an image file you can download". Social Media Content Creator**: "Replace Chat model with other LLMs and test out the results. Add more tools or try other web search tools to suit your use case." Testing Tips Start the workflow with a manual trigger and verify that the social media content and a related image are generated and sent for approval via Gmail. Approve the content in the Gmail email to test the publishing side of the workflow. Check the specified social media accounts to confirm that the post was published correctly. Suggested Tags & Categories SocialMedia Automation AI ContentCreation Publishing GoogleDocs OpenAI

🚀 AI Facebook Post Generator - Complete Setup Guide > Transform your content ideas into viral Facebook posts with AI-powered automation in just 30 minutes! 📋 Prerequisites Checklist What you'll need before we start: ✅ n8n instance (cloud or self-hosted) ✅ Facebook Business Page (not personal profile) ✅ Google account with Sheets & Gmail access ✅ Basic understanding of API credentials ⏱️ Estimated Setup Time: 30-45 minutes 🎯 Difficulty Level: Intermediate 💰 Cost: Free tier available for all services 🎨 What You'll Build By the end of this guide, you'll have: 📝 Smart Content Form - Web form that captures your ideas 🤖 AI Content Optimizer - Gemini AI that polishes your writing 🖼️ Auto Image Generator - Custom visuals created automatically 📊 Content Tracker - Google Sheets logging for analytics 📱 Facebook Publisher - Direct posting to your page 📧 Success Notifications - Email confirmations with post links 🔧 Step-by-Step Setup Step 1: 📘 Facebook Integration Setup 🔸 1.1 Create Your Facebook App Why this matters: This gives your workflow permission to post on your behalf. Navigate to Facebook Developers 🌐 Click "My Apps" → "Create App" Select "Business" as your app type App Name: AI-Content-Poster (or your preferred name) Hit "Create App" > 💡 Pro Tip: Choose a descriptive name - you'll see this in your Facebook activity logs 🔸 1.2 Configure App Settings In your app dashboard: "Add a Product" Find "Facebook Login" → "Set Up" Navigate to Settings → Basic App Domains: Add app.n8n.cloud (for n8n cloud users) Save changes ✅ 🔸 1.3 Generate Your Page Access Token This is the key that unlocks posting powers! 🔑 Go to Tools → Graph API Explorer Select your newly created app Click "Generate Access Token" Required Permissions: pages_manage_posts pages_read_engagement pages_show_list Select your target Facebook page Copy the token (starts with EAAG...) ⚠️ Critical Step - Make Token Long-Lived: In Graph API Explorer, make a GET request to: /oauth/access_token?grant_type=fb_exchange_token&client_id=YOUR_APP_ID&client_secret=YOUR_APP_SECRET&fb_exchange_token=YOUR_SHORT_TOKEN 🔸 1.4 Find Your Page ID Two methods to get your Page ID: Method 1 - Direct from Facebook: Visit your Facebook page Click "About" tab Scroll to find "Page ID" Method 2 - API Explorer: Use Graph API Explorer GET request to: /me/accounts Find your page in the response Step 2: 🔍 Google Services Setup 🔸 2.1 Enable Required APIs Setting up your Google Cloud foundation: Visit Google Cloud Console ☁️ Create new project or select existing "APIs & Services" → "Library" Enable these APIs: ✅ Google Sheets API ✅ Gmail API ✅ Google Drive API (optional) 🔸 2.2 Create Service Account This creates a "robot" account for automated access: "APIs & Services" → "Credentials" "Create Credentials" → "Service Account" Name: ai-facebook-automation "Create and Continue" Skip role assignment → "Continue" "Done" ✅ 🔸 2.3 Download Credentials File Click your service account email "Keys" tab → "Add Key" → "Create New Key" Choose "JSON" format Download and save securely 📁 > 🔒 Security Note: This file contains sensitive credentials. Store it safely! 🔸 2.4 Prepare Your Google Sheets Create your data tracking system: 📊 Sheet 1: Content Log Purpose:** Track all generated content Columns:** A: Date (Ngày) B: Short Content (Nội dung ngắn) C: Full Content (Nội dung đầy đủ) 📝 Sheet 2: Input Tracking Purpose:** Log form submissions Columns:** A: Date B: Time C: Content 🔗 Important: Share both sheets with your service account email (found in the JSON file) Step 3: 🤖 AI Services Configuration 🔸 3.1 Get Your Gemini API Key Power up your AI content generation: Head to Google AI Studio 🎨 Sign in with Google account "Create API Key" Copy the key (starts with AIza...) > 💰 Cost Info: Gemini offers generous free tier limits - perfect for getting started! Step 4: ⚙️ n8n Workflow Configuration 🔸 4.1 Import the Magic ✨ Copy the workflow JSON from the template In n8n: "Import from JSON" Paste the workflow code "Import" to load your new automation 🔸 4.2 Configure Your Credentials 🔑 Facebook Graph API Setup: Settings → Credentials → "Add Credential" Search: "Facebook Graph API" Access Token: Your Page Access Token from Step 1.3 Test connection → Save as: Facebook Page Access 🔍 Google Services Setup: "Add Credential" → "Google Service Account" Upload your JSON file from Step 2.3 Test connection → Save as: Google Services 🧠 Gemini AI Setup: "Add Credential" → "Google PaLM API" Enter your Gemini key from Step 3.1 Save as: Gemini AI 🔸 4.3 Customize Node Settings 📱 Update Facebook Configuration: In "Facebook Graph API" node: Replace "113732581629527" with your Page ID from Step 1.4 In "Facebook Upload Img" node: Replace "113732581629527" with your Page ID from Step 1.4 📊 Update Google Sheets: In "save content" node: Replace Document ID with your Content Log Sheet ID In "Append row in sheet" node: Replace Document ID with your Input Tracking Sheet ID > 💡 Finding Sheet ID: It's the long string in your Google Sheets URL after /spreadsheets/d/ 📧 Update Notification Email: In "Send a message" node: Replace [email protected] with your email address Configure Gmail credentials Step 5: 🧪 Testing & Validation 🔸 5.1 Component Testing 📊 Test Google Sheets Connection: Right-click "Append row in sheet" node "Execute Node" ✅ Verify test row appears in your sheet 🤖 Test Gemini AI: Right-click "Basic LLM Chain" node "Edit Input Data" → Add test content Execute → ✅ Verify AI response quality 🖼️ Test Image Generation: Right-click "HTTP Request" node Ensure valid prompt from previous step Execute → ✅ Check for base64 image data 📱 Test Facebook Upload: Run full workflow with test content ✅ Check your Facebook page for new post ✅ Verify image uploaded correctly 🔸 5.2 End-to-End Victory Test 🎉 "Execute Workflow" on trigger node Submit test content through the form Monitor each node execution 🎊 Celebrate your first AI-generated post! 🎯 Success Indicators Your setup is complete when you see: ✅ Form accepts and processes content ✅ AI generates optimized text + image prompt ✅ Custom image appears in Facebook post ✅ Content logged in Google Sheets ✅ Success email in your inbox ✅ Professional-looking post on your Facebook page 🚨 Troubleshooting Quick Fixes Facebook Issues Token Expired?** → Generate new long-lived token Permission Denied?** → Check page admin rights Invalid Page ID?** → Double-check Page ID format Google Sheets Problems 403 Forbidden?** → Share sheet with service account Sheet Not Found?** → Verify Sheet ID in URL Column Errors?** → Match exact column names AI Content Issues Empty Responses?** → Check Gemini API quotas Poor Quality?** → Adjust AI prompts JSON Errors?** → Validate parsing logic 🎨 Customization Ideas Make it uniquely yours: 🎨 Brand Voice: Adjust AI prompts for your tone ⏰ Scheduling: Add time delays for strategic posting 📈 Analytics: Connect performance tracking tools 🔄 Multi-Platform: Extend to Instagram, LinkedIn 👥 Team Features: Add approval workflows 🎉 You Did It! Congratulations! You've built an AI-powered content machine that will save you hours every week. What's Next? Test with different content types Monitor performance in Google Sheets Refine AI prompts for better results Share your success with the community! Need Help? 🤝 Join n8n Discord Visit Community Forum Check n8n Documentation Ready to revolutionize your content creation? Your AI assistant is waiting! 🚀

Who’s it for This workflow is ideal for marketers, content creators, agencies, and small businesses that want to streamline the process of creating and publishing platform-optimized posts across multiple social media channels. How it works / What it does From a single user prompt, the workflow uses a custom system prompt and schema to generate tailored social media content for LinkedIn, Instagram, Facebook, Twitter (X), Threads, and YouTube Shorts. It creates platform-specific captions, hashtags, calls to action, and even AI-generated image suggestions, then routes the content to the correct publishing channel. How to set up Connect your social media platform credentials in n8n. Add your Google Docs links for the system prompt and content schema. Configure the IMGBB_API_KEY and any other required API credentials. Optionally connect Gmail and Telegram for approval workflows and notifications. Requirements n8n instance (self-hosted or cloud) API credentials for desired platforms Google Docs and Google Drive accounts How to customize the workflow Edit the system prompt and schema in Google Docs to adjust tone, style, and content format for each platform. Modify routing logic or add new platform integrations as needed.

Send one WhatsApp message → Get AI-optimized content across 7+ social platforms. Who It's For Solopreneur managing multiple platforms on the go (X/Twitter, Instagram, LinkedIn, Facebook, TikTok, Threads, YouTube Shorts). What It Solves Eliminates 80% of manual content creation work while maintaining brand consistency across all channels. How It Works AI Content Generation GPT-4/Gemini creates platform-specific posts with hashtags, CTAs, and emojis Auto-generates images via OpenAI/Pollinations.ai SERP API finds relevant trending content Approval Workflow HTML email previews for human review Double-approval system via Gmail integration One-Click Publishing Instagram/Facebook (Graph API) X/Twitter (Official API) LinkedIn (Sales Navigator) Setup Requirements API keys: OpenAI, Gemini, social platform tokens, ImgBB, SERP API Gmail and Telegram for notifications Replace "your-unique-id" placeholders in API nodes Customization Content**: Edit AI prompts for brand voice Approval**: Modify email templates and thresholds Analytics**: Connect Google Sheets for tracking Images**: Switch between AI image generators

AI Social Media Promoter – Automated Blog Sharing Workflow This workflow is built for bloggers, creators, and marketing teams who want to automatically promote new blog content across Instagram, Facebook, and X (Twitter). Its core purpose is to detect new blog posts from your RSS feed and instantly create platform-specific social media posts — complete with AI-generated captions and visuals — to drive traffic from social media back to your blog. Everything runs on autopilot: from detecting a new article to posting eye-catching content on each platform, while logging actions to Google Sheets and sending post previews by email. The result is a consistent and professional online presence with zero manual effort. How it works Once a new blog post appears in your RSS feed, the workflow kicks in. It checks Google Sheets to ensure the post hasn’t already been published. Then it calls GPT-4 to generate unique captions for Instagram, Facebook, and X, based on the post content and your brand’s tone. Simultaneously, OpenAI's GPT-Image generates a custom visual in the right format (square, portrait, or landscape). The workflow then publishes the complete posts using the Meta Graph API (for IG/FB) and X API (Twitter). All actions are logged in a Google Sheet, and a formatted email summary with images is sent to your inbox for review. How to set up To get started, connect the required APIs: OpenAI (for text and images), ImgBB or Cloudinary (for image hosting), Meta (Instagram/Facebook), X (Twitter), Google Sheets, and Gmail. Replace placeholder values in HTTP request nodes — such as your RSS URL, API keys, or spreadsheet ID. You can personalize the prompt content with your blog name, tone of voice, and call-to-action. Once connected, the system is fully automated. You can run it manually, or schedule it to check your blog daily with a Schedule Trigger node.