Extract PDF itineraries to Google Sheets with GPT-4.1-Mini & Gmail notifications
Ready for 3.0What this workflow does
This AI workflow has 8 nodes and runs when someone submits an n8n form (“LOAD MULTIPLE FILES”). Along the way it connects OpenAI, OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“LOAD MULTIPLE FILES”).
- Split Files processes each PDF individually (Split Out): splits a list into separate items
- Loop Over Items ensures each document (Loop Over Items (Split in Batches)): loops over the items in batches
- Analyzes & extract PDF (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Extracted information to Google Sheets (Google Sheets): append or update
- Create Email (OpenAI): uses OpenAI
- email confirmation sent with results (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- OpenAI
@n8n/n8n-nodes-langchain.openAi - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger - Split Out
n8n-nodes-base.splitOut - Gmail
n8n-nodes-base.gmail - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
From the author
Extract PDF Itineraries to Google Sheets with GPT-4.1-Mini & Gmail Notifications Overview Automates PDF data extraction using OpenAI GPT, saves to Google Sheets, sends email confirmations. Reduces manual entry by 90%. How It Works 1. Receives PDF uploads via…