Transform Your Spreadsheets with OpenAI API and Apps Script. In this course I've tried to balance the fundamentals, foundations, and the fun. You'll have video tutorials on basic API functions, or you can copy the apps script and use it. I've kept updating the apps script as OpenAI released new models.
Look Over My Shoulder
I've also provided lectures that include you looking over my shoulder as I build something with the AI. Headline writing, YouTube Title rewriting to name a couple so far. These projects are not necessarily meant to be finished products but rather show you step-by-step how I integrate the AI api call into a sheet.
I'll be adding more tips and tricks as I develop them. And will be adding better techniques to this course on how to handle the text generated by AI.
Avoid Duplicate API Calls
For example you can see in the ChatGPT clone videos how to write AI output to a single cell reference and move all other text down by inserting a row. Doing so means that you don't have duplicate calls to the API every 10 minutes. In the original video of using AI API Calls a custom function in a cell using Apps Script will call the OpenAI API every 10 minutes. This is horrible user experience as you'll be charged for that from OpenAI. So instead of calling a custom function in a cell, use the button to trigger an apps script that can insert a row, and paste the text output to a cell, instead of a function.