waxdotrun's comments

Using your repo, I get an error:

execution failed: TypeError: Cannot read properties of undefined (reading 'value')

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.).

0 - https://www.wax.run/

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.

0 - https://www.wax.run/

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.

0 - https://www.wax.run/

Is there a repo with the Tooljet project? e.g. what API calls are being made, etc.? Would be cool to see what a Tooljet user would do to make this.

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.

Here's a demo of building reports:

https://www.youtube.com/watch?v=-6pbj3eOmLY

And here's one setting up a sync:

https://www.youtube.com/watch?v=-A6u6ZfJsQk

"so buy now for goodness' sake"

I think this is actually targeted at adults. The only pic with a person in it is an adult. Think "secret santa" gift.

This one does have colors though.

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.

0 - https://www.wax.run/

Nice landing page.

Why would I use this over Fivetran / Airbyte?

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.

yeah, the type of person that would use this would know Python (or JS), in which case they'd want to use that.

I noticed the same thing (technical spreadsheet users) and built Wax[0] to make it easier to build apps on top of Google Sheets.

0 - https://www.wax.run/

We're (https://www.wax.run/) doing this. We expose a CRUD app for your existing database in Google Sheets. You can also call custom Python for anything not covered by SQL.

Agreed, low-code is the happy middle ground here. Code is the most concise way to express what you want to do with data, so tools should just embrace that instead of hiding it away.

We're running a low-code internal tool builder and everything is built / configured with code, but you never start from scratch, so it's 50x more productive then building your own.

This was my observation as well. Sheets is actually quite good, but what's missing is connectivity to other tools (e.g. your database). This is exactly the problem we're going after with Wax[0]. We let you deeply integrate Sheets into your other apps.

0 - https://www.wax.run/

This has been my experience with internal tool builders too. The barrier to entry is quite high to try most of them and it's really hard to have a whole team test them out.

This adoption issue was part of the inspiration for Wax [0] which lets you build internal tools on top of Google Sheets. If your team is already using Sheets, it's much easier to add the missing pieces there vs. pushing people to an entirely separate platform.

0 - https://www.wax.run/

Thought that was funny too. The company has been around since 2016 (originally called "dashdash") and Pipes shut down in 2015, so it'd make sense as the original pitch in 2016.

Yes, Sheets is amazing already. It is missing integrations out of the box though which is where Rows is trying to win. I notice this problem a while back and built Wax (https://www.wax.run/). Wax adds the features you'd want from Rows to Sheets. We handle integrations and scheduling. Also, considering a lot of internal tools leverage SQL and Python, we make using those them from Sheets simple.

Yeah, I had a similar idea to Rows, but decided it'd be better to add what's missing to Sheets vs. build an entirely separate app. Wax (https://www.wax.run/) helps you build internal tools on top of Google Sheets. It's built using Apps Script and handles a ton of the boilerplate you'd want for any internal tool. Scheduling and integrations are hard to do in Apps Script, so we handle that and considering a lot of internal tools leverage SQL and Python we make using those them from Sheets simple.