Sheets x GPT = ❤️

(Written on May 4 2025)

I've been a fan of spreadsheets for 30 years now. I'm still fascinated by their simple concept: a cell formula can use another cell's content as input. And yet, the diversity of things we can achieve with spreadsheets is astonishing. They're Turing complete, after all.

What if we could use a GPT model inside a cell formula?

Of course, this opens up a world of new possibilities. Strangely, this potential remains mostly untapped for now.

I decided to explore this as a small Sunday project. As a toy project, I created a Google spreadsheet that connects to the OpenAI API through a simple Google Apps Script.

I was shocked by how simple it was to implement and how powerful the results turned out to be.

Unlike most spreadsheets that perform calculations, this one writes letters.

Since it's spreadsheet-based, it's extremely easy to configure or transform into something else. Here's a sneak peek at how it works:

Yes, it's that simple. The GPT function only needs two inputs: a system prompt and the data it should process.

Here is the link if you want to try it by yourself: Sheet x GPT = ❤️