by Don Jayamaha Jr
Meet your AI-powered crypto data analyst—fully integrated with CoinMarketCap APIs. This workflow acts as the supervisor agent for a multi-agent architecture built in n8n, connecting three powerful sub-agents to extract real-time insights from centralized and decentralized markets. It’s the ultimate tool for crypto traders, analysts, developers, and researchers who need strategic multi-source intelligence—all through Telegram. This workflow requires 3 sub-agent templates to function correctly. See below. 🔌 Required Sub-Workflows (Install First) CoinMarketCap Crypto Agent Tool → Token prices, metadata, conversions, listings CoinMarketCap Exchange & Community Agent Tool → Exchange info, token holdings, Fear & Greed index CoinMarketCap DEXScan Agent Tool → DEX trading pairs, liquidity, OHLCV data Download all from my Creator Profile: https://n8n.io/creators/don-the-gem-dealer/ What Makes This Workflow Special? This is not just another API wrapper—it’s an intelligent routing agent powered by GPT-4o-mini, capable of: Understanding complex user queries Choosing the appropriate tool workflow Structuring the API request Executing sub-workflows Formatting the output Returning insights via Telegram It connects three domains of market data: Cryptocurrencies (CEX)** Exchanges & Sentiment** DEX trading data** 🔍 What You Can Do 💰 Token Intelligence Get token metadata, price, volume, supply Compare rankings and conversions 🏦 Exchange Insights View assets held by exchanges Track the CMC 100 Index and Fear & Greed Score 🌐 DEX Market Analysis Analyze pair quotes, historical OHLCV, live trades Discover the top DEXs by volume across blockchains ✅ Example Questions to Ask “What’s the market cap of Ethereum today?” “Show liquidity and volume for SOL/USDT on Solana” “Get token holdings for Binance” “Compare BTC price on Uniswap vs Binance” “What’s the Fear & Greed index right now?” 🛠️ Setup Instructions Create Telegram Bot Use @BotFather to get your bot token. Get CoinMarketCap API Key Apply here: https://coinmarketcap.com/api/ Install Sub-Agent Templates Required: Crypto Agent Tool Exchange & Community Tool DEXScan Tool Configure Credentials in n8n Add both Telegram and CoinMarketCap keys as HTTP Header Auth. Deploy & Test Ask your Telegram bot: “Top 10 tokens by 24h volume” or “Convert 5 ETH to USD” Workflow Architecture AI Brain**: GPT-4o-mini Memory**: Windowed buffer memory via sessionId Tool Agents**: toolWorkflow() → routes requests to the appropriate sub-agent Executes real-time API queries and returns structured output Included Sticky Notes System Overview** Error Handling Guide (200, 400, 401, 429, 500)** Step-by-Step Usage Instructions** Prompt Examples + API Docs** Legal & Licensing Notes** Your crypto insights—smarter, faster, and all in one Telegram message.
by Don Jayamaha Jr
Access real-time cryptocurrency prices, market rankings, metadata, and global stats—powered by GPT-4o and CoinMarketCap! This modular AI-powered agent is part of a broader CoinMarketCap multi-agent system designed for crypto analysts, traders, and developers. It uses the CoinMarketCap API and intelligently routes queries to the correct tool using AI. This agent can be used standalone or triggered by a supervisor AI agent for multi-agent orchestration. Supported API Tools (6 Total) This agent intelligently selects from the following tools to answer your crypto-related questions: 🔍 Tool Summary Crypto Map – Lookup CoinMarketCap IDs and active coins Crypto Info – Get metadata, whitepapers, and social links Crypto Listings – Ranked coins by market cap CoinMarketCap Price – Live prices, volume, and supply Global Metrics – Total market cap, BTC dominance Price Conversion – Convert between crypto and fiat What You Can Do with This Agent 🔹 Get live prices and volume for tokens (e.g., BTC, ETH, SOL) 🔹 Convert crypto → fiat or fiat → crypto instantly 🔹 Retrieve whitepapers, logos, and website links for any token 🔹 Analyze total market cap, BTC dominance, and circulating supply 🔹 Discover new tokens and track their CoinMarketCap IDs 🔹 View the top 100 coins ranked by market cap or volume Example Queries ✅ "What is the CoinMarketCap ID for PEPE?" ✅ "Show me the top 10 cryptocurrencies by market cap." ✅ "Convert 5 ETH to USD." ✅ "What’s the 24h volume for ADA?" ✅ "Get the global market cap and BTC dominance." AI Architecture AI Brain**: GPT-4o-mini Memory**: Session buffer with sessionId Agent Type**: Subworkflow AI tool Connected APIs**: 6 CoinMarketCap endpoints Trigger Mode**: Executes when called by a supervisor (via message and sessionId inputs) Setup Instructions Get a CoinMarketCap API Key Register here: https://coinmarketcap.com/api/ Configure Credentials in n8n Use HTTP Header Auth with your API key for each connected endpoint Connect This Agent to a Supervisor Workflow (Optional) Trigger this agent using Execute Workflow with inputs message and sessionId Test Prompts Try asking: “Convert 1000 DOGE to BTC” or “Top 5 coins in EUR” Included Sticky Notes Crypto Agent Guide – Agent overview, node map, and endpoint details Usage Instructions – Step-by-step usage and sample prompts Error Handling & Licensing – Troubleshooting and IP rights ✅ Final Notes This agent is part of the CoinMarketCap AI Analyst System, which includes multiple specialized agents for cryptocurrencies, exchanges, community data, and DEX insights. Visit my Creator profile to find the full suite of tools. Get smarter about crypto—analyze the market in real time with AI and CoinMarketCap.
by Don Jayamaha Jr
Gain full visibility into decentralized exchanges using CoinMarketCap’s DEXScan API—powered by AI. This workflow is part of the CoinMarketCap AI Analyst system and delivers real-time and historical insights on spot trading pairs, DEX liquidity, trading activity, and OHLCV data across chains like Ethereum, Polygon, Solana, and more. Use this workflow as a sub-agent triggered by a parent supervisor workflow, or run it manually with inputs sessionId and message. 🔧 Supported Tools (8 Total) DEX Metadata → Static info (name, launch date, logo, URLs) DEX Networks List → All supported DEX chains + network metadata DEX Listings Quotes → Ranked list of DEXs with live trading volume, market share DEX Pair Quotes (Latest) → Real-time liquidity, price, and buy/sell stats DEX OHLCV Historical → Time-series data (daily/hourly/1m) DEX OHLCV Latest → Today’s price, volume, open/close for pairs DEX Trades Latest → Up to 100 recent trades for any DEX pair DEX Spot Pairs Latest → Active token pairs across DEXs + filters (volume, liquidity, volatility) Agent Architecture AI Model**: gpt-4o-mini Context Memory**: Window buffer using sessionId Trigger Input**: message, sessionId Execution**: Via Execute Workflow or parent AI supervisor Design**: Tool-based LangChain agent with CMC DEXScan endpoints 💡 Use Cases 🔹 Find top DEXs by 24h volume 🔹 Get spot pairs with highest liquidity on a specific network 🔹 Track historical OHLCV for Uniswap pairs 🔹 View latest trades for SOL/USDC pool 🔹 Analyze tax, pooled % and holders for specific pairs 🔹 Filter pairs by 24h volume, percent change, liquidity, or number of transactions ✅ Example Queries ✅ "Top 5 DEXs by 24h volume on Ethereum" ✅ "Get historical OHLCV for SOL-USDC on Solana" ✅ "Latest trades for a PancakeSwap pair" ✅ "Show all spot pairs with over $500K in liquidity on Polygon" ✅ "Retrieve metadata for Uniswap and SushiSwap" 🛠️ Setup Instructions Get a CoinMarketCap API Key Sign up at: https://coinmarketcap.com/api/ Add API Key to Credentials in n8n Use HTTP Header Auth method Trigger from Parent Workflow (Optional) Use Execute Workflow and pass message and sessionId Test Prompt Ideas Try: "Compare liquidity of Uniswap and Curve pairs on Ethereum" Sticky Notes Included DEXScan Agent Guide – Workflow architecture + supported tools Usage & API Call Examples – Prompts, test inputs, setup flow Error Codes + Licensing – 400/401/429/500 troubleshooting, IP rights ✅ Final Notes This agent is part of the CoinMarketCap AI Analyst System, which includes multiple specialized agents for cryptocurrencies, exchanges, and community data. Visit my Creator profile to find the full suite of tools. Master DEX analytics with AI—get powerful liquidity, trading, and pair insights in seconds.
by irfan saeed
Auto-Generate YouTube Chapters with AI-Powered Transcript Analysis Overview This workflow uses YouTube Data API v3 and Google Gemini 1.5 Flash AI to automatically generate timestamped chapters for videos by analyzing SRT captions. It enhances viewer navigation, improves SEO , and saves creators time by automating manual tasks. Prerequisites YouTube API Setup Create a Google Cloud Project Go to the Google Cloud Console. Click Select a project > New Project and name it (e.g., "YouTube Chapters Automation") . Enable YouTube Data API v3 Navigate to APIs & Services > Library. Search for "YouTube Data API v3" and click Enable . Configure OAuth Consent Screen Go to APIs & Services > OAuth consent screen. Select External (public) or Internal (testing), then add required details (app name, support email) . Generate OAuth 2.0 Credentials Under Credentials, click Create Credentials > OAuth client ID. Choose Web app, then download the JSON key file . Add Credentials to n8n Other Requirements Google Gemini API**: Configure access for the gemini-1.5-flash-8b-exp-0924 model by getting the api key. Workflow Steps Set Video ID Input the target video ID (e.g., r1wqsrW2vmE) using the Set Video ID node. Fetch Video Metadata Use the YouTube API node to retrieve the video’s title, category, and existing description . Download SRT Captions Get Caption ID: Call https://www.googleapis.com/youtube/v3/captions to fetch the caption track ID . Download Transcript: Use the ID to retrieve SRT data via https://www.googleapis.com/youtube/v3/captions/{{ID}}?tfmt=srt . Analyze Transcript with Gemini AI Process the SRT file with Google Gemini AI to identify chapters using a prompt like: "Classify this transcript into timestamped chapters (e.g., 00:00 - Introduction)." Validate output with a structured parser (e.g., Structured Captions node) . Update Video Description Append chapters to the description using the YouTube API’s videos.update method . Value Proposition Viewer Experience**: Chapters improve navigation and reduce drop-off rates . SEO Benefits**: Structured descriptions enhance search visibility . Time Savings**: Eliminates manual chapter creation .
by Jimleuk
This n8n template demonstrates how easy it is to build an Outlook Calendar Assistant powered by an AI agent equipped with Tools. For teams using Outlook Calendar and Slack who need easier calendar management, this workflow can be a great first step to introducing powerful AI tools into your daily activities. How it works A Slack Trigger node is configured to catch "bot mentions" events in a designated channel. The message is parsed using the Edit fields node to extract only the required attributes of the event. An AI Agent equipped with Outlook Calendar Tools enables question and answer capability for the organisation's shared calendars and events. The AI agent's response is sent back to Slack as a reply to the user's query. How to use The workflow is triggered via @mention-ing the bot followed by the query. eg. "@bot how many meetings does Paul have to attend to this week?" To start listening to real mentions, you must activate the workflow and set it to production mode. You must use the production webhook URL for the event subscription. Some sample queries to try "What's included in the product team's sprint demo this week?" "Who's booked room 7 for this Thursday?" "When is Jim & Nik's sales meeting with Microsoft?" Requirements Slack for Chat and Trigger. To get connected to Slack, see the official n8n docs for Slack Credentials. Outlook for Agent Tools To get connected to Outlook, see the official n8n docs for Outlook Credentials. Customising this workflow Not using Slack? This template can be modified to work with Teams but requires a little more configuration. Agents can have any number of tools but an overloaded agent is prone to confusion! If this happens, try splitting into multiple agents serving separate needs.
by Sagar
This template streamlines your Instagram content posting workflow by connecting Google Drive for image storage, using OpenAI for AI-generated captions, and leveraging Facebook Graph API for automated publishing. Pre-requisites Before setting up this workflow, ensure you have: A Google account with access to Google Drive An OpenAI API key for AI caption generation A Facebook Developer account with Instagram Graph API access An Instagram Business or Creator account connected to a Facebook Page n8n.io account with workflow access Setup Instructions Configure Data Source Create a Google Sheet with the following columns: Name: Filename of your image in Google Drive Caption: Optional custom caption (leave empty for AI-generated captions) URL: your Video Reel or Image in Google Drive Connect Google Drive Add your Google Drive credentials in the "Google Drive" node Specify the folder path where your Instagram image/Video are stored Configure the node to retrieve image files based on filenames from your Google Sheet Set Up OpenAI Integration Add your OpenAI API key to the credentials Configure the OpenAI node to generate engaging captions based on image content Adjust temperature and model parameters for desired creativity level Configure Facebook Graph API Connect your Facebook account with Instagram access Set up the Facebook Graph API node to post to your Instagram Business/Creator account Ensure proper image formatting (1:1, 4:5, or 16:9 aspect ratios supported by Instagram) Workflow Automation Setup Configure the scheduler node to run at your preferred frequency Set up error handling to notify you of any posting failures Add conditional nodes to use either custom or AI-generated captions Execution Instructions After completing all connections, test the workflow with a single image Monitor the execution in the n8n dashboard to ensure proper functioning View the "Executions" tab to track successful posts and troubleshoot any errors Adjust posting frequency and scheduling as needed This template saves hours of manual Instagram posting work while maintaining an authentic presence. Perfect for social media managers, content creators, and businesses looking to maintain consistent Instagram activity without the daily manual effort. The workflow handles image retrieval, caption generation or customization, proper Instagram API formatting, scheduled posting, and execution tracking - all in one automated solution.
by Łukasz
Who is it for? If you are getting a lot of emails into your Gmail inbox, then probably some of those can be solved easly by replying or by doing specific short tasks. But analyzing whole email thread content just to catch up with multiple threads can be very wasteful. So by using AI you can actually get simple propositions of what should be done before closing this specific email and actual proposed answer to that email. This is especially useful if you need to do some actions before replying to email. In that case you can simply assign task to specific person, await until it's done, copy-paste AI answer when it's done, and close. Another good use would be if on one inbox there are working multiple people. It can make the process much more streamlined. How It Works? Script runs on your selected trigger. If you are using section "Read and Star", then you may use "Email Trigger". Automation is looking for exiting open Todoist tasks, that have the same title as email If task does not exist, then we are asking AI to analyze thread and give output that is Todoist-API-ready: having summary of email content having proposed actions to be taken having proposed answer to this email If email was unstarred for some reason but task was not closed, then task is being closed automatically. Script FOR PURPOSE is not trying to unstar messagess which have closed tasks, because this could lead to some inconsistencies. How to set up? Select and setup your triggers, depending on your needs Setup connections using N8N instructions. You will need: Gmail Todoist AI (in this workflow OpenAI is used) (Optional) Remove "Read and Star" section if you don't want tasks automatically read and starred. (Optional) Adjust AI node - especially useful if you want to use different model or have response in different language NOTE Chat does not heave memory attached on purpose. The purpose is that it should analyze each inbox message separately, not in thread. When using memory, it can get lost easily. NOTE2 You might want to adjust limits on nodes "Get Unread From Inbox", "Get Starred From Inbox" and "Get Open Tasks", especially if having issues with model complying to output structure. And that's it. I hope that this automation will make your Gmail <-> Todoist process much more streamlined! What's More? There is actually more that you could do with this automation, but it really depends on your needs. For example, you could add Form trigger to handle incoming support requests. Another thing is that you could replace Todoist with Asana or any database (like NocoDB) if you are using it for your task management.
by Ranjan Dailata
Who this is for? This workflow is designed for professionals and teams who need real-time, structured insights from Google Search results without manual effort. What problem is this workflow solving? This n8n workflow solves the problem of automating Google Search result extraction, cleanup, summarization, and AI-enhanced formatting for downstream use like sending the results to a webhook or another system. What this workflow does Automates Google Search via Bright Data Uses Bright Data’s proxy-based SERP API to run a Google Search query programmatically. Makes the process repeatable and scriptable with different search terms and regions/zones. Cleans and Extracts Useful Content The Google Search Data Extractor uses LLM based cleaning to remove HTML/CSS/JS from the response and extract pure text data. Converts messy, unstructured web content into structured, machine-readable format. Summarizes Search Results Through the Gemini Flash + Summarization Chain, it generates a concise summary of the search results. Ideal for users who don’t have time to read full pages of search results. Formats Data Using AI Agent The AI Agent acts like a virtual assistant that: Understands search results Formats them in a readable, JSON-compatible form Prepares them for webhook delivery Delivers Results to Webhook Sends the final summary + structured search result to a webhook (could be your app, a Slack bot, Google Sheets, or CRM). Setup Sign up at Bright Data. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. A Google Gemini API key (or access through Vertex AI or proxy). Update the Google Search query as you wish by navigating to the Set Google Search Query node. Update the Webhook HTTP Request node with the Webhook endpoint of your choice. How to customize This Workflow to your needs 1. Change the Search Input Default: It searches a fixed query or dataset. Customize: Accept input from a Google Sheet, Airtable, or a form. Auto-trigger searches based on keywords or schedules. 2. Customize Summarization Style (LLM Output) Default: General summary using Google Gemini or OpenAI. Customize: Add tone: formal, casual, technical, executive-summary, etc. Focus on specific sections: pricing, competitors, FAQs, etc. Translate the summaries into multiple languages. Add bullet points, pros/cons, or insight tags. 3.Choose Where the Results Go Options: Email, Slack, Notion, Airtable, Google Docs, or a dashboard. Auto-create content drafts for WordPress or newsletters. Feed into CRM notes or attach to Salesforce leads.
by Ranjan Dailata
Who this is for? This workflow automates the process of Wikipedia data extraction using the Bright Data Web Unlocker, parsing and cleaning the data, and then sending the results to a specified webhook URL for downstream processing, reporting, or integration. What problem is this workflow solving? Researchers who need structured information from Wikipedia pages regularly. Data Engineers building knowledge bases or enriching datasets with factual data. Digital Marketers or Content Writers automating fact-checking or content sourcing. Automation Enthusiasts who want to trigger external systems with rich context from Wikipedia. What this workflow does This workflow addresses the challenges of manually retrieving, structuring, and using data from Wikipedia at scale. Workflow Breakdown Trigger Type: Scheduled or Manual Purpose: Starts the workflow either on a fixed schedule (e.g., daily) or on-demand via a manual trigger or incoming webhook. Bright Data Wikipedia Scraping Tool Used: Bright Data Web Unlocker Action: Scrape the HTML content of one or multiple Wikipedia article URLs. Parse & Extract Structured Data The Basic LLM Chain node is responsible for producing a human readable content. Summarization Summarize the Wikipedia content by utilizing the Summarization Chain node. Send to Webhook Initiates a Webhook notification to the specified URL as part of the "Summary Webhook Notifier" node. Setup Sign up at Bright Data. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. In n8n, configure the Google Gemini(PaLM) Api account with the Google Gemini API key (or access through Vertex AI or proxy). Update the Set Wikipedia URL with Bright Data Zone node with the Wikipedia URL and Bright Data Zone. Update the Summary Webhook Notifier node with the Webhook endpoint of your choice. How to customize this workflow to your needs Update Wikipedia URL Replace with your own Wikipedia URL of your interest. Make sure to set the Wikipedia URL as part of the "Set Wikipedia URL with Bright Data Zone" node. Modify Data Extraction Logic Extract entire article content or just specific sections by extending the "LLM Data Extractor" node prompt. Extend AI Summarization Extract key bullet points or entities. Create short-form summaries by extending the "Concise Summary Generator" node. Extend Summary Webhook Notifier Send to Slack, Discord, Telegram, MS Teams via the Webhook notification mechanism. Connect to your internal database/API via the Webhook notification mechanism.
by merfy
Use Case Manually extracting images from PDF files for analysis is often slow and inefficient. Many users resort to taking screenshots of each page, uploading them to an AI tool like OpenAI for image analysis, and then manually copying the insights into a document. This manual process is time-consuming and prone to errors. This workflow streamlines the entire process by automatically extracting images from a PDF, analyzing them using the GPT-4o model, and saving the results in seconds—eliminating the need for manual effort. What This Workflow Does Extracts all images from the uploaded PDF file automatically The workflow scans each page of the PDF and identifies embedded images without manual intervention. Uses the GPT-4o model to analyze each extracted image Each image is processed through GPT-4o to generate descriptive insights, summaries, or context-specific analysis depending on the use case. Saves the analysis results to a .txt file, including image URLs The final output is a plain text file containing both the image URLs (e.g., hosted on cloud storage) and the corresponding GPT-4o analysis, ready for further use or sharing. Setup 1.Set up your credentials when you first open the workflow. You’ll need accounts for OpenAI, Convert API, and Google Drive. 2.Convert API does not rate-limit your API, sometimes you may receive 503 service unavailable error. Nevertheless, it doesn’t mean that you cannot convert your file. It simply means that you should retry the conversion in a few seconds. 3.Upload a PDF with images to Google Drive. 4.Remove unnecessary parts and retrieve image-related information. 5.Integrate image and image analysis information together. 6.Analyze each image using the OPENAI GPT-4o model. 7.Retrieve all image analysis content and image URL 8.Integrate multiple image URLs and analysis content 9.Output content to a .txt file. Template was created in n8n v1.83.2 How to Customize Replace the manual trigger with a Google Drive trigger or other automation triggers Change the image analysis model (e.g., switch or fine-tune GPT-4o) Send the results to other platforms (e.g., Slack, Telegram, LINE, etc.) instead of saving to a .txt file
by GuanNan
Who is this for? This template is designed for anyone who wants to integrate MCP with their AI Agents. Whether you're a developer, a data analyst, or an automation enthusiast, if you're looking to leverage the power of MCP and Google Calendar in your n8n workflows, this template is for you. What problem is this workflow solving? This template caters to MCP beginners seeking a hands - on example and developers looking to integrate Google Calendar MCP service. When integrating MCP with Google Calendar, manually updating AI Agents after changes to Google Calendar tools on the MCP Server is time - consuming and error - prone. This template automates the process, enabling the AI Agent to instantly recognize changes made to Google Calendar on the MCP Server. In project management, for example, it ensures that task schedule updates in Google Calendar are automatically detected by the AI Agent. With detailed steps, it simplifies the integration process for all users. What this workflow does This workflow focuses on integrating MCP with Google Calendar within n8n. Specifically, it allows you to build an MCP Server and Client using Google Calendar nodes in n8n. Any changes made to the Google Calendar tools on the MCP Server are automatically recognized by the MCP Client in the workflow. This means that you can make changes to your Google Calendar (such as adding, deleting, or modifying events) on the MCP Server, and the MCP Client in the n8n workflow will immediately detect these changes without any manual intervention. Setup Requirements An active n8n account. Access to Google Calendar API. You need to enable the Google Calendar API, and create the necessary credentials (OAuth 2.0 client ID). Basic knowledge of n8n workflows and MCP concepts. Step - by - step guide Create a new workflow in n8n: Log in to your n8n account and create a new workflow. Add Google Calendar nodes: Search for and add the Google Calendar nodes to your workflow. Configure the nodes with your Google Calendar API credentials. Set up the MCP Server and Client: Use the appropriate nodes in n8n to set up the MCP Server and Client. Connect the Google Calendar nodes to the MCP nodes as required. Test the workflow: Make some changes to your Google Calendar on the MCP Server and check if the MCP Client in the n8n workflow can detect these changes. How to customize this workflow to your needs If you want to customize this workflow, you can: Modify the triggers**: You can change the conditions under which the MCP Client detects changes. For example, you can set it to detect only specific types of events in Google Calendar. Integrate with other services**: You can add more nodes to the workflow to integrate with other services, such as sending notifications to Slack or saving data to a database when a change is detected.
by Jimleuk
This n8n template imports purchase order submissions from Outlook and converts attached purchase order forms in XLSX format into structured output. Data entry jobs with user-submitted XLSX forms are time consuming, incredibly mundane but necessary tasks which in likelihood are inherited and critical to business operation. While we could dream of system overhauls and modernisation, the fact is that change is hard. There is another way however - using n8n and AI! N8N offers an end-to-end solution to parse XLSX form attachments using LLM-powered OCR and send the extracted output to your ERP or otherwise. How it works An Outlook trigger is used to watch for incoming purchase order forms submitted via a shared inbox. The email attachment for the submission is a form in xlsx format - like this one Purchase Order Example - which is imported into the workflow. The 'Extract from File' node is used with the 'code' node to convert the xlsx file to markdown. This is so our LLM can understand it. The Information Extractor node is used to read and extract the relevant purchase order details and line items from the form. A simple validation step is used to check for common errors such as missing PO number or the amounts not matching up. A notification is automated to reply to the buyer if so. Once validation passes, a confirmation is sent to the buyer and the purchase order structured output can be sent along to internal systems. How to use This template only works if you're expecting and receiving forms in XLSX format. These can be invoices, request forms as well as purchase order forms. Update the Outlook nodes with your email or other emails as required. What's next? I've omitted the last steps to send to an ERP or accounting system as this is dependent on your org. Requirements Outlook for Emails Check out how to setup credentials here: https://docs.n8n.io/integrations/builtin/credentials/microsoft OpenAI for LLM document understanding and extraction. Customising the workflow This template should work for other Excel files. Some will be more complicated than others so experiment with different parsers and extraction tools and strategies. Customise the Information Extractor Schema to pull out the specific data you need. For example, capture any notes or comments given by the buyer.