No-Code Integration of ChatGPT & Google Workspaces
Dall-E Prompt "Digital Art of a liberal arts major integrating AI and Google Workspaces"

No-Code Integration of ChatGPT & Google Workspaces

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:

  1. Create a new Google Sheet.
  2. In the top menu, click on the "Add-ons" menu.
  3. Select "Get add-ons."

No alt text provided for this image
Get Add Ons

4. In the search bar, type "GPT."

No alt text provided for this image

5. Choose the add-on you'd like to use. I chose this one by gpt.space based on ratings and ease of use.

No alt text provided for this image

6. Once it is installed you enable it in the Extensions menu.

No alt text provided for this image
Remember to Enable
No alt text provided for this image
Click OK

7. Open your right-hand window by clicking in the bottom right (it's tiny) and then click on the GPT Workspace icon.

No alt text provided for this image
Show side panel
No alt text provided for this image
Conent, List, Table

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.

No alt text provided for this image
Run GPT

And here they are!

No alt text provided for this image
Best selling video games in 2018

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:

No alt text provided for this image
Bard's Results

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.

要查看或添加评论,请登录

社区洞察

其他会员也浏览了