🤯I just had GPT-3 write me a JavaScript function that lets me call GPT-3 from a Google Sheets script and it works! I mean...I don't write code! Even had to ask GPT-3 what language the convoluted example was I had pulled from elsewhere 😅

Sep 21, 2022 · 12:58 PM UTC

15
62
24
592
step by step: 1. open g sheet, go to extensions > apps script 2. in script, paste this code (any & all bugs / bad things courtesy of GPT-3) justpaste.it/9mh50 - paste your API key in there 3. save script, reload sheet 4. select prompt cell & run via new nav item - boom!
3
2
2
22
UPDATE! I got GPT-3 to write me a more general purpose version of this which lets you run a function: "gpt3(PromptCell)" anywhere. PromptCell = cell with ur prompt. Here's the sheet - make a local copy, then paste your own API key - use at own risk! docs.google.com/spreadsheets…
2
1
9
Replying to @fabianstelzer
Wow. Thoughts on how this might be practically used?
1
I have a few sheets for prompt generation and wanted to automate these further But the sky’s the limit when you have sheets and gpt3 rolled in one tbh
2
Replying to @fabianstelzer
Nice, can you show the rest of the code?
3
5
yep, the whole GPT-3 output is in the alt text of this AI generated Baudrillard portrait missing bit at the end: response = _callAPI(prompt); range.offset(1, 0, 1, 1).setValue(response); }
1
1
13
more replies
Replying to @fabianstelzer
Try copy-pasting some code in practically any programming language with the prefix "Explain following code in English:" and a couple of linefeeds before the actual code. It does surprisingly well even with complex code! (And I write software for living.)
2
1
27
Yes! I had done that with solidity code before, but here It really helped me come up with a practical solution to get itself into g sheets
fabian (glif/acc)
 @fabianstelzer
22 May 2022
Wallet that uses GPT3 to give you a rough summary of what that smart contract you're about to interact with does Seems like this would be a useful security addition for @MetaMask / @rainbowdotme et al Here's what it says out of the box for a part of a minting contract:
1
19
Replying to @fabianstelzer
It seems amazing! Could you point towards a more step by step process for beginners (or if you have a thread/blog post detailing the process?) Pretty please!
1
2
fabian (glif/acc)
 @fabianstelzer
21 Sep 2022
Replying to @fabianstelzer
step by step: 1. open g sheet, go to extensions > apps script 2. in script, paste this code (any & all bugs / bad things courtesy of GPT-3) justpaste.it/9mh50 - paste your API key in there 3. save script, reload sheet 4. select prompt cell & run via new nav item - boom!
1
1
more replies
Load more