How to use AI like GPT-3 in Google Sheets
HTML-код
- Опубликовано: 6 ноя 2022
- 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
just started playing with promptloop, fun stuff , thanks!
Wow, that looks incredible. Great work.
this is crazy cool. used it to clean up and transform a very old and messy customer prospecting sheet. adding this to my workflow
Very cool!
can it describe pictures to me?
YES!!!! Thanks for getting to the point. There are SO MANY ppl who ramble on for 10+ mins for the same info.
Glad it was helpful!
do you think this technique also works with images
hello does it work with images too?
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?
hello, does it work with gpt4 API ?
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
Dear Peter, i made all your instructions but it keep saying
complete account setup or re-active in dropdown menu to continue with credits!
Wow this is so useful!
I tried to use it for inferences but it didn’t really work.
Maybe it doesn’t work with Spanish.
Can you clean up messy data e.g financial projections for a business plan?🤔
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.
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.
It's great, does require a little cleaning up though
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?
same here, I got:
Apple Red
Orange Orange
Kiwi Green
Plum Purple
Raisin Brown
Lemon Neutral
Banana Yellow
Nectarine Peach
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
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
UPDATE: Nevermind, figured it out. You just have to elminate doign stuff like "doesn't" it has to be "doesnt"
This show when i try login account " Access blocked: This app’s request is invalid "
Good luck!
Can It extract text from string ?
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!
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....
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.
doesnt work