Instructions

0. Click File > Make a copy to clone this template

1. Create an account at https://openai.com/api/

2. Browse to https://beta.openai.com/account/api-keys, create a new secret key, and copy it to your clipboard

3. Click Extensions > App Script, paste your secret key where indicated, remember to save the changes

4. Type =GPT3( or =GPT3_RANGE( in any cell. Check out the examples below.

GPT3() Example

Full Name Nickname

Donald Draper ← After completing the Instructions section above, try typing: =GPT3("What is a nickname for the full name "&A17&"?")

Peggy Olson

Roger Sterling

Joan Harris

GPT3_RANGE() Example

Item Color

Apple Red

Banana Yellow

Avocado Green

Eggplant ← After completing the Instructions section above, try typing: =GPT3_RANGE($A$26:$A$28,$B$26:$B$28,A29)

Lime