AutomationMart
Home/Browse/Validate bills of lading, send Gmail replies, and post JSON with Google Gemini
n8n

Validate bills of lading, send Gmail replies, and post JSON with Google Gemini

n8nn8n12 modulesv1.0
GmailGemini

Quick overview This workflow triggers on a Gmail message from a specific sender, extracts bill of lading data from an email attachment using Google Gemini, validates the extracted values with Python, posts the structured JSON to a webhook URL, and replies to the sender with an HTML acceptance email. How it works 1. Triggers when a new Gmail email arrives from the configured sender and downloads the attached document. 2. Uses Google Gemini to analyze the attachment and rewrite the bill of

At a glance

Validate bills of lading, send Gmail replies, and post JSON with Google Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Gemini
Modules
12
Price
Free
Version
v1.0
Validate bills of lading, send Gmail replies, and post JSON with Google Gemini workflow diagram

About this workflow

Quick overview This workflow triggers on a Gmail message from a specific sender, extracts bill of lading data from an email attachment using Google Gemini, validates the extracted values with Python, posts the structured JSON to a webhook URL, and replies to the sender with an HTML acceptance email. How it works 1. Triggers when a new Gmail email arrives from the configured sender and downloads the attached document. 2. Uses Google Gemini to analyze the attachment and rewrite the bill of lading content into a structured Markdown format. 3. Uses a second Google Gemini agent with a structured output schema to convert the Markdown into validated JSON fields for shipper, consignee, shipment details, and line items. 4. Runs a Python validation that compares customer order package/weight values against the carrier line items and appends a validation result to the JSON. 5. Sends the resulting JSON payload to an external HTTP webhook endpoint. 6. Uses Google Gemini to draft an HTML acceptance reply email based on the validated data and sends it back to the original sender via Gmail. Setup 1. Connect your Gmail OAuth2 credentials and set the sender filter (and any other Gmail Trigger options) to match the emails you want to process. 2. Add Google Gemini (PaLM) API credentials and confirm the selected Gemini models are available in your account. 3. Ensure the incoming emails include a compatible bill of lading attachment and update the binary attachment property name if it differs from attachment0. 4. Replace the HTTP Request URL with your own endpoint that should receive the structured JSON payload. 5. Review the structured JSON schema and the Python validation logic to match your required fields and matching rules before enabling the workflow. Customization - Any LLM provider can do the task, change Gemini with any AI you can use Additional info This is an example of prompt chaining. It is an AI agent workflow that shows the benefit of chaining several LLMs together.

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

Extract and clean YouTube video transcripts with RapidAPI

Here is your refined template description with detailed step-by-step instructions, markdown formatting, and customization guidance. --- YouTube Transcript Extraction Workflow This n8n workflow extracts and processes transcripts from YouTube videos using the YouTube Transcript API on RapidAPI. It allows users to retrieve subtitles from YouTube videos, clean them up, and return structured transcript data for further processing. Table of Contents - Problem Statement & Target Audience - Pre-con

Free

Change background image for Gmail attachments using Remove.bg and add it to Airtable

Every time a new employee joins the company and sends an email with their photo, Make will automatically remove the background for that image using Remove.bg. After that the image will be uploaded to a Google Drive folder and added as a new record to Airtable. For the proper work of this scenario you can use our [example table](https://airtable.com/shr7nvgoQUzHQrmWM).

Free

Generate complete SEO audits with Apify, Claude Sonnet 4, and Gmail delivery

Description Get professional SEO audits delivered automatically in under 5 minutes. This complete n8n workflow analyzes any website and generates 4 comprehensive reports that you can send directly to clients. What You Get: - ✅ Complete n8n Workflow - Ready-to-import automation that runs entire SEO audits - ✅ Technical SEO Analysis - HTML structure, performance, and crawlability assessment - ✅ Content Quality Audit - Keyword optimization, readability, and E-A-T evaluation - ✅ Strategic Opportunit

Free

Automated BBB Lead Generation with BrowserAct

Automated BBB Lead Generation with BrowserAct This workflow lets you scrape BBB leads, clean data, remove duplicates, store results, and auto-send emails. 1. BrowserAct – Run Workflow Build your scraping flow in BrowserAct, connect the API to Make, and it returns scraped BBB business data. 2. JSON Parse Converts raw BrowserAct JSON into a clean array. 3. Iterator – Process Each Lead Sends each business through the workflow one at a time. 4. Google Sheets – Search for Duplicates Checks if th

Free

Personalized thank-you emails with website scraping, GPT-4o, and Gmail

Overview Impress your leads with ultra-personalized “thank you” emails that look hand-written — sent automatically seconds after they submit your intake form. This workflow instantly scrapes the prospect's website, extracts meaningful copy, and uses AI to write a custom thank-you message referencing something specific from their site. It gives the impression you immediately reviewed their business and crafted a thoughtful reply — without lifting a finger. Who’s it for - Agencies and con

Free

Publish SEO blogs to WordPress with GPT-4.1, DALL-E, Gemini, and Google Sheets

Automatically publish blog content to WordPress with AI-generated branded images, internal linking, and client reporting using Google Sheets, OpenAI, and Gemini What this workflow does This workflow receives written blog content from your content creation automation and handles the complete WordPress publishing process. It adds internal links to your content based on target keywords, generates 3 AI-powered branded images (thumbnail + 2 content images), uploads them to WordPress, inserts them int

Free

Post on X using Airtop and automate content pipelines

About The Post to X Automation Seamlessly automate posting to X using Airtop and Make. How to Automate Posting to X with Airtop Consistently engaging your audience on X (formerly Twitter) can be a challenge, particularly when done manually. Developers and automation engineers often struggle with repetitive tasks like scheduling tweets, maintaining consistent posting cycles, and integrating content from various sources or AI-generated feeds. Manually managing content updates increases fatigue, hu

Free

Daily habit RPG: Gamified Gmail reminders with quest system and progress tracking

Who's it for This template is perfect for anyone struggling with habit consistency who wants a fun, engaging way to maintain daily routines. It's ideal for productivity enthusiasts, fitness beginners, remote workers, students, or anyone who loves gamification and RPG elements. If you've ever wished your daily tasks felt more like an adventure game, this workflow is for you. How it works The workflow runs automatically every morning at your chosen time (default: 6 AM) and transforms your daily ha

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