30 templates found
Category:
Author:
Sort:

AI powered web scraping with Jina, Google Sheets and OpenAI : the EASY way

Purpose of workflow: The purpose of this workflow is to automate scraping of a website, transforming it into a structured format, and loading it directly into a Google Sheets spreadsheet. How it works: Web Scraping: Uses the Jina AI service to scrape website data and convert it into LLM-friendly text. Information Extraction: Employs an AI node to extract specific book details (title, price, availability, image URL, product URL) from the scraped data. Data Splitting: Splits the extracted information into individual book entries. Google Sheets Integration: Automatically populates a Google Sheets spreadsheet with the structured book data. Step by step setup: Set up Jina AI service: Sign up for a Jina AI account and obtain an API key. Configure the HTTP Request node: Enter the Jina AI URL with the target website. Add the API key to the request headers for authentication. Set up the Information Extractor node: Use Claude AI to generate a JSON schema for data extraction. Upload a screenshot of the target website to Claude AI. Ask Claude AI to suggest a JSON schema for extracting required information. Copy the generated schema into the Information Extractor node. Configure the Split node: Set it up to separate the extracted data into individual book entries. Set up the Google Sheets node: Create a Google Sheets spreadsheet with columns for title, price, availability, image URL, and product URL. Configure the node to map the extracted data to the appropriate columns.

Derek CheungBy Derek Cheung
50430

Auto-generate WhatsApp proposals from voice or text using GPT & APITemplate

How it works • Transcribes a WhatsApp voice or text message from a prospect using Whisper or GPT • Extracts key information (name, need, context, urgency) via AI • Matches the most relevant service pack by comparing the prospect’s need with Airtable data • Dynamically fills a branded template via APITEMPLATE (HTML or PDF) • Generates a clean, personalized business proposal — including dynamic links (payment, calendar, etc.) • Sends the final PDF back instantly via WhatsApp or email Set up steps • ⏱ Estimated setup time: 45–60 minutes • ✅ You’ll need:  ◦ WhatsApp Business Cloud API access (with webhook configured)  ◦ OpenAI API key (Whisper + GPT)  ◦ Airtable (to store service packs and client input)  ◦ APITEMPLATE account (template with placeholders like {{nom}}, {{prix}}, {{lien_reservation}}, etc.)  ◦ n8n instance (cloud or self-hosted) • 📦 Create your service packs in Airtable with associated links (Stripe, Calendly…) • 🔗 The proposal auto-includes these links dynamically inside the PDF • 🚀 Workflow orchestrates the end-to-end process: from WhatsApp input to PDF delivery

Floyd MahouBy Floyd Mahou
6927

Microsoft Outlook AI email assistant with contact support from Monday and Airtable

