Agents & Automations

What this workflow does - Monitors Google Drive: The workflow triggers whenever a new CSV file is uploaded. - Uses AI to Identify PII Columns: The OpenAI node analyzes the data and identifies PII-containing columns (e.g., name, email, phone). - Removes PII: The workflow filters out these columns from the dataset. - Uploads Cleaned File: The sanitized file is renamed and re-uploaded to Google Drive, ensuring the original data remains intact. How to customize this workflow to your needs - Adjust PII Identification: Modify the prompt in the OpenAI node to align with your specific data compliance requirements. - Include/Exclude File Types: Adjust the Google Drive Trigger settings to monitor specific file types (e.g., CSV only). - Output Destination: Change the folder in Google Drive where the sanitized file is uploaded. SetupPrerequisites: - A Google Drive account. - An OpenAI API key. Workflow Configuration: - Configure the Google Drive Trigger to monitor a folder for new files. - Configure the OpenAI Node to connect with your API. - Set the Google Drive Upload folder to a different location than the Trigger folder to prevent workflow loops.

Who Is This For This workflow is ideal for content creators, solo founders, marketers, and AI enthusiasts who want to automate the full process of blog content creation. It is especially useful for professionals in tech, AI, and automation who publish frequently and need SEO-ready content fast. What Problem Does This Workflow Solve Creating SEO-optimized blog content is time-consuming and requires consistency. Manually researching trending topics slows down the content pipeline. Formatting, publishing, and promoting across multiple platforms takes effort. This workflow automates the entire process from research to publication. What This Workflow Does - Research: Uses Perplexity AI to gather up-to-date content ideas via form input. - Content Generation: GPT-4 creates a short, SEO-optimized article (max 20 lines) with H1, H2 structure and meta-description. - Publishing: Automatically posts the content to WordPress. - Email Notification: Sends the article title and URL via Gmail. - Slack Notification: Notifies a specified Slack channel when the article is live. - Database Logging: Saves the article details to a Notion database. Setup GuidePrerequisites - WordPress account with API access - OpenAI API Key - Perplexity API Key - Slack Bot Token - Notion integration (Database ID) - Gmail API credentials (optional) Community Node Required: This workflow uses n8n-nodes-mcp, which only works on self-hosted instances of n8n. To install: Go to Settings > Community Nodes > Install n8n-nodes-mcp Steps 1. Import the workflow into your n8n instance 2. Install the required community node (n8n-nodes-mcp) 3. Set up API credentials for OpenAI, Perplexity, WordPress, Slack, Gmail, and Notion 4. Customize the form trigger with your preferred prompt 5. Run a test using a sample topic How to Customize This Workflow - Modify the research prompt to match your niche or industry - Adjust GPT-4 settings for tone, structure, or content length - Customize Notion fields (e.g., add tags, categories, or labels) - Add logic for generating or assigning featured images automatically

Streamline communication by transcribing Telegram files with ChatGPT's Whisper. Automatically download, transcribe, and reply to the message in Telegram.

This workflow implements a Retrieval Augmented Generation (RAG) chatbot that answers employee questions based on company documents stored in Google Drive. It automatically indexes new or updated documents in a Pinecone vector database, allowing the chatbot to provide accurate and up-to-date information. The workflow uses Google's Gemini AI for both embeddings and response generation. How it works The workflow uses two Google Drive Trigger nodes: one for detecting new files added to a specified Google Drive folder, and another for detecting file updates in that same folder. Automated Indexing: When a new or updated document is detected 1. The Google Drive node downloads the file. 2. The Default Data Loader node loads the document content. 3. The Recursive Character Text Splitter node breaks the document into smaller text chunks. 4. The Embeddings Google Gemini node generates embeddings for each text chunk using the text-embedding-004 model. 5. The Pinecone Vector Store node indexes the text chunks and their embeddings in a specified Pinecone index. 6. The Chat Trigger node receives user questions through a chat interface. The user's question is passed to an AI Agent node. 7. The AI Agent node uses a Vector Store Tool node, linked to a Pinecone Vector Store node in query mode, to retrieve relevant text chunks from Pinecone based on the user's question. 8. The AI Agent sends the retrieved information and the user's question to the Google Gemini Chat Model (gemini-pro). 9. The Google Gemini Chat Model generates a comprehensive and informative answer based on the retrieved documents. 10. A Window Buffer Memory node connected to the AI Agent provides short-term memory, allowing for more natural and context-aware conversations.

