Google Drive Document Processing Performance Analytics - n8n Workflow

• Organizations needing to audit high-volume document processing throughput.


• Users leveraging the PDF Vector n8n node for large-scale OCR and data extraction.


• Data engineers requiring real-time performance and cost analysis of their document ingestion n8n workflow.


• Teams looking for sophisticated, custom analytics dashboards created entirely within an n8n workflow.

This advanced n8n workflow template solves the challenge of tracking performance and quality metrics during large-scale document processing. Instead of simply logging success or failure, this n8n workflow provides deep insights, including processing time per file, credit consumption, success rates segmented by file type (PDF, Word, Image), and a derived 'Quality Score'. It uses a Google Drive n8n node to list files and the PDF Vector n8n node for core processing, wrapping the entire operation in a robust custom logic layer to generate an actionable analytics report, providing visibility into the efficiency of your automation pipeline. This detailed tracking makes this one of the most valuable n8n templates for operational monitoring.

1. The n8n workflow begins execution via the 'Manual Trigger' n8n trigger.


2. The 'List Documents' Google Drive n8n node fetches up to 100 documents from a specified Google Drive folder.


3. The 'Validate & Queue Files' code n8n node inspects the documents, queues supported formats (PDF, Word, Image), filters oversized files (>50MB), calculates estimated credits, and assigns a processing priority based on size.


4. The validated list is fed into the 'Process in Batches' n8n node, which divides the work into manageable batches of five.


5. Each batch item is split out individually using the 'Split Items' n8n node.


6. The 'PDF Vector - Process Document/Image' n8n node attempts to extract content (OCR/Analysis) from the document URL. This n8n node is configured to continue on failure.


7. The 'Track Processing Results' code n8n node captures performance data for the individual processing attempt (success status, error messages, execution time, word count, and a calculated quality score).


8. The 'Collect Batch Results' aggregate n8n node consolidates the performance metrics for all processed files.


9. Finally, the 'Generate Analytics Report' code n8n node takes all collected metrics and initial file stats to produce a comprehensive, structured Markdown report detailing success rates, performance bottlenecks (fastest/slowest files), error frequencies, and recommendations. This final n8n node provides the crucial output of this detailed n8n workflow.

1. Import the n8n workflow: Copy the provided JSON and import it directly into your n8n instance.


2. Google Drive Credentials: Create or select your Google Drive OAuth2 credential. Ensure the service account (if used) has read access to the target folder.


3. PDF Vector Credentials: Set up credentials for the PDF Vector n8n node, typically involving an API key.


4. Configure Google Drive Folder: In the 'List Documents' n8n node, update the queryString parameter by replacing 'FOLDERIDHERE' with the actual ID of the Google Drive folder you wish to process.


5. Start: Initiate the n8n workflow using the 'Manual Trigger' n8n trigger to begin batch processing and analytics generation.

Manual Trigger n8n trigger: Initiates the document batch processing run.
Google Drive (List Documents) n8n node: Lists up to 100 files from a specified folder. Key configuration requires replacing the placeholder folder ID in the queryString.
Code (Validate & Queue Files) n8n node: Performs complex pre-processing logic, validating supported file types (PDF, Word, Image), filtering based on a 50MB size limit, and prioritizing the queue for optimized processing. A core component of this n8n workflow template.
Split In Batches n8n node: Controls flow by sending documents in fixed batches (size 5) to manage API load.
Split Out n8n node: Separates individual file metadata within a batch for processing by the next n8n node.
PDF Vector - Process Document/Image n8n node: The central action n8n node, executing OCR and content analysis based on the document's webViewLink. Crucially, it uses continueOnFail: true.
Code (Track Processing Results) n8n node: Calculates fine-grained metrics for each file, including execution time, quality score derivation, and credit tracking.
Aggregate (Collect Batch Results) n8n node: Merges the individual item results back into a consolidated list after processing.

• Code (Generate Analytics Report) n8n node: The final, powerful n8n node that aggregates statistics across the entire batch run to produce a comprehensive Markdown analytics report with performance recommendations.