🔬 Extract PDF itineraries to Google Sheets with GPT-4.1-Mini & Gmail notifications
⚡ 600 views · 🔬 Document Extraction & Analysis
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
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
Google Sheets, Gmail, OpenAI Chat Model, n8n Form Trigger, OpenAI, Information Extractor
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File