Workflow Templates

This workflow goes through the teachable webhook request types and adds a user, updates him and tags him with #unsubscribe or removes the #unsubscribe tag. It also tags the user with the tag of the name of the course. Enjoy!

🚀 AI-Powered Business Performance Reporting Automation Unlock executive-level insights with ZERO manual work! This n8n template empowers you to automate your entire monthly business performance reporting using dynamic SQL queries, AI-driven analysis, and beautiful HTML dashboards — all delivered directly to your inbox. 🎯 What This Automation Does 📆 Triggers automatically every month (5th of each month) 🧮 Fetches financial data from SQL (ERPNext or any database) 🔁 Loops over cost centers to analyze each business unit individually 📊 Generates Profit & Loss reports, WIP, Employee stats, and vertical breakdowns 🤖 Uses Google Gemini 2.5 AI to perform advanced financial analysis 💌 Delivers a polished HTML report to your email inbox 🔧 Fully modular – replace data source with Excel, Google Sheets, or APIs 🧑‍🏫 Step-by-Step Video Tutorial 🎥 Watch the full tutorial on YouTube: 📌 Learn how each node works and see the AI-generated report in action. 🌐 Useful Links 🔗 Sign up for n8n Cloud (recommended for non-tech users): 👉 https://n8n.syncbricks.com 📘 Download the step-by-step Guidebook (Free): 👉 https://lms.syncbricks.com/books/n8n 📚 Explore the full course on n8n (includes templates, workflows, and AI integrations): 👉 https://lms.syncbricks.com/courses/n8n 🛠 Requirements ✅ n8n (Self-hosted or Cloud) ✅ SQL Database (MySQL / PostgreSQL / ERPNext) ✅ Microsoft Outlook or Gmail (to send the report) ✅ Gemini API Key (for AI analysis) ✅ Basic understanding of your data schema 💡 Why Use This Template? ⏱ Saves 2-3 days of manual work every month 📈 Improves financial visibility across business units 🤝 Great for CFOs, COOs, Finance Analysts, and BI teams 🔄 Scales across multiple divisions and companies 🧠 Leverages AI for actionable insights and recommendations 🧩 Customize It Your Way Replace the SQL nodes with: Excel / Google Sheets Airtable / APIs Custom Applications Swap the AI model: OpenAI GPT Claude DeepSeek Adjust the report structure or HTML style 🙌 Get Started Now 🎯 Import the JSON template → Connect your data → Receive business insights via email. Don’t let manual reporting slow down your decision-making. 👉 Sign up for n8n Cloud 👉 Learn n8n with Amjid 👉 Download Guide Created by Amjid Ali | SyncBricks™ – Automation for Everyone

How it Works This workflow automates the handling of incoming emails, summarizes their content, generates appropriate responses using a retrieval-augmented generation (RAG) approach, and obtains approval or suggestions before sending replies. Below is an explanation of its functionality divided into two main sections: Email Handling and Summarization: The process begins with the Email Trigger (IMAP) node which listens for new emails in a specified inbox. Once an email is received, the Markdown node converts its HTML content into plain text if necessary, followed by the Email Summarization Chain that uses AI to create a concise summary of up to 100 words. Response Generation and Approval: A Write email node generates a professional response based on the summarized content, ensuring brevity and professionalism while keeping within the word limit. Before sending out any automated replies, the system sends these drafts via Gmail for human review and approval through the Gmail node configured with free-text response options. If approved, the finalized email is sent back to the original sender using the Send Email node; otherwise, it loops back for further edits or manual intervention. Additionally, there's a Text Classifier node designed to categorize feedback from humans as either "Approved" or "Declined", guiding whether the email should proceed directly to being sent or require additional editing. Set Up Steps To replicate this workflow within your own n8n environment, follow these essential configuration steps: Configuration: Begin by setting up an n8n instance either locally or via cloud services offered directly from their official site. Import the provided JSON configuration file into your workspace, making sure all required credentials such as IMAP, SMTP, OpenAI API keys, etc., are properly set up under Credentials since multiple nodes rely heavily on external integrations for functionalities like reading emails, generating summaries, crafting replies, and managing approvals. Customization: Adjust parameters according to specific business needs, including but not limited to adjusting the conditions used during conditional checks performed by nodes like Approve?. Modify the template messages given to AI models so they align closely with organizational tone & style preferences while maintaining professionalism expected in business communications. Ensure correct mappings between fields when appending data to external systems where records might need tracking post-interaction completion, such as Google Sheets or similar platforms.

