Custom software development for businessPay for results
Extract bank-statement PDF transactions into Google Sheets with Apps Script
Project brief
Looking for an Apps Script developer to connect Gmail, Drive OCR and Sheets.
Requirements: - Read incoming statement PDFs from PBZ, HPB and ZABA, including multi-page files. - Use Drive REST API/OCR to obtain text. Classify Uplata/Isplata using Duguje/Potražuje and identify the bank from the filename or content. - Parse invoice references such as R3360/25 and R33/26 with a suitable regex. - Fill the first empty row in column C (Redni broj), sequentially, without damaging adjacent VLOOKUP formulas. - Stay within Google Workspace/Apps Script: no paid external APIs or desktop installation.
Authorized mailbox access, redacted statements and the sheet mapping must be agreed before starting.
Deliverables & acceptance
What you'll deliver
- Apps Script source, Workspace setup instructions and sample-run evidence.
What the result must meet
- Agreed samples from all three banks yield the expected classification, bank and invoice references, including multi-page statements.
- Rows fill column C sequentially and neighbouring formulas remain intact; no external paid service is required.