Workflow overview: This workflow is designed for dynamic and intelligent conversational capabilities. It incorporates Meta's llama3.3-versatile model for personal assistant. There are no issues when sending simple text to the LINE reply API, so in this workflow you can see how to handle large and complex text sending from AI chat without any errors. Workflow description: The user uses the Line Messaging API to send a message to the chatbot. 1. Create a Line business ID. 2. Set the message from Step 1 to the proper value. 3. Send the message to process at Groq using the API key that we have created from Groq. 4. Send the reply message from the AI Agent back to the Line Messaging API account. Key Features: - Utilizes Meta's llama 3.3 model for robust conversational capabilities. - Handles large and complex text interactions with ease, ensuring reliable connections to the LINE Messaging API. - Demonstrates effective strategies for processing and responding to large and complex text inputs from AI chat.

Boost engagement on your Discord server by automatically sharing new YouTube videos along with AI-generated summaries of their content. This workflow is ideal for content creators and community managers looking to provide value and spark interest through summarized content, making it easier for community members to decide if a video is of interest to them. How it works - RSS Feed Trigger: Monitors your YouTube channel for new uploads using the RSS feed. - Video Captions Retrieval: Fetches video captions using the YouTube API to get detailed content data. - AI Summary Generation: Uses an AI model to generate concise summaries from the video captions, highlighting key points. - Discord Notification: Posts video announcements along with their AI-generated summaries to a specified Discord channel using a webhook. Set up steps 1. Configure YouTube RSS Feed: Set up the RSS feed node to detect new video uploads. Add your YouTube channel ID to the URL in the first node: https://www.youtube.com/feeds/videos.xml?channel_id=YOUR_CHANNEL_ID. 2. Connect OpenAI Account: To enable AI summary generation, connect your OpenAI account in n8n. 3. Set Up Discord Webhook: Create a webhook in your Discord server and configure it in the Discord node. 4. Design the Message: Format the Discord message as you like to include the video title, link, and the AI-generated summary. Example This template empowers you to maintain a highly engaging Discord community, ensuring members receive not only regular updates but also valuable insights into each video's content without needing to watch immediately.

Automatically get records in one Airtable and create records in another with AI-generated responses using ChatGPT via a custom webhook. Streamline data management and communication effortlessly between different tables.

This template attempts to replicate OpenAI's DeepResearch feature, which, at the time of writing, is only available to their pro subscribers. An agent that uses reasoning to synthesize a large amount of online information and complete multi-step research tasks for you. Though the inner workings of DeepResearch have not been made public, it is presumed the feature relies on the ability to deep search the web, scrape web content, and invoke reasoning models to generate reports. All of which n8n is really good at! Using this workflow, n8n users can enjoy a variation of the Deep Research experience for themselves and their teams at a fraction of the cost. Better yet, learn and customize this Deep Research template for their businesses and/or organizations. How it works A form is used to first capture the user's research query and how deep they'd like the researcher to go. Once submitted, a blank Notion page is created which will later hold the final report, and the researcher gets to work. The user's query goes through a recursive series of web searches and web scraping to collect data on the research topic to generate partial learnings. Once complete, all learnings are combined and given to a reasoning LLM to generate the final report. The report is then written to the placeholder Notion page created earlier. How to use Duplicate this Notion database template and make sure all Notion-related nodes point to it. Sign up for APIFY.com API Key for web search and scraping services. Ensure you have access to OpenAI's o3-mini model. Alternatively, switch this out for the o1 series. You must publish this workflow and ensure the form URL is publicly accessible. On depth & breadth configuration For more detailed reports, increase depth and breadth but be warned the workflow will take exponentially longer and cost more to complete. The recommended defaults are usually good enough. - Depth=1 & Breadth=2 - will take about 5 - 10 mins. - Depth=1 & Breadth=3 - will take about 15 - 20 mins. - Depth=3 & Breadth=5 - will take about 2+ hours! Customizing this workflow I deliberately chose not to use AI-powered scrapers like Firecrawl as I felt these were quite costly and quotas would be quickly exhausted. However, feel free to switch web search and scraping services that suit your environment. Maybe you don't decide to source the web and instead, data collection comes from internal documents. This template gives you the freedom to change this. Experiment with different reasoning/thinking models such as Deepseek and Google's Gemini 2.0. Finally, the LLM prompts could definitely be improved. Refine them to fit your use case.

Experience Eden AI's text generation from prompts, effortlessly integrating with Google Sheets. Create enticing content ideas within moments for all digital endeavors.

Detailed Description The ToDo App workflow is designed to streamline task management through Telegram and Google Tasks integration. This workflow allows users to create, update, and manage tasks via Telegram messages, leveraging AI capabilities to enhance user interaction. The expected outcome is a seamless experience where users can manage their tasks efficiently without needing to switch between applications. Who is this for? This workflow is intended for: - Individuals looking for an efficient way to manage their tasks directly from Telegram. - Teams that require a collaborative task management solution integrated with Google Tasks. - Developers interested in automating task management processes using n8n and Telegram. What problem does this workflow solve? Managing tasks can often be cumbersome, especially when switching between different applications. This workflow addresses the following problems: - Fragmented Task Management: Users can manage tasks directly from Telegram, reducing the need to switch to Google Tasks. - Inefficient Communication: By integrating AI, users can interact with the task management system in a conversational manner, making it more intuitive. - Task Updates: Users can easily update task statuses and details through simple messages, enhancing productivity. What this workflow does The ToDo App workflow performs the following functions: - Incoming Message Handling: Listens for messages sent to a Telegram bot. - Task Creation: Allows users to create new tasks based on their messages. - Task Updates: Users can update existing tasks by sending specific commands. - Task Retrieval: Retrieves today's and upcoming tasks from Google Tasks. - Voice Note Transcription: Supports voice messages, converting them into text for task management. - AI Assistance: Utilizes an AI agent to assist users in managing their tasks effectively. SetupPrerequisites Before setting up the workflow, ensure you have the following: - n8n Account: Sign up for an n8n account if you don't have one. - Telegram Bot: Create a Telegram bot and obtain the API token. - Google Tasks API: Set up Google Tasks API and obtain OAuth2 credentials. - OpenAI API Key: Sign up for OpenAI and obtain an API key for AI functionalities. Setup Process Upload the JSON for this workflow and set up the authentication for the different tools. How to customize this workflow To adapt the ToDo App workflow to different needs, consider the following customizations: - Change Task Management Platform: If you prefer a different task management tool, replace the Google Tasks nodes with your preferred service's API. - Modify AI Responses: Adjust the AI agent's system message to change how it interacts with users. - Add Additional Commands: Expand the workflow by adding more commands for different task management functionalities (e.g., deleting tasks). - Integrate Other Messaging Platforms: If you want to use a different messaging service, replace the Telegram nodes with the appropriate nodes for that service. Conclusion The ToDo App workflow provides a powerful solution for managing tasks through Telegram, enhancing productivity and user experience. By following the setup instructions and customization options, users can tailor the workflow to meet their specific needs, making task management more efficient and accessible.

