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
prefaceandpromptas needed - Select
gpt3as 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.
