A FastAPI web application for an Ecommarce that automates the process of invoice data extraction and Google Sheet updating. The web application serves as a central hub for collecting and managing invoice data, providing both automated and manual options for PDF uploads. Created using FastAPI, OAuth2, and a variety of other technologies, the application is robust, secure, and highly automated. It features scheduled email fetching to automate the collection of invoices and offers data validation checks to ensure the consistency and accuracy of the populated data.
- 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.
- Backend: FastAPI
- User Authentication: OAuth2 (admin account only)
- PDF Parsing: PyPDF2 or pdfplumber
- Data Population: Google Sheets API
- Front-end: HTML, CSS, and JavaScript
Clone the Repo and install the requirements
git clone https://github.com/concaption/invoice-processing.git
cd invoice-processing
pip install -r requirements.txt
python main.py
You can get in touch with me on my LinkedIn Profile:
You can also follow my GitHub Profile to stay updated about my latest projects:
If you liked the repo then kindly support it by giving it a star ⭐!
If you find any bug in the code or have any improvements in mind then feel free to generate a pull request.