Peter Mangan
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.
This video is brought to you by [promptloop](https://promptloop.com), a tool that lets anyone use powerful AI models in their spreadsheets.
Web Browsing https://www.promptloop.com/docs/browsing
Labeling https://www.promptloop.com/docs/labeling
Businesses: https://www.promptloop.com/customers
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….
Wow, that looks incredible. Great work.
Good luck!
Can you clean up messy data e.g financial projections for a business plan?🤔
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?
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
Can It extract text from string ?
this is crazy cool. used it to clean up and transform a very old and messy customer prospecting sheet. adding this to my workflow
It's great, does require a little cleaning up though
Dear Peter, i made all your instructions but it keep saying
complete account setup or re-active in dropdown menu to continue with credits!
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?
doesnt work
This show when i try login account " Access blocked: This app’s request is invalid "
YES!!!! Thanks for getting to the point. There are SO MANY ppl who ramble on for 10+ mins for the same info.
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.
just started playing with promptloop, fun stuff , thanks!
Wow this is so useful!
hello does it work with images too?
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
hello, does it work with gpt4 API ?