Extract PDF Itineraries to Google Sheets with GPT-4.1-Mini & Gmail Notifications

Go to Workflow
0 views
Built by Cheng Siong Chin Cheng Siong Chin
Created on June 05, 2026

Description

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
Receives PDF uploads via form
Splits & loops through files
AI extracts structured data
Appends to Sheets with timestamps
Sends confirmation email

Prerequisites
OpenAI API key (platform.openai.com)
Google Workspace (Sheets & Gmail)
n8n v1.0.0+

Setup
Add OpenAI API key to n8n credentials
Create Google Sheet with extraction columns, authorize OAuth2
Configure Gmail OAuth2
Import workflow JSON
Edit AI prompt for your fields
Activate & share form URL

Customization
Modify extraction prompts
Adjust Sheets mapping
Customize email templates
Add error handling/validation
Extend to Word/Excel files

Use Cases
Invoices, expense reports, resumes, contracts, forms, legal docs

Nodes Used (5)

Gmail
n8n-nodes-base.gmail
Google Sheets
n8n-nodes-base.googleSheets
Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
OpenAI
@n8n/n8n-nodes-langchain.openAi
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi