Hi there!
Here's what you need:
1) Power automate premium license
2) Power automate unattended process license ($150/month/bot)
3) A VM or hosted VM to run unattended
4) A cloud flow that triggers this every 30 minutes or frequency you desire
Note: one bot can run all 30 queries sequentially.
Best practice:
1) use input parameters for shopID & queryName
2) loop through a list
3) DL files one by one
Remember:
1) cannot run if any user is logged into VM
2) cannot display message boxes/popups on VM
3) screen resolution should match developed UI machine
4) NO MFA on VM
All very doable and a common pattern, I have many like this in production.
------------------------------------------------
⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!
Always glad to help! 💯💯💯💯💯
Tom
Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn