Automated PDF report downloader & organizer with Google Drive & Sheets

by Omer Fayyaz ✓ · 444 views · created 2025-11-25 · Document Extraction

What this workflow does

This workflow has 17 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets and Google Drive.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).

1. Read Pending PDF URLs (Google Sheets): uses Google Sheets
2. Loop Over PDFs (Loop Over Items (Split in Batches)): loops over the items in batches
3. Completion Summary (Edit Fields (Set)): sets 2 fields: pdfsProcessed, completedAt
4. Prepare Download Info (Code): runs custom JavaScript code
5. Is Valid URL? (If): checks a condition and branches into true / false
6. Download PDF (HTTP Request): calls an HTTP API
7. Mark as Invalid (Edit Fields (Set)): sets 3 fields: status, errorMessage, pdfUrl
8. Download Success? (If): checks a condition and branches into true / false
9. Log Error (Google Sheets): append or update
10. Upload to Google Drive (Google Drive): uses Google Drive

…plus 4 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Drive

Before you upgrade to n8n 3.0

Nodes used (10)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Google Driven8n-nodes-base.googleDrive
• Edit Fields (Set)n8n-nodes-base.set

From the author

An automated PDF download and management system that collects PDFs from URLs, uploads them to Google Drive, extracts metadata, and maintains a searchable library with comprehensive error handling and status tracking. What Makes This Different: - Intelligent…

View the original on n8n.io → Check your own copy