Daily Economic News Brief for Israel (Hebrew, RTL, GPT-4o) Stay ahead of the curve with this AI-powered workflow that delivers a daily economic summary tailored for professionals tracking the Israeli economy. At 8:00 PM Israel Time, this workflow: - Retrieves the latest articles from Calcalist and Mako via RSS - Filters duplicates and irrelevant stories - Uses OpenAI’s GPT-4o to identify the 5 most important stories of the day - Summarizes each article in concise, readable Hebrew - Generates a fully styled, responsive HTML email (with proper RTL layout) - Sends it to your inbox using your preferred SMTP email provider Perfect for economists, analysts, investors, or policymakers who want an actionable and personalized news digest -- no distractions, no fluff. Setup InstructionsEstimated setup time: 10 minutes Required credentials: - OpenAI API Key - SMTP credentials (for email delivery) Steps: 1. Import this template into your n8n instance. 2. Add your OpenAI API Key under credentials. 3. Configure the SMTP Email node with: - Host (e.g. smtp.gmail.com) - Port (465 or 587) - Username (your email) - Password (app-specific password or login) 4. Set your target email address in the last node. 5. (Optional) Customize the GPT prompt to adjust tone or audience (e.g. general public, policymakers). 6. Activate the workflow and receive daily updates straight to your inbox. Customization Tips - Change the RSS sources to pull from other Hebrew or international news websites. - Modify the summarization prompt to fit different sectors (e.g. tech, health, politics). - Add integrations like Notion, Airtable, or Telegram for logging or distribution. - Apply your branding to the HTML output (logos, footer, colors). Why Use This? This is more than a news digest. It’s an intelligent economic assistant that filters noise, highlights what matters, and keeps you informed - automatically. You can set it up in 10 minutes and benefit every single day.

Master Facebook Ads copywriting using the Pain, Agitate, Solution (PAS) framework with Notion and ChatGPT. Enhance ad performance and boost engagement by addressing your audience's pain points and offering effective solutions.

Get competitor mentions from a call and their associated products and services, strengths, and weaknesses using AI to enable sales teams to build more effective strategies.

This workflow is designed for dynamic and intelligent conversational capabilities. It incorporates OpenAI's GPT-4o model for natural language understanding and generation. Additional tools include SerpAPI and Wikipedia for enriched, data-driven responses. The workflow is triggered manually and utilizes a 'Window Buffer Memory' to maintain the context of the last 20 interactions for better conversational continuity. All these components are orchestrated through n8n nodes, ensuring seamless interconnectivity. To use this template, you need to be on n8n version 1.50.0 or later.

Create high-quality voice overs easily using ElevenLabs from WordPress articles. Streamline the process by uploading links directly to a Google Sheet for enhanced content management.

How it works • Automates multi-platform social media posting (Instagram, YouTube, TikTok, etc.) using AI-generated content. • Integrates Airtable, n8n, and Blotato for full content scheduling and publishing. • Supports both image and video uploads with dynamic text and account routing. Set up steps • Takes ~15–30 minutes to set up depending on how many platforms you connect. • Requires Airtable personal access token and Blotato API key. • Uses sticky notes throughout the workflow to explain config, tokens, and troubleshooting clearly.

The Chinese Translator workflow automates the translation of text into Chinese characters, pinyin, and English translations via Line Messaging API. This workflow leverages OpenRouter.ai to call advanced language models such as Qwen for accurate translations and ensures smooth user interaction by providing loading animations and timely replies. Purpose This workflow aims to: - Provide users with real-time translations of input text into Chinese characters, pinyin, and English. - Deliver a seamless user experience through interactive features like loading animations and quick reply messages. - Enable easy integration with Line Messaging API for scalable deployment. Key Features - Real-Time Translation: Translates user-inputted text instantly using OpenRouter.ai's standardized API. - Comprehensive Output: Delivers Chinese characters, pinyin, and English translations for each word or phrase. - Interactive User Experience: Incorporates loading animations to inform users that the workflow is processing their request. - Line Integration: Utilizes Line Webhooks and Reply APIs to facilitate communication between users and the translation service. Data Flow - Receiving Input - Node: Line Webhook - Captures incoming messages from Line users. - Extracts the text content and reply token from the webhook payload. - Loading Animation - Node: Line Loading Animation - Sends a loading animation back to the user, indicating that the workflow is processing the request. - Enhances user experience by providing immediate feedback. - Translation Processing - Node: Use OpenRouter - Sends the extracted text to OpenRouter.ai's API, utilizing the Qwen model for translation. - Requests Chinese characters, pinyin, and English translations for the input text. - Sending Response - Node: Line Reply - Formats the translation results into a readable text message. - Sends the translated text back to the user via Line's Reply API. Intended Audience This workflow is ideal for: - Language Learners: Seeking quick translations and pronunciation guides for Chinese language studies. - Travelers: Looking to communicate effectively while traveling in Chinese-speaking regions. - Businesses: Aiming to provide multilingual support to customers and clients. Benefits - Enhanced Learning: Provides comprehensive translations, including pinyin, aiding in language acquisition. - User-Friendly Interface: Real-time loading animations and prompt replies ensure a smooth user experience. - Scalable Deployment: Easily integrates with Line's extensive user base for widespread accessibility.

