No-Code Integration of ChatGPT & Google Workspaces
Vincent Kovar
Hands-on, omni-channel Marketing leader in blockchain (native), gaming, AI and other emerging tech. Focus on growing high-performing team cultures |Open to Global Relocation
I am not a coder and am often frustrated by so-called "no-code" step-by-step instructions. So, using myself as a test, I am asking various AI to give me absolutely no-code instructions on various tasks.
This time out, I asked both Bard and ChatGPt how to integrate themselves with Google Sheets (as well as? Docs, and Slides).
Bard provided detailed instructions on connecting APIs but I discovered early on (step 4, below) that Bard was also lying to me. I'm sure it wasn't personal. He's young. When I typed "Bard" into the search line, it came back with only GPT results and I was unable to continue along Bard's suggested path.
However, ChatGPT gave me the instructions below and didn't require any API connections or such. It was truly no-code and easy entry for people like me. So, if you're looking for the easiest (and human tested) way to connect ChatGPT with Google sheets, here it is:
4. In the search bar, type "GPT."
5. Choose the add-on you'd like to use. I chose this one by gpt.space based on ratings and ease of use.
6. Once it is installed you enable it in the Extensions menu.
领英推荐
7. Open your right-hand window by clicking in the bottom right (it's tiny) and then click on the GPT Workspace icon.
8. Choose your task (I chose Create Table) and enter a prompt. I asked for a list of the top ten selling video games in 2018 and their revenues.
And here they are!
However, be cautious. When checking these figures against other sources for 2018, there were differences not only between various online rankings but also other AI. For instance, Google's Bard came back with:
Next time, I'll try Bard's instructions again and see if the add-ons have actually been added.
In the meantime, check out the gpt.space's developer’s prompt guide: https://docs.google.com/spreadsheets/d/16ZY7l8kpu5niTUIOReQRExKFfYbh0GMQYnav4Nn_w5k/edit#gid=0 or the highly rated alternative Sheets Genie.