quadratichq / quadratic

Quadratic | Spreadsheet with Python, SQL, and AI
https://QuadraticHQ.com
Other
3.02k stars 154 forks source link

feat: cron jobs / automation on Python or SQL scripts #759

Open waveminded opened 1 year ago

waveminded commented 1 year ago

Users have expressed the ability to run Python scripts on a frequency to potentially update a Quadratic sheet automatically.

For example: a data analyst creates a script that generates a data report in Quadratic. This report is shared with fellow team members. The analyst has to re-run the script manually to create a fresh report and then let their colleague know the report has been updated. By automating this workflow an analyst could create a reporting tool that automatically refreshes and updates the associate team members.

davidkircos commented 1 year ago

It’s easy to implement a client, side, refresh interval, that replaces existing data. I think we’d want to start with that. Then add server-side interval, were you also have the option to append new data, instead of overriding it. This would run in the background, regardless of the file was open by the client or not

luke-quadratic commented 11 months ago

following up in #906