Cool idea guys, congrats on the launch especially given it was mid-batch.
I'm not in the market for something like this but it resonates with me since a few times now we've run into the need to jury-rig some scripts to pull data from a MySQL DB to populate a Google Sheet, which then does some simple calc/re-packaging for display on a dashboard or other simple BI use-case. But to do it you end up maintaining basically a simple "app", even if it's just a cron job hitting a python script hourly or something.
I also like the idea of connecting the world's most powerful / most adopted BI tool (spreadsheets) and the more proper data stores one finds in DBs.
Thanks! Would love to understand more about your use case. What do you use to display dashboards? Is through charts inside Sheets or do you have a separate tool reading data from the spreadsheet and displaying it? We are working on a MySQL connection and scheduled refreshes. Might be able to solve your problem soon
I'm not in the market for something like this but it resonates with me since a few times now we've run into the need to jury-rig some scripts to pull data from a MySQL DB to populate a Google Sheet, which then does some simple calc/re-packaging for display on a dashboard or other simple BI use-case. But to do it you end up maintaining basically a simple "app", even if it's just a cron job hitting a python script hourly or something.
I also like the idea of connecting the world's most powerful / most adopted BI tool (spreadsheets) and the more proper data stores one finds in DBs.