How to use AI like GPT-3 in Google Sheets

In this video, learn how to use the artificial intelligence (AI) in Google Sheets with a special function that works just like the ones you know. I'll show you how to enable the Promptloop plugin - free in the app store - and how to start using it to transform text, translate, summarize text, write emails, and so much more.
To run capabilities like this demo on data without even opening up Google Sheets - sign up for an account here for free promptloop.com/welcome
This video is brought to you by [promptloop](promptloop.com), a tool that lets anyone use powerful AI models in their spreadsheets.
Web Browsing www.promptloop.com/docs/browsing
Labeling www.promptloop.com/docs/labeling
Businesses: www.promptloop.com/customers

[@ProlificOaktree]

Wow, that looks incredible. Great work.

[@SquadUp1019]

YES!!!! Thanks for getting to the point. There are SO MANY ppl who ramble on for 10+ mins for the same info.

[@promptloop4510]

Glad it was helpful!

[@SD-rg5mj]

do you think this technique also works with images

[@QuantApplicantMattKulis]

just started playing with promptloop, fun stuff , thanks!

[@oliverhill5964]

this is crazy cool. used it to clean up and transform a very old and messy customer prospecting sheet. adding this to my workflow

[@promptloop4510]

Very cool!

[@SD-rg5mj]

can it describe pictures to me?

[@daleplotzki7090]

It seems good at replicating text, but not so great at analyzing numbers, even when a rubric/description of those numbers is referenced. Any thoughts on this?

[@scrollblau2262]

Wow this is so useful!

[@SD-rg5mj]

hello does it work with images too?

[@SD-rg5mj]

bonjour j'ai pensé à utiliser l'intelligence artificielle pour me faire mes catalogues de produits pour le e-commerce , qu'est-ce que tu en penses ? en tout cas merci beaucoup de cette vidéo

[@MoatazRaafat]

Dear Peter, i made all your instructions but it keep saying complete account setup or re-active in dropdown menu to continue with credits!

[@cgc2300]

hello, does it work with gpt4 API ?

[@daCuddz]

Can you clean up messy data e.g financial projections for a business plan?🤔

[@promptloop4510]

Hey Andile! It depends what exactly the clean up task is. Excel and Google sheets actually have built in tools to do things like get rid of blank rows or auto fill info. If you’re doing something like formatting text like (PAYP-INT => “PayPal”) then PromptLoop will save you a-lot of time if it’s messy data.

[@kyleanderson1043]

Cool in theory but implementation is still lacking. Tried to take some word data and convert to actual numbers (the intent of excel / google sheets) and it just sat there and did nothing. When trying the example it worked, but it said lemons were lemons instead of yellow, lol. The Banana and Nectarine answers were correct though. Maybe we'll be at a good point in a year or two.

[@beachlife8367]

I tried the example with the fruit and got mixed results. I added the following fruits and got the corresponding results: Lemon - Yellow Banana - Yellow Nectarine - Purple Orange - Green Grapefruit - Yellow Cherry - Purple Mango - Yellow Dragon Fruit - Purple I then entered Apple again in the list and got Green instead of Red, which is what I put for the first Apple in the list and that was used to show the AI what I wanted to check by. Could I be doing this incorrectly, or is there a weakness in the system?

[@leopoldh.meinert8352]

same here, I got: Apple Red Orange Orange Kiwi Green Plum Purple Raisin Brown Lemon Neutral Banana Yellow Nectarine Peach

[@vishistakanduri5682]

tested today, Accuracy is 70% in some cases so if entries are 1000 then probably there would be at least 300 to be cross-checked

[@brandongarland1841]

when I do this, it's pulling in data from the cells above and NOT the one directly left of the prompt. Any reason why? I'm doing exactly what you are doing in the video

[@brandongarland1841]

UPDATE: Nevermind, figured it out. You just have to elminate doign stuff like "doesn't" it has to be "doesnt"

[@mr.hackathon]

It's great, does require a little cleaning up though

[@pleabargain]

Good luck!

[@haohuynh464]

Can It extract text from string ?

[@promptloop4510]

Yes - this is the sort of operation PromptLoop is great at. Just extract text from a few examples and you should be good to go!

[@SenoSbds]

This show when i try login account " Access blocked: This app’s request is invalid "

[@robertue1]

I tried to use it for inferences but it didn’t really work. Maybe it doesn’t work with Spanish.

[@valeriejackson3502]

Cut me text, how do for more characteres? " El consumo de energía de un refrigerador depende de la capacidad y características del modelo. Por lo general, los refriger....

[@promptloop4510]

Hi Valerie! The formula should not trim your text if the examples you provided are of the length you are aiming for. Would be happy to help if you want to connect here www.promptloop.com/docs/contact.

[@swankehlou]

doesnt work