waxdotrun

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

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.

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.

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

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:

And here's one setting up a sync:

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

Show HN: Build internal tools in Google Sheets wax.run

2 waxdotrun 5 years ago 1 comments

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

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.

Show HN: Two-way sync between SQL and Google Sheets wax.run

10 waxdotrun 5 years ago 1 comments

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.