Tags: EU Legislation, Sustainability, Automation, Web Scraping, OpenAI, Google Sheets, Policy Monitoring, Climate Hey! I’m Samir, a Supply Chain Engineer and Data Scientist from Paris, and the founder of LogiGreen Consulting. We use AI, automation, and data to support sustainable business practices for small, medium, and large companies. This workflow is part of our broader initiative to monitor and act on sustainability legislation in Europe. How do you know if new EU laws will impact your business's sustainability goals? This n8n workflow automatically scrapes the EU Parliament’s legislative portal to find and flag procedures related to environmental sustainability. 📬 For business inquiries, feel free to connect with me on LinkedIn. Who is this template for? This workflow is useful for: - Sustainability consultants monitoring legal frameworks - NGOs and researchers tracking environmental regulations - Companies aligning with CSRD or EU Green Deal objectives - Policy analysts looking for automation tools What does it do? This n8n workflow: - 🌐 Scrapes the EU Parliament legislative portal for yesterday’s entries - 🧠 Uses OpenAI to classify if each procedure is related to sustainability - 🗂️ Filters out irrelevant items - 📊 Saves the results in a Google Sheet - ✅ Creates a Google Task for each relevant file to review the legislation How it works: - Trigger manually or on schedule - Scrape HTML blocks for scheduled debates - Parse each procedure to extract Title, Committee, Rapporteur, PDF link - Call GPT-4-turbo to check if the topic matches sustainability criteria - Filter responses based on “yes” or “no” - Store valid items into Google Sheets - Generate tasks in Google Tasks The AI only flags procedures that directly impact the environment, circular economy, or pollution control. What do I need to get started? You’ll need: - A Google Sheet connected to your n8n instance - An OpenAI account with GPT-4 access - A Google Task List Follow the Guide! Follow the sticky notes in the workflow or check my tutorial to configure each node and start using AI to monitor sustainability regulations in Europe. 🎥 Watch My Tutorial Notes: AI filters are strict — you can customise the system prompt to match your needs. This is ideal for tracking legislative risk for climate regulations. Submitted: April 21, 2025

Who's this for? - If you own a website and need to analyze your keyword rankings. - If you need to create a keyword report on your rankings. - If you want to grow your keyword positions. SerpBear is an open-sourced SEO tool specifically for keyword analytics. Example output of A.I.Key Observations about Ranking Performance: - The top-performing keyword is “Openrouter N8N” with a current position of 7 and an improving trend. - Two keywords, “Best Docker Synology” and “Bitwarden Synology,” are not ranking in the top 100 and have a stable trend. - Three keywords, “Obsidian Second Brain,” “AI Generated Reference Letter,” and “Actual Budget Synology,” and “N8N Workflow Generator” are not ranking well and have a declining trend. Keywords showing the most improvement: - “Openrouter N8N” has an improving trend and a relatively high ranking of 7. Keywords needing attention: - “Obsidian Second Brain” has a declining trend and a low ranking of 69. - “AI Generated Reference Letter” has a declining trend and a low ranking of 84. - “Actual Budget Synology,” “N8N Workflow Generator,” “Best Docker Synology,” and “Bitwarden Synology” are not ranking in the top 100. Use case Instead of hiring an SEO expert, I run this report weekly. It checks the keyword rankings of the past week and gives me recommendations on what to improve. How it works The workflow gathers SerpBear analytics for the past 7 days. It passes the data to openrouter.ai for A.I. analysis. Finally, it saves to Baserow. How to use this - Input your SerpBear credentials. - Enter your domain name. - Input your Openrouter.ai credentials. - Input your Baserow credentials. You will need to create a Baserow database with columns: Date, Note, Blog.

