Extract data from Gmail attachments to Google Sheets using DocuPipe
UnknownWhat this workflow does
This workflow has 9 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Gmail, Google Drive, Google Sheets and Docupipe (community).
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Label as Processing (Gmail): add labels (message)
- Get Extracted Data (Docu Pipe): get result (extraction)
- Upload Attachment & Extract Data (Docu Pipe): upload and extract (extraction)
- Process Extraction Result (Code): runs custom JavaScript code
- Save Attachment to Drive (Google Drive): upload
- Add Metadata (Edit Fields (Set)): sets 2 fields: Document Name, Extracted At
- Append Row to Spreadsheet (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-docupipe is verified or supports 3.0 (used in Upload Attachment & Extract Data, Get Extracted Data).
- Check that n8n-nodes-docupipe is verified or supports 3.0 (used in Extraction Complete).
- Also check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll).
Nodes used (8)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Gmail
n8n-nodes-base.gmail - Docu Pipe
n8n-nodes-docupipe.docuPipe - Google Drive
n8n-nodes-base.googleDrive - Docu Pipe Trigger
n8n-nodes-docupipe.docuPipeTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
Who is this for? Teams that receive documents via email (invoices, receipts, contracts) and want structured data automatically extracted and added to a spreadsheet - without manual data entry. What it does This template contains two connected flows: -…