Microsoft Outlook AI Email Assistant Prerequisites Microsoft 365 Login Credentials Provide your Office 365 credentials to connect Outlook. Monday.com Generate an API token and have a board with your contact details. Airtable Obtain an API key (or personal access token) and set up a base to store: Contacts (populated by the Monday.com sync). Rules & Categories (used by the AI Email Assistant). Use this Airtable base as the template: Airtable AI Email Assistant Template. Define your own rules, categories, and delete rules. OpenAI API Key Sign up for OpenAI if you don’t already have an account. Generate a new API key at OpenAI API Keys. --- What the System Does Daily Contact Sync (Monday.com → Airtable) Runs once a day to pull the latest contacts from Monday.com and store or update them in Airtable. AI Email Categorisation & Prioritisation Fetches Outlook emails with filters. Cleans and processes email content. Matches emails with known contacts from Airtable. Uses an AI agent to classify, categorise, and prioritise emails. Updates Outlook categories and importance based on AI results. Runs in parallel with Airtable rules & categories retrieval for real-time decision-making. --- Workflow 1: Daily Contact Sync (Monday.com → Airtable) Purpose Keep Airtable’s Contacts table up to date by pulling new or updated contact data from Monday.com daily. Steps Schedule Trigger Runs at a set interval (daily) to initiate contact syncing. Monday.com: Get Contacts Reads the specified board/columns from Monday.com where you store contact details. Airtable - Contacts Upserts (adds or updates) the fetched Monday.com data into Airtable’s Contacts table. Ensures daily updates reflect changes from Monday.com. Result A consolidated contact list in Airtable, ready for AI email categorisation. --- Workflow 2: Categorise & Prioritise Outlook Emails Purpose Fetches Outlook emails, cleans and processes their content, matches senders with known contacts, and uses AI to categorise and prioritise them. Steps Get Outlook Emails with Filters Trigger: Either scheduled (Check Mail Schedule Trigger) or manual (Test Workflow). Outlook Filters: Not flagged (flag/flagStatus == 'notFlagged'). Not categorised (not categories/any()). 🔹 Result: A batch of fresh, unprocessed emails ready for processing. --- Sanitise Email Convert to Markdown: Strips HTML tags and normalises formatting. Email Messages Processing: Allows manual removal of signatures, disclaimers, or extra content. 🔹 Result: A clean, AI-friendly email for categorisation. --- Match Contact Loop Over Emails: Iterates over each email. Contact Lookup: Checks Airtable’s Contacts table (updated daily). Merge Data: Enriches emails with known client, supplier, or internal team info. 🔹 Result: Enhanced email context for AI processing. --- AI Agent to Categorise & Prioritise Retrieve Rules & Categories Reads Rules, Categories, and Delete Rules from Airtable in parallel. AI: Analyse Email (Tools Agent) Uses email text, sender info, and rules to build a structured AI prompt. OpenAI Chat Model Processes the AI prompt and outputs: Category Subcategory (optional) Priority level Short rationale Structured Output Parser Ensures AI response is valid JSON format. 🔹 Result: Each email is labelled, categorised, and prioritised with AI-driven logic. --- Set Outlook Category & Importance Set Category: Updates Outlook with the assigned category. Check Priority Conditions (If Node): If Action Required or from a VIP, mark as High Priority. Set Importance: Updates the email's importance flag in Outlook. 🔹 Result: Outlook is updated with categories & importance based on AI recommendations. --- Parallel Processing: Retrieve Rules & Categories Runs alongside the email categorisation workflow. Ensures Airtable-based rules are available before AI processing. Steps Airtable: Get Rules & Categories Fetches Rules, Categories, and Delete Rules from Airtable. Delete Rules (Optional) If a delete rule matches, the email is removed. 🔹 Result: A dynamic, updatable rule system ensuring emails are handled properly. --- Final Outcome Daily Contact Sync keeps contacts up to date. AI-driven email workflow ensures smart categorisation. Outlook automatically updated with AI-generated categories and importance. --- This automated system saves time, ensures efficient inbox management, and allows for customisable rules via Airtable.

Cognitive CreatorsBy Cognitive Creators
6914

AI-powered YouTube shorts automation: Create & publish with OpenAI & ElevenLabs

