Automated Document Processing Pipeline: OneDrive File Trigger → Entity Extraction → Document Creation & Upload

Problem:

A business was manually processing files arriving in OneDrive, extracting data from zip archives, cross-referencing entity records across paginated API responses, and creating and authorizing documents one by one, a slow, error-prone process that couldn't scale with growing document volume

Solution:

Built a dual-path Make.com scenario triggered by new OneDrive files, the first path handles full entity pagination, iterates through all records, aggregates them into a structured JSON array, and stores the result as a variable; the second path simultaneously extracts zip files, pulls IRD numbers and mail types via pattern matching, processes Excel worksheet rows, and feeds the data through an automated document creation, authorization, and upload sequence

Result:

Delivered a fully automated document processing pipeline that handles file arrival, data extraction, entity matching, and document generation end-to-end, eliminating all manual processing and producing authorized, uploaded documents from raw incoming files without any human intervention