Workflow Description for n8n: Social Media Post from Ideas Copy This workflow automates the process of creating and publishing social media posts across multiple platforms (Twitter/X, Facebook, LinkedIn, and Instagram) based on content from a WordPress post. It uses AI models to generate platform-specific captions and images, and integrates with Google Sheets, WordPress, and various social media APIs. It is a powerful tool for automating social media post creation and publishing, saving time and ensuring consistent, platform-optimized content across multiple channels. Below is a breakdown of the workflow: 1. How It Works The workflow is designed to streamline the creation and publishing of social media posts. Here's how it works: Trigger: The workflow starts with a Manual Trigger node, which initiates the process when the user clicks "Test workflow." Fetch Data: The Google Sheets node retrieves the WordPress Post ID from a predefined Google Sheet. The Get Post node fetches the corresponding WordPress post content using the retrieved Post ID. Generate Social Media Content: The Social Media Manager node uses an AI model (OpenRouter) to analyze the WordPress post and generate platform-specific captions for Twitter/X, Facebook, LinkedIn, and Instagram. The AI ensures that each caption is tailored to the platform's audience, tone, and style, including hashtags and calls to action. Generate Images: The Image Instagram and Image Facebook e LinkedIn nodes use OpenAI to generate platform-specific images for Instagram, Facebook, and LinkedIn posts. Publish on Social Media: The workflow publishes the generated content and images on the respective platforms: - Publish on X: Posts the caption on Twitter/X. - Publish on LinkedIn: Posts the caption and image on LinkedIn. - Publish on Facebook: Posts the caption and image on Facebook. - Publish on Instagram: Posts the caption and image on Instagram. Update Google Sheets: The workflow updates the Google Sheet to mark the posts as published (e.g., "X OK," "Facebook OK," "LinkedIn OK," "Instagram OK"). 2. Set Up Steps To set up and use this workflow in n8n, follow these steps: Google Sheets Setup: Create (or clone) a Google Sheet with columns for POST ID, TEXT, TWITTER, FACEBOOK, INSTAGRAM, and LINKEDIN. Link the Google Sheet to the Google Sheets node by providing the Document ID and Sheet Name. WordPress Integration: Set up WordPress credentials in n8n for the Get Post node. Ensure the WordPress site is accessible via its REST API. AI Model Configuration: Configure the OpenRouter credentials in n8n for the Social Media Manager node. Ensure the AI model is set up to generate platform-specific captions. Image Generation: Set up OpenAI credentials for the Image Instagram and Image Facebook e LinkedIn nodes to generate images. Social Media API Integration: Set up credentials for each social media platform: - Twitter/X: Configure the Publish on X node with Twitter OAuth2 credentials. - LinkedIn: Configure the Publish on LinkedIn node with LinkedIn OAuth2 credentials. - Facebook: Configure the Publish on Facebook and Publish on Instagram nodes with Facebook Graph API credentials. Test the Workflow: Click the "Test workflow" button in n8n to trigger the workflow. The workflow will: - Fetch the WordPress post content. - Generate platform-specific captions and images. - Publish the posts on Twitter/X, Facebook, LinkedIn, and Instagram. - Update the Google Sheet to mark the posts as published. Optional Customization: Modify the workflow to include additional platforms or customize the AI-generated content further. Need help customizing? Contact me for consulting and support or add me on LinkedIn.

This workflow helps HR teams screen CVs with AI, store compatibility ratings in Google Sheets, and send email notifications to candidates and HR. It simplifies the recruitment process. CV Submission Form: Candidates submit their details and CV (PDF) through a web form, triggering the workflow in n8n. PDF Extraction & AI Rating: The submitted CV is processed to extract text, and AI analyzes it to generate a compatibility rating. Results Storage & Notifications: Ratings are stored in a Google Sheet for easy access and organization. Confirmation emails are automatically sent to both HR and the candidate. Setup Use the provided template to configure your form and connect it to n8n. Ensure your Google Sheets and email service integrations are active. Customization Instructions: Modify the email template to match your organization’s branding. Adjust the AI compatibility rating thresholds based on your requirements. Ensure you have updated the prompt for CV screening.