# Automated PDF Data Extraction from Gmail and Google Sheets Integration

> Developed an automated solution for a client who received daily PDFs via email.

Section: Google Apps Script

Page: https://showcase.growlyze.cloud/case/gas-automated-pdf-data-extraction-from-gmail

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.

Image: Feature list and the two-workflow design: a scheduled main flow (PDF parsing → validation → sheet integration) alongside a manual upload flow (login → upload). (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image1.png)

Image: The FastAPI backend that handles the upload, invoice parsing, and Sheets integration. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image2.png)