Get GPT-3 completion on google sheet using App script
- Open a new Google Sheet file
- Extension > Appscript
- On Project Settings, put OPENAI_API_KEY under Script Properties
- On Editor, copy paste code on
script.js
- Edit
preface
andprompt
as needed - Select
gpt3
as function to run and click Run
There are two ways:
- Use it as a custom function, e.g.
gpt3(A2)
to use A2 as input prompt - Block range, click menu GPT3 > Fill. This will use left most column as input and right most column as output.