AutomationMart
Home/Browse/Extract purchase orders from Gmail using Gemini AI and save to Google Sheets
n8n

Extract purchase orders from Gmail using Gemini AI and save to Google Sheets

n8nn8n10 modulesv1.0
GmailGoogle SheetsGemini

AI-Powered Email to Purchase Order Workflow Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets β€” all without manual effort. --- ✨ Core Capabilities - ⏱ Runs every minute to check unread emails - πŸ“§ Filters emails by subject - πŸ€– Uses Gemini AI to summarize email content & extract structured order details - πŸ“… Formats dates into ISO calendar weeks - πŸ“Š Adds product data from Google Sheets to complete order info

At a glance

Extract purchase orders from Gmail using Gemini AI and save to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Gmail, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, Gemini
Modules
10
Price
Free
Version
v1.0
Extract purchase orders from Gmail using Gemini AI and save to Google Sheets workflow diagram

About this workflow

AI-Powered Email to Purchase Order Workflow Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets β€” all without manual effort. --- ✨ Core Capabilities - ⏱ Runs every minute to check unread emails - πŸ“§ Filters emails by subject - πŸ€– Uses Gemini AI to summarize email content & extract structured order details - πŸ“… Formats dates into ISO calendar weeks - πŸ“Š Adds product data from Google Sheets to complete order info - βœ… Appends final purchase order records into a Google Sheet (without replacing previous ones) --- πŸ›  Setup Essentials - πŸ“© Gmail account for fetching unread emails - πŸ”‘ Google Gemini (PaLM) API credentials - πŸ“’ Google Sheet with predefined purchase order headers --- πŸ“– Activation Guide 1. βš™οΈ Configure Gmail & Google Sheets credentials in n8n 2. 🎯 Adjust the subject filter to match your email rules 3. πŸ”Œ Connect Gemini AI with your API credentials 4. πŸ“‘ Create a Google Sheet with the required headers 5. ▢️ Activate the workflow and let it run in the background --- 🎨 Customizing the Workflow - πŸ” Email Filters β†’ Change keywords in the filter node to match your purchase order email subjects - 🏷 Order Fields β†’ Modify Set and Append to Google Sheet nodes if your schema differs - ✍️ AI Instructions β†’ Adjust the AI Agent’s prompt to fit your company’s email style or product details - ⏲ Frequency β†’ Update the Cron node if you want to scan emails less often - πŸ“‚ Target Google Sheet β†’ Point to a different sheet or tab depending on your department or customer ---

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

BrowserAct Intelligent Supplier Search

This template turns your Telegram bot into a Smart Supplier Locator Bot that helps users quickly find the best offers for any product they want to buy. When a user sends a message to the bot, Make first uses an AI step to understand the intent. If the message is casual chat, the bot asks the user to provide a product name. If it detects a shopping request, it extracts the product keyword and passes it to BrowserAct. BrowserAct then searches the web, opens the shopping section, and extracts mul

Free

Add canceled MakePlans bookings to a Google Sheets spreadsheet as new rows

Every time a booking is canceled on MakePlans, Make will automatically add that booking's info to a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1MRrpzP2oI4Us550piSNChYicXxp6RXxxp54V6JhBh4M/edit?usp=sharing).

Free

Organize your YouTube video database with Google Sheets

Effortlessly manage and track your YouTube video collection using Google Sheets. Save time with a structured, easy-to-access database, making it simple to organize, find, and analyze your content for improved efficiency and performance.

Free

✍️ AI agent to create Linkedin posts for blog promotion with GPT-4o

Tags: Automation, AI, Marketing, Content Creation Context I’m a Supply Chain Data Scientist and content creator who writes regularly about data-driven optimization, logistics, and sustainability. Promoting blog articles on LinkedIn used to be a manual task β€” until I decided to automate it with N8N and GPT-4o. This workflow lets you automatically extract blog posts, clean the content, and generate a professional LinkedIn post using an AI Agent powered by GPT-4o β€” all in one seamless automation. &

Free

Transform voice memos into daily journals & tasks with OMI.ME & Gemini AI

Who’s it for This template is perfect for OMI pendant users or anyone with AI-generated memory transcripts who want to: Automatically create daily journals in Markdown Extract actionable tasks from conversations Store memories in Google Drive Sync action items to Google Tasks Great for creators, ADHD professionals, techies, or productivity hackers who want to build a second brain workflow with no manual data entry. --- What it does / How it works This workflow: 1. Accepts POST data from the

Free

Research Kuaishou creator videos from a keyword with JustOneAPI

Quick overview Use this n8n workflow template to search Kuaishou creators by keyword and get their published video list with JustOneAPI.This template is for creator research teams, marketing teams, creator operations teams, analysts, and automation builders who want to turn a Kuaishou keyword into a structured list of creator videos inside n8n. How it works 1. The workflow starts with a single configuration node where you add your JustOneAPI token and the keyword you want to research. 2. It then

Free

Multi-tool research agent for animal advocacy with OpenRouter, Serper & Open Paws DB

This general-purpose sub-agent combines multiple research and automation tools to support high-impact decision-making for animal advocacy workflows. It’s designed to act as a reusable, modular unit within larger multi-agent systemsβ€”handling search, scraping, scoring, and domain-specific semantic lookup. It powers many of the advanced workflows released by Open Paws and serves as a versatile backend utility agent. --- πŸ› οΈ What It Does - Performs real-time Google Search using Serper - Scrapes and

Free

Auto-stop email sequences based on replies with IMAP and Google Sheets

Email Reply Auto-Stopper Workflow How It Works This n8n automation automatically stops your email sequences when prospects reply, preventing embarrassing follow-ups and maintaining professional outreach. The Process: Email Monitoring - IMAP trigger watches your inbox for new emails Reply Detection - When someone replies, it extracts their email address Database Lookup - Searches your Google Sheet prospect list for a match Auto-Stop - Updates the prospect's status to "STOP" and logs reply date Se

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint β€” instant download
  • Setup guide PDF included
  • 5 downloads Β· valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free