Автоматический парсер PDF в Excel/SharePoint

u could use Power Automate or a small automation workflow. the idea is: watch the folder where the COI PDFs are stored → when a new file appears or changes, extract the info you care about (like expiration dates) → then update your SharePoint Excel table automatically. if the files are structured the same way each time, you can even use a simple parser or OCR step to grab the expiration dates from the PDF and push them into your tracking sheet. once the data is in the table, your color rules (green/yellow/red) will update automatically. another option is moving the COI files into SharePoint itself. once everything is in the same system, automations become way easier. I’ve built similar setups where a workflow engine handles the file watching and updates the spreadsheet, and then a small d…