Hi Noah. Thank you!

You could use gspread to send data from a notebook to a google sheet, but that would require you manually running the notebook. It would “automatically” send your CSV but only when you run the notebook. Certainly easier than copy/pasting all the time once you get it up and running, and you’d be able to hardcode any data cleaning you need to do in the CSV.

I don’t know of a solution for scheduling a notebook to run on a timer, though.

You could look at creating a cron job using Celery, but that would require deploying an app.

I’ve wanted to do what you are describing for a while now, but haven’t found anything. Just went to google again for a solution and found this: https://docs.qubole.com/en/latest/user-guide/notebooks-and-dashboards/notebooks/jupyter-notebooks/scheduling-jupy-notebooks.html#create-jupy-schedule

I may give it a go sometime soon. Let me know if you have any luck with this because I’m interested as well!

Written by

Documentation and tutorials on Python, Programming, and Data Analysis. FPL Addict. Occasionally writing about biohacking, PMing, and food.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store