What This Workflow Does: Generates original, research-based LinkedIn posts Combines AI insights with personal storytelling Includes human-in-the-loop selection & revision steps Automatically creates a conceptual image via DALL·E 3 Sends the final post and image via email, ready to publish Perfect For: Professionals who want to share high-quality AI-assisted content Content creators balancing consistency and authenticity Consultants and solopreneurs building a personal brand Anyone who wants to turn AI research into personal, sharable stories 📋 WORKFLOW PROCESS OVERVIEW Step 1: 🔍 Perplexity finds 3 recent, verifiable AI-related topics Step 2: 📧 Email sent – you choose your favorite topic Step 3: ✍️ OpenAI generates a LinkedIn post draft Step 4: 📨 You review the post and approve or suggest changes Step 5: 🛠️ If needed, AI revises the post based on your feedback Step 6: 🎨 DALL·E creates a conceptual image to match the content Step 7: 📬 Final email sent – post text + image ready to copy-paste on LinkedIn

> Reach out to me for any setup help/consulting. Automate the curation and sharing of trending GitHub discussions from Hacker News to Twitter and LinkedIn. This workflow leverages AI to generate engaging posts, streamlining your social media content creation and distribution. How it Works Crawl Hacker News for GitHub Posts: The workflow fetches trending GitHub-related discussions from Hacker News. Extract Key Information: Relevant data such as post titles, URLs, and metadata are extracted and filtered to focus only on unposted content. Fetch Additional Details: For each GitHub post, the workflow retrieves extra information from the GitHub repository page to enrich the post content. Generate Social Media Posts: Using AI, the workflow automatically generates tailored posts for Twitter and LinkedIn based on the collected data. Post to Twitter & LinkedIn: The generated content is posted to your Twitter and LinkedIn accounts. Track and Log Posts: Each post is logged in Airtable for tracking, and its status is updated to ensure no duplicate posts are made. Telegram Notification: After posting, a summary of the posts is sent to your Telegram chat for real-time updates. Requirements n8n Account**: Set up and configured. Sign up here. API Credentials**: Valid keys for LinkedIn, Twitter, Airtable, OpenAI, and Telegram. Airtable Base**: Configured with fields such as Title, URL, Post Content, Status, and Timestamp. Get started with Airtable. Telegram Chat ID**: For receiving real-time notifications. Set Up Steps Clone the Workflow: Import the workflow into your n8n environment using the provided JSON. Configure API Credentials: Enter your API keys for LinkedIn, Twitter, Airtable, OpenAI, and Telegram into the respective nodes. Set Up Airtable Base: Create an Airtable base with fields such as Title, URL, Post Content, Status, and Timestamp. Customize Telegram Chat ID: Modify the 'Ping me' node with your Telegram chat ID to receive notifications. Run the Workflow: Activate the workflow to start the automated content curation and posting process. Additional Resources n8n AI Agentic Workflows Guide n8n AI Workflow Tutorial n8n Community Tutorial on Building an AI-Powered Telegram Bot > Note: Chat GPT prompt should/can be tweaked in the step to give the desired behaviour. Sample Posts from my X and LinkedIn -**

