Automated Cloud Python Script for Sales Data
Budget: -
HOURLY / PART_TIME
⭐ 0.00 (0)
Netherlands
microsoft-windows-powershell, perl
Preferred qualifications
- Experience: Intermediate
Automated Cloud Python Script (Web Scraper + Email Parser) to Daily Excel Sheet
Description:
I am looking for a Python developer to build a fully automated data extraction tool that runs daily in the cloud (e.g., PythonAnywhere, AWS, or Google Cloud) and delivers a consolidated Excel sheet via Email/Google Drive.
The tool needs to extract sales data from 11 stores in total, but multiple stores use the same systems:
* 3 stores use System A (same website structure/platform).
* 3 stores use System B (same website structure/platform).
* 2 stores are unique websites that require logging in (Username + Password only, NO two-factor authentication).
* 1 store only requires capturing the daily total revenue (no product breakdown needed).
* 1 store sends the daily sales data via Email (the script needs to parse the incoming email data).
Data Processing Requirements:
* Log in automatically to the websites and navigate to the sales reports.
* Combine data from all 11 sources into one single Excel file.
* The script must calculate: Commission, Cost Price, and Net Profit per product/store based on fixed rules I will provide.
* Error handling: If one website fails or changes, the script should still process the other 10 stores and notify me of the error.
Tech stack preferred: Python (Selenium/Playwright, BeautifulSoup, Pandas, IMAP for email parsing).
Please provide a fixed price quote and your estimated timeline.
Open job
AI proposal draft
Generate a short cover letter to copy into the offer. Says you are interested and ready to work.
Sign in to generate an AI proposal draft.
Log in