Automate Parsing City Council Invoices into Google Sheets
Upwork
This job posting is over 30 days old. The position may have been filled or details may be outdated.
This project involves automating the process of handling approximately 100 City Council invoices received per month via email. The task includes monitoring a Gmail inbox for incoming emails, extracting PDF attachments, and organizing them appropriately. The extracted data should include invoice numbers, billing dates, account numbers, and line items. The structured data will then be saved in a Google Sheet with hyperlinks to the stored invoices on Google Drive.
Future Extension: Potential to sync this structured data with another billing system in an optional Phase 2.
Preferred Tech: Open to recommendations, including Google Apps Script and AI-powered PDF parsing tools.