Dima Kuchin kuchin
kuchin
/ GPT4_sheets.js
Last active
January 24, 2024 16:55
— forked from CharlyWargnier/GTP3_script_for_sheets.txt
A script to integrate GTP3 in Google Sheets
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Demo: https://twitter.com/shubroski/status/1587136794797244417 | |
| // To use it, insert your API key below, open Google Sheets -> Extensions -> Apps Script -> Copy & Paste this -> Save | |
| // Usage: =GPT4(prompt) or =GPT4_RANGE(examples_input_range, examples_output_range, input_cell) | |
| const OPENAI_API_KEY = ""; // <- PASTE YOUR SECRET KEY HERE | |
| const OPENAI_CHAT_API_URL = "https://api.openai.com/v1/chat/completions"; | |
| const OPENAI_MODEL = "gpt-4-1106-preview"; | |
| const OPENAI_MAX_TOKENS = 256; | |
| /** |