Automated PDF Data Extraction from Gmail and Google Sheets Integration
Google Apps Script
Works with
Google Apps Script
Gmail
Google Sheets
Developed an automated solution for a client who received daily PDFs via email. Created a Google Apps Script that scans Gmail for specific emails containing PDF attachments, downloads and parses these PDFs to extract vital information, and transfers this extracted data into a designated Google Sheet. The script is scheduled to run automatically at a pre-defined time each day, ensuring timely data processing and minimal manual intervention.
Features
User Authentication: Secure login mechanism to authenticate users.
PDF Upload: Interface to upload PDF files manually.
Data Extraction: Extract specific fields like order code, shipping address, product details, etc., from the uploaded PDF.
Google Sheets Integration: Populate the extracted data into a Google Sheet.
Scheduled Email Fetching: Automated function to fetch PDF attachments from a user’s email at scheduled intervals.
Data Validation: Validation checks to ensure data consistency and accuracy.
Feature list and the two-workflow design: a scheduled main flow (PDF parsing → validation → sheet integration) alongside a manual upload flow (login → upload).The FastAPI backend that handles the upload, invoice parsing, and Sheets integration.
Google Apps Script