👥 Who is this for? Digital marketers, content creators, social media managers, and businesses who want to use AI marketing automation for YouTube Shorts without spending hours on production. This AI workflow helps anyone looking to create more short-form video marketing content without needing fancy editing skills or tons of time. It's perfect for marketing teams who want to automate content creation while keeping their brand's voice and boosting audience engagement through artificial intelligence technology. 🔍 What problem does this workflow solve? Let's be honest - creating high-performing YouTube Shorts consistently takes way too much work. You need AI script generation, voiceover production, video editing, and a solid content marketing strategy to keep your channel growing. Our intelligent automation workflow turns this whole headache into a simple two-click process, while still giving you videos that look and sound professional. This AI solution tackles the real marketing challenge of scaling short-form video production without sacrificing quality or burning through your team's resources. ⚙️ What this workflow does This all-in-one AI marketing automation solution handles your entire YouTube Shorts creation process through five easy steps: 🧠 Smart Idea Generation: Advanced AI creates engaging video concepts, SEO-optimized titles, and descriptions that work with YouTube's algorithm and improve content marketing performance 🎤 Natural Voice Creation: Makes professional-sounding voiceovers using ElevenLabs' artificial intelligence technology, no recording equipment needed 🖼️ Automatic Visual Creation: Uses cutting-edge AI models to make custom images and animated clips that match your video marketing style and brand identity 🎬 Smart Video Editing: AI-powered editing automatically combines all elements with smooth transitions for maximum viewer retention and marketing impact 📱 Easy Content Distribution: Automates the YouTube publishing process with proper metadata to maximize your marketing reach and content discovery The whole marketing automation system runs through Telegram with just two human checkpoints - approving the initial AI idea and giving the final video a thumbs-up. This makes YouTube marketing automation so much easier while letting you keep control over the AI-generated content that gets published. 🛠️ Setup (About 10-15 minutes) Before using this AI marketing automation tool, you'll need: n8n installation (cloud or self-hosted) Telegram account (to interact with your workflow) OpenAI API Key (for AI content generation) ElevenLabs API Key (for AI voice creation) Replicate API Key (for AI video generation) Cloudinary account (for media asset storage) Creatomate API Key (for automated video assembly) 0CodeKit API Key (for script processing automation) YouTube channel with API access (for content publishing) Just add your API keys to the "Set API Keys" node, connect your Telegram bot, and you're ready to start your automated marketing content creation. We've included a step-by-step video walkthrough in the workflow to make setup super easy for your AI marketing system. 🔧 How to customize this workflow to your needs This AI marketing workflow offers tons of flexibility to fit your specific content strategy: Voice Options: Pick from different AI voices to match your brand's tone and what your audience prefers in marketing content Visual Styles: Choose from over 40 different AI image models to get the perfect visual marketing approach Video Effects: Try various artificial intelligence video models for different animation styles that make your content marketing more engaging Content Tweaking: Adjust the AI prompts to perfectly align with your brand voice and content marketing strategy YouTube Settings: Easily optimize category selection and metadata for better audience targeting with your automated marketing content Every part of the AI automation workflow comes with easy-to-follow instructions in color-coded notes, so even if you're new to marketing automation tools, you can still customize everything to fit your needs. Transform your YouTube Shorts marketing strategy with this complete AI automation solution that brings together multiple artificial intelligence technologies to help you create consistent, high-quality short-form video content that drives engagement and scales your digital marketing efforts without the usual production headaches.

Jonas BuschBy Jonas Busch
6879

Adaptive RAG with Google Gemini & Qdrant: context-aware query answering

Description This workflow automatically classifies user queries and retrieves the most relevant information based on the query type. 🌟 It uses adaptive strategies like; Factual, Analytical, Opinion, and Contextual to deliver more precise and meaningful responses by leveraging n8n's flexibility. Integrated with Qdrant vector store and Google Gemini, it processes each query faster and more effectively. 🚀 How It Works? Query Reception: A user query is triggered (e.g., through a chatbot interface). 💬 Classification: The query is classified into one of four categories: Factual: Queries seeking verifiable information. Analytical: Queries that require in-depth analysis or explanation. Opinion: Queries looking for different perspectives or subjective viewpoints. Contextual: Queries specific to the user or certain contextual conditions. Adaptive Strategy Application: Based on classification, the query is restructured using the relevant strategy for better results. Response Generation: The most relevant documents and context are used to generate a tailored response. 🎯 Set Up Steps Estimated Time: ⏳ 10-15 minutes Prerequisites: You need an n8n account and a Qdrant vector store connection. Steps: Import the n8n workflow: Load the workflow into your n8n instance. Connect Google Gemini and Qdrant: Link these tools for query processing and data retrieval. Connect the Trigger Interface: Integrate with a chatbot or API to trigger the workflow. Customize: Adjust settings based on the query types you want to handle and the output format. 🔧 For more detailed instructions, please check the sticky notes inside the workflow. 📌

NisaBy Nisa
4409

N8N contact form workflow

