Comment by waxdotrun

Wax (https://www.wax.run/) lets you create a true bidirectional link between Google Sheets and your database (Postgres, Snowflake, MySQL, Redshift, and SQL Server). You can also attach buttons in Sheets to Python and SQL scripts (e.g. hit an API using values from the current Sheet, process the results with Python, and return the results to Sheets). You can schedule any action to run hourly, daily or whatever cadence works for you.