This is great! Are you working on Monitoro (great name and logo by the way) full time? Seems like there'd be plenty of demand for it. A couple questions:
1. How do you handle auth (e.g. if I need to be logged into LinkedIn to see some data)?
2. Why did you add supabase as an integration? Seems like there wouldn't be much demand for that considering their size.
I've been hacking on Wax[0] which lets people run Python + SQL from Sheets with zero infrastructure. It's more in the low-code (vs. no-code) space and built for less technical people that already know some Python or SQL. It's also already integrated with other tools (e.g. databases, Slack, etc.).
> Are you working on Monitoro (great name and logo by the way) full time?
Thank you and yes!
1. We allow cookies to pass through in Local mode, i.e. on your computer (we don't store them, literally we try to make Monitoro's layer transparent to the browser). We don't support auth in Cloud extraction.
2. We built Monitoro on Supabase for quite some time and think there's great synergy between an easy platform to store and serve data (Supabase) and a platform to source that data in the first place (Monitoro). It's also a great alternative to Airtable when your database starts growing beyond the 50K record limit.
Wax looks really cool, I love it! Sheets is really the holy grail of personal computing and begs to be used for all its power.
Translating between all these layers was probably not easy, kudos. I'm a bit curious though regarding Google API limits. Did you hit any speedbump with that due to the volume of data you have to sync?
PS: Apologies for the slow reply here! Let's connect on twitter: twitter.com[slash]Omar[nothing]Kamali
Agreed, GAS is a great idea, horribly executed. It's part of the reason I made Wax[0]. It lets people run Python + SQL from Sheets with zero infrastructure. It's like GAS built for less technical people that already know some Python or SQL. It's also already integrated with other tools (e.g. databases, Slack, etc.).
If anyone has internal apps that are heavily dependent on Sheets, I'd really appreciate your feedback.
I agree. One of the great things with VB was you had an instant "programming environment" when you opened it from Excel. But I think learning VB feels like a waste since you can only use it in a limited domain.
Learning Python is just as easy as VB and can be used across many domains, but it's hard to set up an environment (install packages, managing env's, etc.). I thought it'd be cool if you could make Python work like VB from Google Sheets, which lead to Wax[0]. It lets people run Python from Sheets with zero infrastructure. If anyone has internal apps that are heavily dependent on Sheets, I'd really appreciate your feedback.
Wax (https://www.wax.run/) lets you build internal tools on top of existing Google Sheets your team already uses. We help you automate annoying DevOps tasks like updating data in SQL. You can create a bidirectional link between Google Sheets and your database (Postgres, Snowflake, MySQL, Redshift, and SQL Server) in a couple clicks. 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). Actions can be scheduled to run hourly, daily or whatever cadence works for you.
Did you look at TablePlus? Curious where it landed in your evaluation since I've tried pretty much every desktop SQL client and have landed on TablePlus as my goto.
Also, if you're looking for a spreadsheet UI for MySQL, Wax [0] makes it easy to interact with your database from Google Sheets. I'm the founder, happy to answer any questions.
execution failed: TypeError: Cannot read properties of undefined (reading 'value')