📬 N8N Contact Form Workflow: Capture, Notify via Email, and Redirect with Confirmation/Error Handling This n8n workflow facilitates contact form submissions through a customizable form that sends an email notification to support and redirects users based on the submission outcome. It is ideal for embedding a functional "Contact Us" form on websites with automated email notifications. --- ✨ Features Collects first name, last name, email, company name, and a message Sends formatted email notification to the support team Displays success or error confirmation to the user Customizable UI and form behavior Error fallback handling with user-friendly feedback --- 🧩 Nodes Overview On form submission (Trigger) Type: formTrigger Displays the contact form to users and triggers the workflow on submission. Send Email to Support Type: emailSend Sends an HTML email to a support address with the form details. Uses an SMTP credential for sending. If Email Sent Type: if Checks if the email was sent successfully using the existence of messageId. Confirmation Form Type: form Displays a “Thank You” HTML message after a successful submission. Redirect Form Type: form Redirects the user to a specified URL (e.g., LinkedIn profile). Form (Error) Type: form Displays an error message if email delivery fails. NoOp Nodes End (Success) and End (Error) to mark flow terminations cleanly. --- ⚙️ Customization Options Change the form fields, title, or descriptions in the formTrigger node. Update the email body or subject in the emailSend node. Redirect to a different URL by editing the Redirect Form node. Modify success and error UI with HTML content in the Confirmation Form and Form. --- 🧠 Use Cases Website "Contact Us" form integration Lead generation forms for businesses Customer service inquiry collection Feedback or support ticket system --- 🚀 How to Use Import this workflow into your n8n instance. Configure SMTP credentials for the emailSend node. Publish the formTrigger endpoint (e.g., /contact-us) publicly or embed in your website. Test submission and confirm email delivery and redirects. --- 🔐 Notes Ensure SMTP credentials are correctly configured in n8n. Make sure your n8n webhook URLs are reachable from your website or frontend. --- Made with ❤️ using n8n by Akhil.

Akhil Varma GadirajuBy Akhil Varma Gadiraju
3541

Learn secure webhook APIs with authentication and Supabase integration

This template is a practical introduction to n8n Webhooks with built-in examples for all major HTTP methods and authentication types. It is designed as a learning resource to help you understand how webhooks work in n8n, how to connect them to a data store, and how to secure them properly. What’s included: Webhook nodes for GET, POST, PUT, PATCH, DELETE, and HEAD Demonstrations of Basic Auth, Header Auth, and JWT Auth Supabase integration for creating, retrieving, updating, and deleting rows Example response handling with Respond to Webhook nodes Sticky notes explaining each method, response type, and security option Use this template to: Learn how to configure and test webhooks in n8n Explore different authentication strategies Connect webhooks to a simple Supabase table Understand best practices for securing webhook endpoints This workflow is intended as an educational starting point. It shows you how to receive requests, map data, and return responses securely. For production use, adapt the structure, apply your own security policies, and extend the logic as needed. Check out the YouTube video here: https://www.youtube.com/watch?v=o6F36xsiuBk

Wayne SimpsonBy Wayne Simpson
2380

Personalized outreach for lawyers with LinkedIn scraping, GPT-4o, Google Sheets

⚠️ This template uses only official n8n nodes. No community nodes required. 🧑‍💼 Who is this for? This workflow is designed for: Legal tech founders Marketing freelancers or consultants Agencies supporting lawyers and small law firms Anyone doing outbound outreach in the legal niche ❓ What problem is this solving? LinkedIn is a goldmine for targeting legal professionals — but scraping and personalizing outreach is tedious and expensive. Most tools either: Require paid LinkedIn Sales Navigator Can’t personalize at scale Violate LinkedIn’s TOS This workflow solves that by using free Google Search, OpenRouter AI, and GPT-4o to find, enrich, and message up to 1,000 solo lawyers per day — without using browser automation or scrapers. --- ⚙️ What this workflow does Uses Google Programmable Search to find solo lawyers and small firm founders on LinkedIn Parses each profile’s name, title, profile URL, and snippet Saves raw lead data to Google Sheets Uses OpenRouter Sonar Pro to enrich each profile with external content Generates a personalized, 1-line message using GPT-4o Appends the final message into Google Sheets for outreach --- 🛠️ Setup Estimated time: 15–20 minutes ✅ Google Programmable Search Enable the Custom Search API on Google Cloud Create a programmable search engine set to search the full web Copy your API key and CX ID ✅ Google Sheets Create a sheet with columns: Name, Title, Profile URL, Outreach Message Share the sheet with your OAuth-connected Google account ✅ OpenRouter Sign up at openrouter.ai Fund with at least $5 and generate your API key Use the model perplexity/sonar-pro for real-time research ✅ GPT-4o (optional) You can use your OpenAI key or route GPT-4o via OpenRouter All setup-specific values are marked clearly in sticky notes and placeholders. --- 🛠️ How to customize this workflow to your needs Change the Google search query to match your industry (e.g., "founder" AND "therapist" site:linkedin.com/in) Modify the AI prompt to match your tone (formal, casual, humorous) Connect the final output to your CRM (like HubSpot, Airtable, etc.) Add a second outreach message variant to A/B test performance --- 📌 Sticky Notes & Annotations All nodes are clearly renamed for understandability (e.g., Find Lawyer Profiles, Parse LinkedIn Search Results) Color-coded sticky notes explain: Setup instructions Required credentials Use case --- 🗂 Category AI Sales Marketing

Ibrahim MalickBy Ibrahim Malick
2371

Create multi-step reasoning AI agents with GPT-4 and reusable thinking tools

Unlock a new level of sophistication for your AI agents with this template. While the native n8n Think Tool is great for giving an agent an internal monologue, it's limited to one instance. This workflow provides a clever solution using a sub-workflow to create multiple, custom thinking tools, each with its own specific purpose. This template provides the foundation for building agents that can plan, act, and then reflect on their actions before proceeding. Instead of just reacting, your agent can now follow a structured, multi-step reasoning process that you design, leading to more reliable and powerful automations. Who is this for? AI and automation developers: Anyone looking to build complex, multi-tool agents that require robust logic and planning capabilities. LangChain enthusiasts: Users familiar with advanced agent concepts like ReAct (Reason-Act) will find this a practical way to implement similar frameworks in n8n. Problem solvers: If your current agent struggles with complex tasks, giving it distinct steps for planning and reflection can dramatically improve its performance. What problem does this solve? Bypasses the single "Think Tool" limit: The core of this template is a technique that allows you to add as many distinct thinking steps to your agent as you need. Enables complex reasoning: You can design a structured thought process for your agent, such as "Plan the entire process," "Execute Step 1," and "Reflect on the result," making it behave more intelligently. Improves agent reliability and debugging: By forcing the agent to write down its thoughts at different stages, you can easily see its line of reasoning, making it less prone to errors and much easier to debug when things go wrong. Provides a blueprint for sophisticated AI: This is not just a simple tool; it's a foundational framework for building state-of-the-art AI agents that can handle more nuanced and multi-step tasks. How it works The re-usable "Thinking Space": The magic of this template is a simple sub-workflow that does nothing but receive text. This workflow acts as a reusable "scratchpad." Creating custom thinking tools: In the main workflow, we use the Tool (Workflow) node to call this "scratchpad" sub-workflow multiple times. We give each of these tools a unique name (e.g., Initial thoughts, Additional thoughts). The power of descriptions: The key is the description you give each of these tool nodes. This description tells the agent when and how it should use that specific thinking step. For example, the Initial thoughts tool is described as the place to create a plan at the start of a task. Orchestration via system prompt: The main AI Agent's system prompt acts as the conductor, instructing the agent on the overall process and telling it about its new thinking abilities (e.g., "Always start by using the Initial thoughts tool to make a plan..."). A practical example: This template includes two thinking tools to demonstrate a "Plan and Reflect" cycle, but you can add many more to fit your needs. Setup Add your own "action" tools: This template provides the thinking framework. To make it useful, you need to give the agent something to do. Add your own tools to the AI Agent, such as a web search tool, a database lookup, or an API call. Customize the thinking tools: Edit the description of the existing Initial thoughts and Additional thoughts tools. Make them relevant to the new action tools you've added. For example, "Plan which of the web search or database tools to use." Update the agent's brain: Modify the system prompt in the main AI Agent node. Tell it about the new action tools you've added and how it should use your customized thinking tools to complete its tasks. Connect your AI model: Select the OpenAI Chat Model node and add your credentials. Taking it further Create more granular thinking steps: Add more thinking tools for different stages of a process, like a "Hypothesize a solution" tool, a "Verify assumptions" tool, or a "Final answer check" tool. Customize the thought process: You can change how* the agent thinks by editing the prompt inside the fromAI('Thoughts', ...) field within each tool. You could ask for thoughts in a specific format, like bullet points or a JSON object. Change the workflow trigger: Switch the chat trigger for a Telegram trigger, email, Slack, whatever you need for your use case! Integrate with memory: For even more power, combine this framework with a long-term memory solution, allowing the agent to reflect on its thoughts from past conversations.

