Every week I receive a batch of customer information locked inside scanned PDF files that land in a Google Drive folder. I need those details to appear automatically in my Zoho Creator app without any manual copy-paste. The workflow I have in mind is simple in concept but must be rock-solid in execution: detect new PDFs, perform accurate OCR, parse the key customer fields (name, address, phone, email, and any unique IDs), then push or update the matching records in Zoho Creator. Duplicate prevention and error logging are essential, and the job should run on a scheduled trigger so it clears the folder at the same weekly cadence. You are free to build this with Google Apps Script, Zoho Flow, Zapier, or direct API calls—whatever delivers consistent results and is easy for me to maintain after hand-off. Deliverables expected • A functioning automation that pulls customer data from PDFs in Google Drive and inserts/updates records in Zoho Creator on a weekly schedule • Clear field mapping documented inside the script or a short README • Brief hand-over call or video walkthrough so I can tweak the workflow in the future Once I can drop a PDF into Drive and see the customer record appear correctly in Zoho Creator, the project is complete.