Simple excel automation
Бюджэт: $100.0
FIXED /
⭐ 5.00 (2)
United States
microsoft-flow, microsoft-power-bi-development
Пераважная кваліфікацыя
- Вопыт: Эксперт
I need a simple Windows-based automation that runs once per day, 7 days a week. This is first of many simple automations.
The process is:
Log into 2 websites using credentials I will provide securely.
Download 1 Excel report from each website.
Combine/match the two reports primarily using a common field.
Apply approximately 5-10 simple formulas/conditions.
Refresh a simple Excel dashboard showing the required results.
Automatically save/overwrite the finished dashboard in a designated Dropbox folder every day.
I am open to Power Automate Desktop + Power Query, Python, or another simple/reliable solution. I care more about reliability and ease of maintenance than sophisticated coding.
Requirements:
Fully automated after initial setup
Runs daily without manual intervention
Handles the two website downloads
Refreshes Excel data/formulas
Outputs a clean Excel dashboard to Dropbox
Basic error handling if a website/report is unavailable
Provide source files/code and brief instructions so I can maintain it
Fixed budget: $100
This is a small project — only two files and a few formulas. Please only apply if you have done browser + Excel automation before.
In your response, tell me what technology you would use and why.
Адкрыць заказ
AI-чарнавік адказу
Згенеруйце кароткі cover letter па гэтай вакансіі. Перад адпраўкай адрэдагуйце.
Увайдзіце, каб згенерыраваць AI-чарнавік.
Увайсці