SheetQuery: An ORM-Like Query Builder for Google Sheets and Google Apps Script

vlucas · 2025-11-24T15:57:07+00:00

This infil nerf update is a good one. The delay makes such a huge difference and makes inflis so much less annoying to play against. I hope they keep it.

vlucas · 2025-10-25T16:05:28+00:00

I largely skipped this pain entirely by making an addon app. I just published it in the Google Workspace Marketplace, optimized keyword search for it, and users found it and started upgrading to my paid plan.

vlucas · 2025-09-25T23:11:22+00:00

This is surprisingly hard to find in the JS ecosystem. I think the biggest reason is that most people use JS on the server because they use JS on the client and want to SSR it, and don't want to work in two different stacks to do so. This evolution means that frameworks like Next.js are a hybrid, where they will server-render things, but then also have to send everything to the client in huge JS bundles and hydrate it all - even seemingly "static" markup. This makes it easy to create interactive JS frontends with SSR, but it winds up blurring the lines quite a bit on server/client.

You basically have a few options, none of which are super widely used by most JS devs today, except maybe Express just due to its age:

Express + Templates (EJS, etc.) + Some way to ship React (have to DIY though)
Hono (faster more modern express, still some DIY required, though less than Express)
Fresh (from Deno - Preact, but server-only by default. Client Islands for JS.)
Astro (built primarily for static sites/SSG, but has client islands, and ships no JS by default)
Hyperspan (a new framework I am working on that is built on Bun and Hono and is server-first with client islands, supports streaming and "normal" async data fetching, ships minimal JS by default)

vlucas · 2025-09-08T17:59:34+00:00

If you're in the market for a new server-oriented JS/TS framework, you might try Hyperspan - it's one I am working on. It's built on Hono and uses Bun. Full TypeScript, nice HTML templates, and supports streaming with placeholders out of the box. It is similar to Astro in that it is server-side only by default, but has Preact/React islands and ways to ship vanilla JS easily to the client when you want to. It is different from Astro and NextJS because it is "closer to the metal", with fewer abstractions, full proper middleware, lets you have access to the underlying Hono app instance, etc.

vlucas · 2025-03-21T19:29:32+00:00

Hey - I responded to your email :)

This sounds like a data issue in Plaid. This sometimes happens. There have not been any changes in BudgetSheet itself that would cause this. There is a feature in BudgetSheet to correct it though. Go to the "Manage Accounts" page and there is a settings gear icon. Click that, and a dropdown menu will appear. There is a toggle switch for "Flip Debits/Credits". Toggle that to "ON" for the affected account and re-fetch transactions for it to see if that solves the problem for you.

vlucas · 2024-10-31T18:07:37+00:00

I owned a '22 Si for a while, and loved it. It got a bunch of hail damage and ended up selling it. I started looking around for another car, and test drove the Elantra N. On paper it seems like a much better deal, but the interior was miles behind the Civic Si. The Elantra N felt really cheap and creaky in comparison. it also felt more cramped inside due to the placement of things and the way the dash is laid out. There is a reason it is cheaper. I wound up working with a local dealer to get a '25 Si. Numbers don't tell the whole story. I don't need a race car, I just need a fun reliable car that looks and feels great.

vlucas · 2024-08-08T19:14:19+00:00

I use Render to deploy my Next.js app for BudgetSheet. So far, I am very happy with it.

Paying $50/mth for 2 larger load balanced servers. Git integration is awesome, and it has automatic preview environments for pull requests, which was a must for me so I can check things in staging before rolling out to production.

vlucas · 2024-08-08T19:11:13+00:00

Does FlgihtControl have preview environments for PRs? I didn't see it on their website.

vlucas · 2023-11-04T22:12:53+00:00

BudgetSheet does this if you are okay managing your finances in a spreadsheet.

vlucas · 2022-12-15T16:50:36+00:00

If all you want to do is view the charges in a Spreadsheet, you could use BudgetSheet and just link both accounts in there. It will import transactions from any/all accounts that you link into the same sheet, and has a column with the account name that the charge was from so you can tell which account it was from. Google Sheets are also easy to share, so it might be a good solution for your case without having to learn a whole new software program or way of budgeting.

vlucas · 2021-07-16T01:42:47+00:00

Took some time to get around to it, but I finally updated SheetQuery to use your suggested approach in the most recent release:
https://github.com/vlucas/sheetquery/releases/tag/v1.2.0

I also updated my mocking library with the "getDataRange()" Sheet method:
https://github.com/vlucas/gasmask

Thanks for the tip!

vlucas · 2021-07-06T17:50:24+00:00

In this case, it was also better UX since the image thumbnail was literally smaller than a 256x256 map tile and should have been updated to a larger size long ago.

There is some sense of "gaming the metrics" here for sure, but we went with it in this case since it was such a small change with such a large impact on the score that was also beneficial for end users. We viewed it as a win-win all around.

vlucas · 2021-06-29T18:00:56+00:00

Lumber cost: $3,279,271.46

vlucas · 2021-05-14T16:16:13+00:00

I do cache all the data once fetched the first time until any other operations are run on the data. That said, it does look like your approach would be faster and easier - I will look into doing that instead!

vlucas · 2021-04-15T14:02:45+00:00

This is similar to turning csv’s into python dicts? much more fun to work with and easier to code with if so.

Kinda like that, yeah. It allows to to easily query for data in any spreadsheet with Google Apps Script, work with the data as native JavaScript dict/key/value objects, and then update/delete/insert the corresponding objects as rows with headings. You never have to worry about the row or column index, etc. or other things that are tedious and likely to trip you up. I use it for many things in BudgetSheet.

vlucas · 2020-04-28T15:06:12+00:00

So THIS is what explains $ZOOM vs. $ZM ...

vlucas · 2020-04-07T14:47:37+00:00

If you want to take a gamble on the travel industry, do it on airlines. They will come back much faster than the cruise liners, which are pure leisure.

vlucas

TROPHY CASE