Create and Refine Template Prompts
1. Create and Refine Template Prompts
In this demo, you explore improving your template prompts by providing additional details. You learn how to: Create a prompt. And refine a prompt to improve the result. First, create a template by using Gemini in Sheets Suppose you work in customer service and noticed a lot of customers are calling in about the same issue. They are all experiencing loading delays or complete freezes on different webpages on the company website. You want to track this information for the product team. Open Sheets and open a new blank spreadsheet, then select Help me organize. In the text input, type the prompt. In this case, you can choose: "Track how long customers are stuck on a webpage." Click Create. You might need to wait several seconds for Gemini to generate a response. Now, refine the prompt You notice that the template tracks duration, but you also want to track whether the customer is still stuck on the webpage or if the new page eventually loaded. Before refining a prompt, remember that you will lose your current output if you input a new prompt. For this reason, it is best to consider whether the generated template meets your needs. If it completely misses what you are looking for, you can refine your prompt and generate a new template. If you like aspects of the template, click Insert to add the template to your spreadsheet. Then you have two choices. You can simply edit the spreadsheet yourself, or you can refine your prompt and generate a new template. To refine the prompt, open Help me organize again and enter your new prompt. Edit the prompt so that it provides more details on your desired template. The new prompt can be: "Track how long customers are stuck on a webpage and if they are still stuck." Then, click Create. You can now see that there is another column that gives options for the status of the issue: Stuck or Not Stuck. Lastly, insert and edit your template After you are happy with the result, you can insert the template. A pop-up will appear. It will ask if you prefer to overwrite the current data or to insert your template in a new sheet. Overwriting will delete existing data on your sheet. Choose Overwrite data. After it is inserted in your spreadsheet, you can make additional edits. For example, you might want the user column to track customer emails instead of customer IDs. You also might want to add a column tracking the name of the support agent who helped the customer. All of these edits can be made as usual by using your Google Sheets tooling.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.