🎯 Automatically Create and Post Engaging Clips (with Audience Retention Videos) from Podcasts Using AI! 🚀 Effortlessly transform long-form podcast content into highly engaging, viral-read clips with this end-to-end automation template. Designed for content creators already monetizing on TikTok/YouTube/Instagram/Twitter and those looking to start earning from the platform, this workflow streamlines the process of extracting highlights, editing clips, and posting to all your social media, allowing you to maximize reach while minimizing manual effort. Key Features 🔹 AI-Powered Podcast Highlight Extraction Automatically identifies the best moments from any podcast video, ensuring each clip is engaging and shareable. 🔹 Smart Video Editing & Captioning Combines podcast highlights with a copyright-free attention retainer video (e.g., Minecraft parkour, GTA 5 gameplay) for increased audience retention. Auto-generated captions make clips more dynamic and accessible. 🔹 Automated Title Generation A Large Language Model (LLM) analyzes the clips to generate compelling titles, optimized for TikTok/YouTube/Instagram/Twitter’s algorithm. 🔹 Hands-Free Multi Platform Posting Seamlessly schedules and automatically posts clips to your Soicual Media accounts at defined intervals, keeping your audience engaged without manual uploads. 🔹 Fully Automated Workflow From video download to content publishing 100% FREE, this template eliminates the need for time-consuming video editing, helping you scale your content strategy effortlessly, without having to pay for multiple subscriptions tediously. Simply find a podcast you like and a cool Minecraft parkour (or any engaging) video, send their YouTube URLs, and let the automation handle everything—from video downloading and audio processing to highlight extraction, editing, captions, and publishing. How It Works (Step-by-Step Guide) 1️⃣ Provide the YouTube URLs One for the main podcast video (where highlights will be extracted). One for the background attention retainer video (e.g., Minecraft parkour, GTA 5 gameplay). 2️⃣ Automation Downloads and Processes the Videos Downloads both videos. Extracts audio from the podcast for analysis. 3️⃣ AI Analyzes and Extracts Key Highlights Detects the most engaging moments from the podcast. 4️⃣ Creates Fully Edited Clips Merges podcast highlights with the attention retainer video. Generates captions automatically. 5️⃣ Optimizes for Social Media Uses AI to generate a compelling title for each clip. 6️⃣ Posts to your Social Media Channels Automatically Uploads clips at your preferred intervals with zero manual effort. Who Is This For? ✅ Content creators already making money on TikTok/YouTube/Instagram/Twitter ✅ People looking to start earning with TikTok/YouTube/Instagram/Twitter ✅ Podcasters wanting to repurpose content into bite-sized, viral clips Get Started Today! 🚀 This AI-driven automation is perfect for scaling your TikTok/YouTube/Instagram/Twitter content effortlessly. To use this workflow, you’ll just need free accounts on Assembly, Andynocode, and Upload-Posts.

This workflow allows you to receive updates when a customer is subscribed to a list in GetResponse and add them to a base in Airtable. GetResponse Trigger node: This node triggers the workflow when a customer is added to a list. Based on your use-case, you can select a different event. Set node: The Set node is uded here to ensure that only the data that we set in this node gets passed on to the next nodes in the workflow. For this workflow, we set the name and email of the customer. Airtable node: The data from the Set node is added to a table in Airtable. Based on your use-case, you may want to add the infromation about the customer to a CRM instead of a table in Airtable. Replace the Airtable node with the node of the CRM where you want to add the data.

Tags*: AI Agent, Supply Chain, Logistics, Route Planning, Transportation, GPS API Context Hi! I’m Samir — a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help companies improve their logistics operations using data, AI, and automation to reduce costs and minimize environmental footprint. > Let’s use n8n to automate order management for transportation companies! 📬 For business inquiries, you can add find me on LinkedIn Who is this template for? This workflow is designed for small transportation companies and carriers that handle their delivery request by email. Two AI Agent nodes and a connection to Openroute Service API are used to parse the content of pickup requests The results include driving time and driving distance in a comprehensive and concise reply generated by the second AI Agent. How does it work? This n8n workflow automates the processing of shipment request emails and enriches them with distance and driving time using the OpenRouteService API. 📥 Extract structured logistics data (pickup, delivery, contact) using an AI Agent 📌 Geocode pickup and delivery addresses into GPS coordinates 🚚 Query OpenRouteService using the truck (driving-hgv) profile 📏 Get the driving distance (in km) and estimated time (in minutes) 📤 Store all data in a connected Google Sheet 📧 Send back a professional confirmation email to the customer Steps: 📩 Trigger the workflow from a new Gmail message 🧠 Use the AI Agent to extract structured data from the email 📊 Record and enrich shipment details in a Google Sheet 🗺️ Geocode addresses into coordinates 🚦 Get driving distance & time via OpenRouteService 📬 Generate and send back a confirmation email using AI What do I need to get started? This workflow requires: A Gmail account to receive shipment requests A Google Sheet to log and update shipment info A free OpenRouteService API key 👉 Get one here OpenAI API access to use the AI Agent node Next Steps 🗒️ Follow the sticky notes inside the workflow canvas to: Plug your Gmail and Google credentials Add your OpenRouteService API key Test by sending a sample email and see the response! 🎥 Check the Tutorial This template was built using n8n v1.93.0 Submitted: June 5, 2025

