I will build a python automation script for API data extraction and alerts
Python Automation and AI Workflow Developer
About this Gig
I build automated Python data pipelines (ETL) that extract data from APIs, clean and filter it based on your specific business rules, and deliver it exactly where you need it.
If you have a manual process of checking websites, downloading CSVs, or monitoring dashboards, I can automate it so the exact data you need simply arrives in your inbox or database on a schedule.
How I Structure Pipelines (ETL):
- Extract: Pulling raw JSON/CSV data from public APIs or web sources using Python (requests).
- Transform: Using pandas to clean the data, drop irrelevant columns, calculate averages, and filter for specific conditions.
- Load / Automate: Routing the cleaned data through n8n webhooks to generate formatted email alerts, update Google Sheets, or trigger other automated workflows.
Next Steps: Please send me a message with a link to the API or data source you want to track, and a brief description of the rules you want to apply to the data. I will review it and let you know exactly how we can automate it.
Technology:
Google Sheets
•
Python
My Portfolio
FAQ
Do I need to provide the API key?
If the data source you want me to track is private or requires a login, yes. If it is a public API, no key is needed.
Can you send the data to Google Sheets instead of Email?
Absolutely. Using n8n, I can route your cleaned data to Google Sheets, Airtable, Slack, Discord, or almost any modern software platform.
: Will this run automatically on its own?
Yes. If you select the Premium package, I will deploy the script to the cloud (using GitHub Actions) so it runs entirely hands-free on whatever daily or weekly schedule you require.

