How to Use ChatGPT with Any Google Spreadsheet
Automating everyday manual tasks has been one of the highest-leverage productivity hacks I've found for LLMs. Nowhere have I seen more manual tasks than in spreadsheets (I even cofounded a company to help save biotech accountants from some of this manual work).
One of my favorite applications is using OpenAI's GPT API directly inside of Google Sheets. I find it's helpful to quickly ask the same question, do customized template generation, or clean up text on 100+ different cells of data all at once e.g. "Can you give me the city and state for each of these people based on their bios in the format city, state e.g. Boston, MA?"
You can now type in =GPT(reference 1, reference 2, ...) as a formula into any spreadsheet cell just like you, just like any other Google Spreadsheets function.
The function can take any number of references that are either strings of text (e.g. "Here's an example string." or a reference to a cell e.g. A1. It will append all the strings together, send them to OpenAI's API, and return the result response.
