← All questionsHow do I run my Python script every night without leaving the laptop open?
About Python and Airtable
It looks up each record from Shelf 12 that’s missing a year, fills it in, and writes to Airtable. Takes about twenty minutes. Right now I remember to run it about twice a week.
Replies
GitHub Actions, honestly. Put the script in a repo, add a workflow file with a schedule line like ‘cron: 0 9 * * *’, and put your Airtable token in the repo’s secrets. It runs on their machines while yours is closed. Free for what you’re describing. Ask ChatGPT for the workflow file, it gets this one right.
Aug 31viggo, Wanda F., Zaina and others agree
Went with the GitHub one. Took an afternoon, mostly working out what a secret was. It ran last night on its own and I did nothing, which is the point.
Sep 3Victor O. and tobi agree
If you ever want to actually see it run, a Raspberry Pi in a drawer with a cron line does the same thing and you can walk over and look at it. That’s how Bench Map updates.
Sep 5sprocket and viggo agree
Seconding Actions. Only catch is the schedule can run late by a few minutes or more when they’re busy, so don’t rely on the exact time.
Sep 1Victor O. agrees
Late but the Pi option is the one I’d pick if the script ever needs to touch something in the house. Otherwise Actions.
Sep 8
Sign in to reply.
Replies sit in the order people agree with them; the ones the asker marks “helped” lead. Names, never a number.