Setup · 1:39
Google Labs and Sheets AI
Prompt to sheet.
- Sheets can create a whole spreadsheet from text.
- Join Google Labs.
- Enable the feature.
| Step | Action |
|---|---|
| Join Labs | Sign up |
| Enable | Sheets AI |
Do this in your own tools, step by step. Ticks are saved on this device.
Access?
Google Labs.
Feature?
Prompt to sheet.
0:00 Google Sheets could create an entire spreadsheet with just a text prompt here's a quick example then I'll show you how to get it for yourself all you have to do is put in a text prompt create a monthly budget make it as detailed as possible in this box here press create give it a second and just like that I got this template that is fully customizable all I have to do is press insert and all this right here could be customizable now let me show you how to get this for yourself for your account if you don't have it just yet and then I'll show you some other prompts that you'll find useful if you go to labs.
0:23 gooogle right here you'll see a lot of the AI experiments that Google is running right now like Google search for example also has one you could try out but this one right here is inside of Google workspace and you could go ahead and join a weight list now this is not available in every country so go to this website and join the weight list as you could see I'm already in so I got this box right over here they also have something else called Duet AI this has the same functionality but this requires you to go through an application process this is really intended right now for bigger organizations and you will basically license per seats but right now you could just go ahead and sign up for the one I just showed you from the Google Labs now once you're in you're going to get bunch of different AI capabilities they're going to be included in Google Sheets Google Slides even your Gmail is going to have ai and inside of a Google sheet document all you have to do is press right here help organize you should see this iccon as long as you have this option and you'll
1:33 get this box that I showed you so let me show you a couple of different prompts that you'll find useful so this prompt create a work expense report create rows for each week and columns for 10 expenses so you could get more detail like this now this really makes a template it's not going to yet know how to put specific numbers so if you put that in your prompt it's not going to know exactly how to do that just yet and
Get the other 1 chapters, the exam and your certificate for LinkedIn, plus all 700+ AI courses.