Skip to content

A simple no-code solution for integrating OpenAI's GPT language models into your google sheets documents using Apps Scripts

Notifications You must be signed in to change notification settings

Lane-G-Smith/ChatGPT-Google-Sheets-Apps-Script

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 

Repository files navigation

ChatGPT-Google-Sheets-Apps-Script


Apps Scripts

Simple code snippets for integrating OpenAI's GPT language models into your Google Sheets documents using Apps Script.

!!!Davinci3 is now deprecated!!!

ChatGPT-Google-Sheets-Apps-Scripts installation instructions

Go to OpenAI and set up an account

https://platform.openai.com/signup

IMPORTANT!! Scripts do not protect secret API keys, do not share GPT-enabled documents

Open a new document in Google Sheets, click Extensions / Apps Script

Push the + button near the top left and choose Script to create a new script

Clear the page, then copy and paste code from the desired model js file to Script

Place your secret OpenAI API key between quotation marks at the top of the page where it says SECRET_API_KEY_HERE

Each function calls a different AI model and can be called using the KEYWORD immediately following the word "function" in line 4 (GPT-4, TURBO, Davinci3)

Use the new functionality by typing =KEYWORD("your prompt to GPT will go here") and pressing enter

For GPT-3.5 models fill in the prompt at line 9,10,11 to specify desired functionality

About

A simple no-code solution for integrating OpenAI's GPT language models into your google sheets documents using Apps Scripts

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published