by Guillaume
🟡 DESCRIPTION This n8n workflow automates the daily generation of comprehensive analytics reports from multiple websites, processes them using OpenAI's powerful language models, and then delivers the insights directly to your email and Slack channels. Designed for digital marketers, website administrators, and data analysts, this template streamlines the tedious process of manually collecting and interpreting website performance data, offering immediate, actionable intelligence. The core problem this workflow solves is the fragmentation and manual effort involved in monitoring numerous website analytics. Instead of logging into multiple Google Analytics accounts or properties daily, this workflow centralizes data extraction, enriches it with AI-powered summaries, and distributes it to your preferred communication platforms. This significantly reduces the time spent on routine reporting, allowing you to focus on strategy and decision-making. Users who would benefit most from this template include: Digital Marketing Agencies: Efficiently generate and share client reports across multiple properties. E-commerce Businesses: Monitor performance of various product sites or regional domains. Content Creators: Track the success of different blogs or content platforms. Anyone managing a portfolio of websites: Gain a unified view of their digital assets' performance. 🟡 SETUP Before importing and running this workflow, ensure you have the following prerequisites in place: ► Google Analytics API Setup: Go to the Google Cloud Console (https://console.cloud.google.com/). Create a new project or select an existing one. Navigate to "APIs & Services" > "Enabled APIs & services." Search for and enable the "Google Analytics Data API" (for GA4) or "Google Analytics Reporting API" (for Universal Analytics, if still in use). Go to "APIs & Services" > "Credentials." Create "OAuth client ID" credentials for a "Web application." Copy your client ID and client secret. In n8n, add a new Google Analytics credential using the "OAuth2" authentication method. Provide the Client ID and Client Secret. You will need to authorize n8n to access your Google Analytics data. Scopes https://www.googleapis.com/auth/analytics.readonly (read-only) or https://www.googleapis.com/auth/analytics (manage) OAuth Redirect URL Already pre-filled by n8n (copy this when creating the Google client) Click Sign in with Google, choose the GA account, and approve the requested scopes. Click Save – n8n tests the token and stores it encrypted. For each yourwebsite.com node, select these credentials and specify the correct Google Analytics View ID (for Universal Analytics) or Property ID (for GA4). ► Email Credentials (SMTP): In n8n, add a new SMTP credential. Provide your SMTP host, port, username, and password. This will be used to send the aggregated reports. ► Slack Credentials: In n8n, add a new Slack credential. Follow the instructions to create a Slack App and generate a Bot User OAuth Token. This token will allow n8n to post messages to your Slack channels. ► OpenAI Credentials: Sign up for an OpenAI account (https://platform.openai.com/). Generate an API Key from your account dashboard. In n8n, add a new OpenAI credential and paste your API Key. ► Website Configuration: The workflow currently includes nodes for yourwebsite.com (1 to 8). For each "Get Report" node (e.g., yourwebsite.com, yourwebsite.com 2, etc.), duplicate or remove them as needed to match the number of Google Analytics properties you wish to monitor. Replace the names and number of websites inside the report maker agent. 🟡 Usage Once you have configured the credentials, you can customize the workflow to fit your specific needs, including leveraging various alternative nodes for sending notifications and reports. This flexibility allows you to integrate seamlessly with your preferred communication tools such as Gmail, Telegram, Outlook, or any other service supported by n8n's extensive node library.
by Dinakar Selvakumar
Description This n8n workflow automatically publishes posts to Instagram Business accounts and Facebook Pages using Google Sheets as your content calendar. You schedule posts in the sheet, and n8n processes them, uploads media (if any), posts via Meta’s Graph API, and updates the sheet with success/failure. n8n How it Works Google Sheets rows marked “Pending” and due for publishing are picked up by a scheduled trigger. Posts are then routed to the proper social platforms and published via Meta’s Graph API. Finally, n8n writes back the publish status and timestamp to the sheet. n8n 🧠 Step-by-Step 1️⃣ Scheduled Trigger The workflow automatically checks Google Sheets at fixed intervals (e.g., every 15 min) for posts that are ready (status = Pending, publish time reached). 2️⃣ Config & Credentials Store reusable settings including: Google Sheets ID & Sheet name Meta App credentials (App ID, App Secret) Access token for Meta Graph API Instagram Business Account ID Facebook Page ID These configs make the workflow modular and secure. 3️⃣ Setup: Create a Meta (Facebook) App To post via the Graph API, you must first set up a Meta developer app: 🔗 Create App (Meta for Developers): Go here to start: https://developers.facebook.com/docs/development/create-an-app/ Steps: Log in at Meta for Developers. Click Create App and choose Business as the app type. Facebook Developers Add a name and contact email. In the app dashboard, Add Product → choose Instagram Graph API and Facebook Login. 📌 After creation, your app will have an App ID and App Secret in Settings → Basic — save both for n8n. 4️⃣ Link Accounts & Get IDs Before publishing you need: Instagram Business account (not a personal account) Facebook Page linked to that Instagram account Link them in Facebook Page settings → Linked Accounts. Then, generate an access token with permissions (instagram_basic, pages_show_list, etc.) using the Graph API Explorer and your new Meta app. From the token response or via Graph API calls, extract: Facebook Page ID Instagram Business Account ID These go into your n8n nodes for publishing. 5️⃣ Fetch & Filter Posts Read rows from Google Sheets and filter those ready to publish (status = Pending, scheduled time reached). 6️⃣ Image Handling If an image link is present, download or retrieve it (Google Drive or external URL). If not, continue with a text-only post. 7️⃣ Platform Routing Route the post to: Instagram publishing branch Facebook publishing branch (or both depending on the sheet’s platform column) 8️⃣ Posting via Meta Graph API Instagram Use Graph API endpoints to create and publish media containers and then make the publish call. Facebook Use Graph API to post to the Facebook Page feed (via /feed or /photos endpoint). 9️⃣ Update Sheet Status After each attempt, update Google Sheets with: Status (Success/Fail) Published timestamp
by mustafa kendigüzel
How it works This automated workflow discovers trending Instagram posts and creates similar AI-generated content. Here's the high-level process: 1. Content Discovery & Analysis Scrapes trending posts from specific hashtags Analyzes visual elements using AI Filters out videos and duplicates 2. AI Content Generation Creates unique images based on trending content Generates engaging captions with relevant hashtags Maintains brand consistency while being original 3. Automated Publishing Posts content directly to Instagram Monitors publication status Sends notifications via Telegram Set up steps Setting up this workflow takes approximately 15-20 minutes: 1. API Configuration (7-10 minutes) Instagram Business Account setup Telegram Bot creation API key generation (OpenAI, Replicate, Rapid Api) 2. Database Setup (3-5 minutes) Create required database table Configure PostgreSQL credentials 3. Workflow Configuration (5-7 minutes) Set scheduling preferences Configure notification settings Test connection and permissions Detailed technical specifications and configurations are available in sticky notes within the workflow.
by Constantine Kissel
Generate research-backed article with n8n Who’s it for Content marketers, SEO teams, and founders who need fast, research-grounded blog posts or long-form articles—multi-language included. Works well for teams that want citations, outlines, and section-by-section drafting with minimal manual effort. How it works / What it does Use a Form to collects domain, keywords, and target language. The workflow refines keywords, finds recent articles and authoritative citations, then synthesizes a master outline and loops through each section: generate search queries → fetch web results → summarize findings → write the section with the advanced model. Finally, it aggregates all sections into a clean Markdown article. Optional delivery nodes (Email, Telegram) and an AI Agent are included but disabled by default.  How to set up Import the workflow JSON into n8n. Add your OpenAI credential Set simple_model / advanced_model in LLM Params Requirements n8n instance with outbound internet access. OpenAI API access (Responses API + web_search_preview). (Optional) Email/Telegram credentials if you want to deliver results async How to customize the workflow Edit prompts in LLM Params and Section Prompts to match tone, structure, and SEO style Tweak recency and source rules in Search Articles / Search Citations.  Insert a human review step before “Write Section”, enable delivery nodes Change working/output languages in the Language node
by Calistus Christian
What this template does Sends you an email (via Gmail) whenever any workflow that references this one fails. The message includes the workflow name/ID, execution URL, last node executed, and the error message. Why it’s useful Centralizes error notifications so you notice failures immediately and can jump straight to the failed execution. Prerequisites A Gmail account connected through n8n’s Gmail node credentials. This workflow set as the Error Workflow inside the workflows you want to monitor. How it works Error Trigger starts this workflow whenever a linked workflow fails. Gmail (Send → Message) composes and sends an email using details from the Error Trigger. Notes Error workflows don’t need to be activated to work. You can’t test them by running manually—errors must occur in an automatically run workflow (cron, webhook, etc.).
by Jamot
This n8n template automatically summarizes your WhatsApp group activity from the past week and generates a team report. Why use this? Remote teams rely on chat for communication, but important discussions, decisions, and ideas get buried in message threads and forgotten by Monday. This workflow ensures nothing falls through the cracks. How it works Runs every Monday at 6am to collect the previous week's group messages Groups conversations by participant and analyzes message threads AI summarizes individual member activity into personal reports Combines all individual reports into one comprehensive team overview Posts the final report back to your WhatsApp group to kick off the new week Setup requirements WhatsApp (whapAround.pro) no need Meta API Gemini AI (or alternative LLM of choice) Best practices Use one workflow per WhatsApp group for focused results Filter for specific team members if needed Customize the report tone to match your team culture Adjust the schedule if weekly reports don't suit your team's pace Customization ideas Send reports via email instead of posting to busy groups Include project metrics alongside message summaries Connect to knowledge bases or ticket systems for additional context Perfect for project managers who want to keep distributed teams aligned and ensure important conversations don't get lost in the chat noise.
by Hunyao
What it does Automatically monitors multiple subreddits daily, identifies trending posts with high engagement, and delivers AI-powered summaries directly to your inbox. Never miss important discussions in your favorite communities again. Perfect for Investors tracking market sentiment, researchers monitoring industry discussions, content creators finding trending topics, or anyone wanting curated Reddit insights without endless scrolling. Apps used Reddit, OpenRouter (GPT-4o mini), Gmail How it works Triggers daily at your chosen time across all specified subreddits Fetches hot posts from the last 24 hours with scores above 30 upvotes Sorts posts by engagement score to prioritize trending content Extracts post content plus top-level comments for full context Generates concise AI summaries for each high-value thread Compiles summaries into a clean HTML email digest Delivers the digest to your Gmail inbox with clickable Reddit links Setup Configure these three essential settings: Schedule time: Set your preferred daily delivery time in the Schedule Trigger node. **Replace with your preferred hour (currently 6 AM). Note: Times display in your workflow timezone Topic and subreddits: In the "Set Topic, Subreddits and Email Address" node, **replace with your topic name (e.g., "Investing") and replace with your subreddit array (e.g., ["investing", "stocks"]) Email recipient: **Replace with your Gmail address in the same node Credentials Reddit OAuth2 for API access, OpenRouter API key for AI summaries, Gmail OAuth2 for email delivery If you have any questions in running the workflow, feel free to reach out to me at my youtube channel: https://www.youtube.com/@lifeofhunyao
by Angel Menendez
Who is this for? Public-facing professionals (developer advocates, founders, marketers, content creators) who get bombarded with LinkedIn messages that aren't actually for them - support requests when you're in marketing, sales inquiries when you're a devrel, partnership pitches when you handle content, etc. What problem is this workflow solving? When you're visible online, people assume you handle everything at your company. You end up spending hours daily playing human router, forwarding messages like "How do I reset my password?" or "What's your enterprise pricing?" to the right teams. This LinkedIn automation workflow stops you from being your company's unofficial customer service representative. What this workflow does This AI-powered LinkedIn DM management workflow automatically assesses incoming LinkedIn messages and routes them intelligently: Automated Message Assessment: Receives inbound LinkedIn messages via UniPile and looks up sender details from both personal and company LinkedIn profiles. Smart Route Matching: Compares the message content against your message routing workflow table in Notion, which contains: Question: "How can I become an n8n ambassador?" Description: "Route here when a user is requesting to become an n8n ambassador. Also when they're asking how they could do more to evangelize n8n in their city, or to start organizing n8n meetups and events in their city." Action: "Tell the user to open the following notion page which has details on ambassador program including how to apply, as well as perks of the program: https://www.notion.so/n8n-Ambassador-Program-d883b2a130e5448faedbebe5139187ea?pvs=21" AI Response Generation: When a message matches an existing route, this AI assistant generates a personalized response draft based on the "Action" instructions from your routing table. Human-in-the-Loop Approval: Sends the draft response to Slack with approve/reject buttons, so you maintain control while saving time. Draft can be edited from within Slack on desktop and mobile. Automated LinkedIn Responses: Once approved, sends the reply back via LinkedIn and marks the original message as handled. The result: You stop being a human switchboard and can focus on your actual job while people still get helpful, timely responses through automated customer service. You can also add routes for things you do handle but get asked about daily (like 'How do I join your beta?' or 'What's your content strategy?') to standardize your responses. Setup Sign up for a UniPile account and create a webhook under the Messaging section Set the callback URL to this workflow's production URL Generate a UniPile API key with all required scopes and store it in your n8n credentials Create a Slack app and enable interactive message buttons and webhooks Here is a slack App manifest template for easy deployment in slack: { "display_information": { "name": "Request Router", "description": "A bot that alerts when a new linkedin question comes in.", "background_color": "#12575e" }, "features": { "bot_user": { "display_name": "Request Router", "always_online": false } }, "oauth_config": { "scopes": { "bot": [ "chat:write", "chat:write.customize", "chat:write.public", "links:write", "im:history", "im:read", "im:write" ] } }, "settings": { "interactivity": { "is_enabled": true, "request_url": "Your webhook url here" }, "org_deploy_enabled": false, "socket_mode_enabled": false, "token_rotation_enabled": false } } Set up your Notion database with the three-column structure (Question, Description, Action) Configure the AI node with your preferred provider (OpenAI, Gemini, Ollama etc) Replace placeholder LinkedIn user and organization IDs with your own How to customize this workflow to your needs Database Options**: Swap Notion with Google Sheets, Airtable, or another database Filtering Logic**: Add custom filters based on keywords, message length, follower count, or business logic AI Customization**: Adjust the system prompt to match your brand tone and response goals Approval Platform**: Replace Slack with email, Discord, or another review platform Team Routing**: Use Slack metadata to route approvals to specific team members based on message category Enrichment**: Add secondary data enrichment using tools like Clearbit or FullContact Response Rules**: Create conditional logic for different response types based on sender profile or message content Perfect for anyone who's tired of being their company's accidental customer service department while trying to do their real job. This LinkedIn automation template was inspired by a live build done by Max Tkacz and Angel Menendez for The Studio.
by Muhammad Nouman
How it works This workflow turns a Google Drive folder into a fully automated YouTube publishing pipeline. Whenever a new video file is added to the folder, the workflow generates all YouTube metadata using AI, uploads the video to your YouTube channel, deletes the original file from Drive, sends a Telegram confirmation, and can optionally post to Instagram and Facebook using permanent system tokens. High-level flow: Detects new video uploads in a specific Google Drive folder. Downloads the file and uses AI to generate: • a polished first-person YouTube description • an SEO-optimized YouTube title • high-ranking YouTube tags Uploads the video to YouTube with the generated metadata. Deletes the original Drive file after upload. Sends a Telegram notification with video details. (Optional) Posts to Instagram & Facebook using permanent system user tokens. Set up steps Setup usually takes a few minutes. Add Google Drive OAuth2 credentials for the trigger and download/delete nodes. Add your OpenAI (or Gemini) API credentials for title/description/tag generation. Add YouTube OAuth2 credentials in the YouTube Upload node. Add Facebook/Instagram Graph API credentials if enabling cross-posting. Replace placeholder IDs (Drive folder ID, Page ID, IG media endpoint). Review sticky notes in the workflow—they contain setup guidance and token info. Activate the Google Drive trigger to start automated uploads.
by Intuz
This n8n template from Intuz provides a complete and automated solution for creating an autonomous social media manager. This workflow uses an AI agent to intelligently generate unique, high-quality content, check for duplicates, and post it on a consistent schedule to automate your entire Twitter presence. Who's this workflow for? Social Media Managers Marketing Teams & Agencies Startup Founders & Solopreneurs Content Creators How it works 1. Runs on a Schedule: The workflow automatically starts at a set interval (e.g., every 6 hours), ensuring a consistent posting schedule. 2. AI Generates a New Tweet: An advanced AI Agent, powered by OpenAI, uses a detailed prompt to craft a new, engaging tweet. The prompt defines the tone, topics, character limits, and hashtags. 3. Checks for Duplicates: Before finalizing the tweet, the AI Agent is equipped with a tool to read a Google Sheet containing a log of all previously published posts. This allows it to ensure the new content is always unique. 4. Posts to Twitter (X): The final, unique tweet is automatically posted to your connected Twitter account. 5. Logs the New Post: After posting, the workflow logs the new tweet back into the Google Sheet, updating the history for the next run. This completes the autonomous loop. Setup Instructions Schedule Your Posts: In the Start Workflow (Schedule Trigger) node, set the frequency you want the workflow to run (e.g., every 6 hours). Connect OpenAI: Add your OpenAI API key in the OpenAI Chat Model node. Customize the prompt in the AI Agent node to match your brand's voice, target keywords, and specific URLs. Configure Google Sheets: Connect your Google Sheets account. Create a sheet with two columns: Tweet Content and Status. In both the Get Data from Google Sheet and Add new Tweet to Google sheet nodes, select your credentials and specify the Document ID and Sheet Name. Connect Twitter (X): In the Create Tweet node, connect the Twitter account where you want to post. Activate Workflow: Save the workflow and toggle the "Active" switch to ON. Your AI social media manager is now live! Key Requirements to Use This Template Before you start, please ensure you have the following accounts and assets ready: An n8n Instance: An active n8n account (Cloud or self-hosted) where you can import and run this workflow. OpenAI Account: An active OpenAI account with an API Key. You will need to have billing enabled to use the language models for tweet generation. Google Account & Sheet: A Google account and a pre-made Google Sheet. The sheet must have two specific columns: Tweet Content and Status. Twitter (X) Developer Account: A Twitter (X) account with an approved Developer profile. You need an App created within the Developer Portal with the necessary permissions (v2 API access with Write scopes) to post tweets automatically. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started
by Arbaz Asif
Overview: Automated Occasion Wisher How it works Runs daily to check if today matches any birthday, anniversary, or special occasion in your Google Sheet AI Agent reads the sheet and returns a list of users having a special occasion to wish with details and a personalized wishing message If there is no one to wish, no email is sent. If there are multiple people to wish, multiple personalized emails are sent Setup steps Connect your Google Sheet containing columns as: Name, Occasion_Date, Email, Occasion_Type, Relationship, Personal_Note Insert the AI prompt ensuring strict JSON output (list format only) Configure the Email node for sending the final message Customization Edit AI prompt to change message tone, length, or emojis Add support for multiple reminder styles (e.g., early notification) Extend with logging, Slack alerts, or saving sent email history
by Pixcels Themes
Who’s it for This template is for clinics, hospitals, care teams, and telemedicine providers who need a structured, automated system for post-surgery follow-up. It helps reduce manual workload while ensuring every patient gets timely check-ins and appropriate triage. What it does / How it works This workflow automates daily recovery monitoring using Google Sheets and Telegram. It sends scheduled check-in messages to all patients within their follow-up window. When a patient replies, the message is: Captured by Telegram Trigger Cleaned and structured Summarized by an AI agent Classified into low, moderate, or high intensity Based on the intensity level: Low:** Sends a supportive, non-urgent response Moderate:** Sends guidance + schedules a follow-up event in Google Calendar High:** Sends an alert email to the doctor via Gmail All logic runs automatically. Requirements Google Sheets OAuth2 credentials Gmail OAuth2 credentials Google Calendar OAuth2 credentials Telegram Bot credentials Gemini API credentials A Google Sheet with patient name, surgery type, follow-up duration, and doctor email How to set up Connect all required credentials inside n8n. Replace the Google Sheet ID with your own patient sheet. Adjust column mappings if your sheet structure differs. Test by sending a Telegram message to your bot. Enable the Schedule Trigger to begin automated daily follow-ups. How to customize the workflow Modify AI prompts inside the AI Agent nodes Adjust triage logic for intensity levels Change follow-up intervals in the Schedule Trigger Add additional notification channels (SMS, Slack, CRM logging)