81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Adventures in AI

13 Tutorials

0 seconds

Functions and Fun!
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.

Better Techniques
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.


13Tutorials

Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!
Upgrade to OpenAI's GPT 4 in your Google Sheets. And use GPT-3.5: Turbo for Powerful AI Prompt Calls! 

Learn how the new model enhances chat capabilities, including distinct messages and system prompts. Boost your productivity by integrating AI into your Google Sheets.
Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!
In this tutorial, learn how to create a ChatGPT-like interface using Google Sheets and Apps Script. Record your questions and get answers from OpenAI's GPT-3 API. Follow this step-by-step guide to build your own interactive GPT-3 interface.

  • Style a sheet like ChatGPT. Use the correct colors and interface design.
  • Add new rows to record the questions/prompts.
  • Add rows for the responses, and answers we get from OpenAI API.
Create a chat interface inside of Google Sheets using GPT-4. Insert rows as prompts get written. This sheet will help us ultimately write better prompts. We can actually tell the difference between what we're doing to get good vs bad response from the prompts.
We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.
Create a ChatGPT prompt inside a sheet, edit that prompt with a single input 100 times over. In this case we're creating a twitter thread prompt and replacing the topic 100 times. so you can use 1 prompt to run 100 ai calls, and then we go further

We make it better.

We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.

You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4
This is an attempt to create a waterfall effect in sheets. Where an AI response becomes the prompt in another ai API call.
I show you one way not to do it, that fails with onEdit() but then I do show one particular way it could work. We wrestle with AI a bit in this video and the conclusion is not so sweet.

Get the sheet below with the Apps Script and API code already written for you.
Create an epic writing tool to generate text from AI with a parade of prompts. A list of prompts you create and write that can be used over and over again. Or use this template to create your own workbook to sell a sheet of your own prompts.
Access the OpenAI API, walkthrough of the way we engineer the Apps Script so that we can play around with temperature and token length. Walk through UrlFectchApp as well and parsing JSON.
Rewrite YouTube Titles with GPT-3 API. Writes shorter, more persuasive titles I can use to increase views on YouTube. Code is included in Apps Script of sheet.
Create the Ultimate Headline Writer: Unleash the Power of Google Sheets and OpenAI's API / GPT-3.5-Turbor to Create Compelling Website Headlines. Write in different styles, using different parameters to make the ultimate headline writer for an agency or for your own business.
Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script