I did a Show HN a while ago regarding a project I’ve been working on called SheetSQL, which enables users to query and join their Google Sheets data with simple SQL in seconds.
> https://news.ycombinator.com/item?id=39689685
I’m happy to announce a new feature: Workflows! With workflows you will be able to define data operations that transform or operate over your sheets as sources. Currently the supported operations are SheetSQL queries and sending an email with the output of an operation. Expect more to come soon!
You can think of a workflow as a DAG (directed acyclic graph), pretty similar to how tools like DBT work. Now, the different part is that SheetSQL workflows are reactive, this means that operations only run when the data changes. If the data is the same, the operation will be skipped. This makes the workflows “On update” by default, and actually without a schedule. They run when a change happens, not regularly. SheetSQL is in charge of listening to those data changes.
E.g. imagine that you have a workflow that gets the top three sold products of a sheet, and sends an email when that data changes. SheetSQL would only run when the top 3 change, this is that even if we have more products sold, if the top 3 do not change, the workflow will be skipped.
About the pricing, it’s free up to 1k queries or workflows runs per month. And there’s a paid version with no limits for $5 per month. If you are interested on trying out or power use the tool, drop me an email to taras [at] sheetsql.io and I’m happy to give out some free trials :D
I’m eager to hear feedback or any recommendations of operations that would be useful for you, so do not hesitate to drop a comment!
Check it out at
Cheers,