How can I schedule python script in the cloud?

Question

I am developing a python script that downloads some excel files from a web service. These two files are combined with another one stored in my computer locally to produce the final file. This final file is loaded to some database and PowerBI dashboard to finally visualize data.

My question is: How can I schedule this to run it daily if my computer is turned off? As I said, two files are web scraped (so no problem to schedule) but one file is stored locally.

One solution that comes to my mind: Store the local file in Google Drive/OneDrive and download it with the API so my script is not dependent of my computer. But if this was the case, how can I schedule that? What service would you use? Heroku,...?

score 1 · Answer 1 · answered Jul 20 '21 at 17:36

1

I am not entirely sure about your context, but I think you could look into using AWS Lambda for this. It is reasonably easy to set it up and also create a schedule for running code.

It is even easier to achieve this using the serverless framework. This link shows an example built with Python that will run on a schedule.

answered Jul 20 '21 at 17:36

rd05

64
4

1

I have found pythonanywhere.com which is free for one task. I'll try with that one.. if I need more capabilities I'll go with AWS – Alberto Martinez Lasheras Jul 21 '21 at 12:16

score 0 · Accepted Answer · answered Jul 20 '21 at 17:42

0

I am running the schedule package for exactly something like that. It’s easy to setup and works very well.

answered Jul 20 '21 at 17:42

Faulander

327
3
12

but that depends on your computer to be turned on, right? – Alberto Martinez Lasheras Jul 21 '21 at 12:06
heroku, upload your local script and run the schedule package there – Faulander Jul 21 '21 at 20:42

How can I schedule python script in the cloud?

2 Answers2