Tags*: AI Agent, Supply Chain, Logistics, Circular Economy, Route Planning, Transportation, GPS API Context Hi! I’m Samir — a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help logistics teams reduce operational workload and errors by combining AI automation, route optimization APIs, and workflow automation. This workflow is part of a circular economy project, where stores return reusable packaging (bins, crates, containers) to a central warehouse. > Let's circular economies with AI-powered automation using n8n! 📬 For business inquiries, you can add find me on LinkedIn Who is this template for? This workflow is designed for logistics teams participating in circular economy loops. Let us imagine your transportation company receives this pickup request: The two AI Agent nodes connected to Openroute Service API will process the information and reply with the detailed route plan. The results include driving time and the optimal sequence of stops generated by the multi-stop optimization endpoint of the API. How does it work? This workflow automates the end-to-end processing of multi-stop pickup requests for reusable packaging: 📨 Gmail Trigger listens for collection request emails 🧠 AI Agent parses the email into structured data (store ID, address, date) 📍 Each stop is geocoded into GPS coordinates 🗺️ OpenRouteService optimizes the stop sequence using truck-specific routing 📄 A second AI Agent formats a confirmation email in HTML with the ordered pickup plan 📧 The reply is sent back with all details including duration and route Steps: 💌 Trigger on a new Gmail message 🧠 Extract data using AI Agent (e.g., stores, addresses, times) 📑 Store raw and processed data in Google Sheets 📍 Enrich with GPS coordinates 🚚 Optimize route using OpenRouteService (truck profile) 📄 Format the confirmation using an AI Agent 📬 Send reply to requester with route and timing What do I need to get started? You’ll need: A Gmail account to receive collection requests A Google Sheet to store and review data A free OpenRouteService API key Access to OpenAI for using AI Agent nodes Sample pickup request emails to test Next Steps 🗒️ Use the sticky notes inside the n8n canvas to: Plug in your Gmail and OpenRouteService credentials Try with a sample store collection email Validate the confirmation format and route accuracy This template was built using n8n v1.93.0 Submitted: June 7, 2025

This workflow is ideal for businesses looking to automate their email responses, especially for handling inquiries about company information. It leverages AI to ensure accurate and professional communication. How It Works Email Trigger: The workflow starts with the Email Trigger (IMAP) node, which monitors an email inbox for new messages. When a new email arrives, it triggers the workflow. Email Preprocessing: The Markdown node converts the email's HTML content into plain text for easier processing by the AI models. Email Summarization: The Email Summarization Chain node uses an AI model (DeepSeek R1) to generate a concise summary of the email. The summary is limited to 100 words and is written in Italian. Email Classification: The Email Classifier node categorizes the email into predefined categories (e.g., "Company info request"). If the email does not fit any category, it is classified as "other". Email Response Generation: The Write email node uses an AI model (OpenAI) to draft a professional response to the email. The response is based on the email content and is limited to 100 words. The Review email node uses another AI model (DeepSeek) to review and format the drafted response. It ensures the response is professional and formatted in HTML (e.g., using `, , , ` tags where necessary). Email Sending: The Send Email node sends the reviewed and formatted response back to the original sender. Vector Database Integration: The Qdrant Vector Store node retrieves relevant information from a vector database (Qdrant) to assist in generating accurate responses. This is particularly useful for emails classified as "Company info request". The Embeddings OpenAI node generates embeddings for the email content, which are used to query the vector database. Document Vectorization: The workflow includes steps to create and refresh a Qdrant collection (Create collection and Refresh collection nodes). Documents from Google Drive are downloaded (Get folder and Download Files nodes), processed into embeddings (Embeddings OpenAI1 node), and stored in the Qdrant vector store (Qdrant Vector Store1 node). Set Up Steps Configure Email Trigger: Set up the Email Trigger (IMAP) node with the appropriate IMAP credentials to monitor the email inbox. Set Up AI Models: Configure the DeepSeek R1, OpenAI, and DeepSeek nodes with the appropriate API credentials for text summarization, response generation, and review. Set Up Email Classification: Define the categories in the Email Classifier node (e.g., "Company info request", "Other"). Ensure the OpenAI 4-o-mini node is configured to assist in classification. Set Up Vector Database: Configure the Qdrant Vector Store and Qdrant Vector Store1 nodes with the appropriate Qdrant API credentials and collection details. Set up the Embeddings OpenAI and Embeddings OpenAI1 nodes to generate embeddings for the email content and documents. Set Up Document Processing: Configure the Get folder and Download Files nodes to access and download documents from Google Drive. Use the Token Splitter and Default Data Loader nodes to process and split the documents into manageable chunks for vectorization. Set Up Email Sending: Configure the Send Email node with the appropriate SMTP credentials to send responses. Test the Workflow: Trigger the workflow manually using the When clicking ‘Test workflow’ node to ensure all steps execute correctly. Verify that emails are summarized, classified, and responded to accurately. Activate the Workflow: Once tested, activate the workflow to automate the process of handling incoming emails. Key Features Automated Email Handling**: Automatically processes incoming emails, summarizes them, and generates professional responses. AI-Powered Classification**: Uses AI to classify emails into relevant categories for targeted responses. Vector Database Integration**: Retrieves relevant information from a vector database to enhance response accuracy. Document Vectorization**: Processes and stores documents from Google Drive in a vector database for quick retrieval. Professional Email Formatting**: Ensures responses are professionally formatted and concise. Need help customizing? Contact me for consulting and support or add me on Linkedin.

Extract data from any PDF or image invoice dropped in Google Drive directly into Google Sheets – powered by AI OCR. Free, fully modifiable n8n workflow. Optional add-ons for pro features. 🚀 What this template does Stop typing invoice data by hand. Drop a PDF or phone-snapshot into your Invoices Inbox folder in Google Drive and this n8n workflow will: Auto-OCR the document with the Mistral OCR API Match any fields you list in Row 1 of your Google Sheet (totally schema-agnostic) Append a clean, structured row – every time Works with both PDFs and images, in any language supported by Mistral. Template JSON included, ready to import into self-hosted or n8n Cloud 👀 Who’s this for? Freelancers & agencies processing client invoices Small finance teams on Google Workspace Anyone self-hosting n8n who wants an AI OCR flow without glue-code No coding skills required – but flow tweaking is possible for power users. 🛠 Upcoming PRO Add-Ons I am also working on PRO add-ons for this template: Add-On #1 – Error Handling & Alerts (ships Jul 2025)• Flags missing fields, branches to Email/Slack notification; prevents silent failures Add-On #2 – Auto-Currency Converter (ships Jul 2025)• Detects invoice currency symbol/code → converts Total into your base currency via a free FX API Add-On #3 – VAT / GST Breakdown (ships Jul 2025)• Extracts VAT number, net, tax rate, tax amount, gross – ready for EU/UK/AU filings To pre-order these please see: https://ysqander.gumroad.com/l/N8N-AI-Workflow-Invoice-Data-Extraction-LITE

What this workflow does This workflow retrieves Online Marketing data (Google Analytics for several domains, Google Ads, Meta Ads) from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account. This workflow has the following sequence: time trigger (e.g. every Monday at 7 a.m.) retrieval of Online Marketing data from the last 7 days (via sub workflows) assignment and summary of the data retrieval of Online Marketing data from the same time period of the previous year allocation and summary of the data preparation in tabular form and brief analysis by AI. sending the report as an email preparation in short form by AI for Telegram (optional) sending as Telegram message. Requirements The following accesses are required for the workflow: Google Analytics (via Google Analytics API): Documentation Google Ads (via HTTP Request -> Google Ads API):Documentation Meta Ads (via Facebook Graph API): Documentation AI API access (e.g. via OpenAI, Anthropic, Google or Ollama) SMTP access data (for sending the mail) Telegram access data (optional for sending as Telegram message): Documentation You must set up the individual sub-workflows as separate workflows. Then set the “Execute workflow trigger” here. Then select the corresponding sub-workflow in the AI Agent Tools. You can select the number of domains yourself. If the data queries are not required, simply delete the corresponding tool (e.g. “Analytics_Domain_5). Feel free to contact me via LinkedIn, if you have any questions!