Guillaume DuvernayBy Guillaume Duvernay
2137

Export WordPress posts to CSV and upload to Google Drive

Overview This n8n workflow automates the process of extracting published WordPress posts, converting them into a CSV file, and uploading it to Google Drive. It’s perfect for content backups, SEO audits, and data migration. Features Fetches all published posts from a WordPress website Extracts key post details (ID, Title, Link) Converts the extracted data into a CSV file Uploads the CSV file to Google Drive for easy access and storage Use Cases SEO Optimization: Export post data for keyword analysis and performance tracking Automated Content Backup: Store WordPress post details in Google Drive. You can add more fields to the Csv file if needed Workflow Steps Trigger Workflow Manually The workflow starts when triggered manually in n8n. Retrieve WordPress Posts The workflow fetches all published posts using the WordPress API. It extracts: Post ID Title Link Rendered Content Format Data The retrieved data is structured to ensure correct CSV formatting. Convert to CSV File The formatted data is transformed into a downloadable CSV file. Upload to Google Drive The CSV file is automatically uploaded to a specified Google Drive folder for easy access and storage. How to Use Connect your WordPress and Google Drive accounts to n8n. Run the workflow manually or set up a scheduled trigger. Access the CSV file from your Google Drive folder.

Codez & AIBy Codez & AI
1758

Voice & text assistant with Telegram, Gemini AI, Calendar, Gmail & Notion

This n8n template demonstrates how to turn a Telegram bot into a personal AI-powered assistant that understands both voice notes and text messages. The assistant can transcribe speech, interpret user intent with AI, and perform smart actions such as managing calendars, sending emails, or creating notes. Use cases Hands-free scheduling with Google Calendar Quickly capturing ideas as Notion notes via voice Sending Gmail messages directly from Telegram A personal productivity assistant available on-the-go Good to know Voice notes are automatically transcribed into text before being processed. This template uses Google Gemini for AI reasoning.The AI agent supports memory, enabling more natural and contextual conversations. How it works Telegram Trigger – Starts when you send a text or voice note to your Telegram bot. Account Check – Ensures only authorized users can interact with the bot. Audio Handling – If it’s a voice message, the workflow retrieves and transcribes the recording. AI Agent – Both transcribed voice or text are sent to the AI Agent powered by Google Gemini + Simple Memory. Smart Actions – Based on the query, the AI can: Read or create events in Google Calendar Create notes in Notion Send messages in Gmail Reply in Telegram – The bot sends a response confirming the action or providing the requested information. How to use Clone this workflow into your n8n instance. Replace the Telegram Trigger with your bot credentials. Connect Google Calendar, Notion, and Gmail accounts where required. Start chatting with your Telegram bot to add events, notes, or send emails using just your voice or text. Requirements Telegram bot & API key Google Gemini account for AI Google Calendar, Notion, and Gmail integrations (optional, depending on use case) Customising this workflow Add more integrations (Slack, Trello, Airtable, etc.) for extended productivity. Modify the AI prompt in the agent node to fine-tune personality or task focus. Swap in another transcription service if preferred.

Paul AbrahamBy Paul Abraham
1742

🤖🚚 AI agent for transportation orders management with GPT-4o and Open Route API

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. [](https://youtu.be/0InkUBOUMQQ) Two AI Agent nodes and a connection to Openroute Service API are used to parse the content of pickup requests [](https://youtu.be/0InkUBOUMQQ) 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 [](https://youtu.be/0InkUBOUMQQ) 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! [](https://youtu.be/0InkUBOUMQQ) 🎥 Check the Tutorial This template was built using n8n v1.93.0 Submitted: June 5, 2025

Samir SaciBy Samir Saci
1735