Members-only tutorial

Watch the video and get the practice sheet with membership.

Unlock tutorials

Create a ChatGPT Cheat Sheet Spreadsheet

Intermediate

About this Tutorial

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

Sheet Resources

Apps Script APIs used

SpreadsheetApp UrlFetchApp

Apps Script methods used

.getActiveSpreadsheet() .getRange() .getSheetByName() .getValue() .fetch() .getContentText()

Featured Formulas

CONCATENATE() COUNTIF() IF() ISBLANK() LEN() SUBSTITUTE() SWITCH()

Video Transcript

This tutorial has no transcript yet.

Courses

Adventures in AI

Quickstart Tutorial OpenAI API in Google Sheets

Upgrade Google Sheets OpenAI Prompt to GPT 4

Perfect Use of AI in Google Sheets (Categorize Tasks)

How to Create AI Images From Google Sheets

Make AI-generated Poems Based on Name

Quickly Integrate AI and Google Sheets

Saving OpenAI API Calls inside of Google Sheets

Build Your Own AI Writer in Google Sheets

Fast FAQS

Created a GPT function in Sheets

Spreadsheet Automation for Beginners

Ultimate Prompt Writer and Prompt Rater

ChatGPT Clone in Google Sheets Part 1

Mr. Beast Renamed My YouTube Titles

I Built a SEO Meta Description Writer

Create a Waterfall of AI Prompts and Responses

ChatGPT Clone in Google Sheets Part 2

Run 100 ChatGPTs at One Time

Prompt Parade

Building an AI Prompts Playground

YouTube Title Rewriter with GPT-3

Ultimate Headline Writer with GPT in SHEETS

Create a ChatGPT Cheat Sheet Spreadsheet

Topics

Google Apps Script - Custom Functions in Google Sheets

Build Your Own Tools

Write More