How to get started with Duet AI in Google Workspace
TLDRGary the Google guy introduces Duet AI in Google Workspace, focusing on its integration with Google Sheets. He demonstrates how generative AI can create content based on prompts, showcasing its use in generating an employee performance review tracker, onboarding checklist, and exit checklist. Gary emphasizes customization options, such as adding and tweaking prompts, and the creation of custom dropdowns for specific tasks. He also mentions upcoming features like data analysis and provides a list of prompts for various job roles to help users get started with Duet in Sheets.
Takeaways
- 📌 Duet AI is an add-on for Google Workspace that requires payment, not available for free Gmail accounts.
- 🔍 Once Duet is enabled, a window pane labeled 'Help me organize' appears on the right side in Google Sheets.
- 🚀 Duet AI is generative, meaning it creates content based on prompts provided by the user.
- 📝 Users can copy and paste different prompts to see how Duet AI generates content.
- 🔧 Customization is possible after the initial content generation, allowing users to tweak and add details.
- 📋 An example prompt is creating an 'Employee Performance Review Tracker', which generates a basic format for necessary information.
- 📝 Another example is an 'Employee Onboarding Checklist' with columns for task status, priority, due date, and notes.
- 📋 A third example is an 'Employee Exit Checklist', which can be further customized with additional prompts.
- 📊 Custom dropdowns can be added to the checklists, such as options for HR, Marketing, and Accounting departments.
- 💡 Users can save a bank of different prompts for future use, streamlining the process of creating documents.
- 🔮 Upcoming features for Duet AI include the ability to analyze selected data within Google Sheets.
Q & A
What is the main topic of the video?
-The main topic of the video is an introduction to using Duet AI within Google Sheets for various organizational tasks.
Who is the presenter of the video?
-The presenter of the video is Gary, also known as the Google guy.
How can one access Duet AI in Google Workspace?
-Duet AI can be accessed in Google Sheets by looking for the window pane on the right side labeled 'Help me organize' if Duet is enabled.
Is Duet AI a free add-on for Google Workspace users?
-No, Duet AI is not a free add-on. It is a paid feature that users might access through their work account or an Enterprise license.
What type of content does Duet AI generate in Google Sheets?
-Duet AI generates content based on prompts added by the user, such as creating different types of trackers and checklists.
What is an example of a prompt that can be used with Duet AI?
-An example of a prompt is 'employee performance review tracker', which generates a basic format for performance review information.
How can users customize the generated content by Duet AI?
-Users can customize the generated content by adding different chips, tweaking the format, and even creating custom dropdowns for specific columns.
What is the benefit of using Duet AI in Google Sheets?
-The benefit of using Duet AI in Google Sheets is that it streamlines the creation of various organizational tools, saving time and effort.
What is the future feature of Duet AI mentioned in the video?
-The future feature mentioned is the ability to select data and have it analyzed by Duet AI.
Where can viewers find the 10 different prompts mentioned in the video?
-Viewers can find the 10 different prompts in the description box below the video.
What is the purpose of the video's description and prompts?
-The purpose of the video's description and prompts is to help users get started with Duet AI in Google Sheets across various job roles.
Outlines
📊 Introduction to Duet AI in Google Workspace
Gary the Google guy introduces viewers to Duet AI, a generative AI tool integrated into Google Workspace, specifically within Google Sheets. He mentions that Duet AI is not a free add-on and likely requires payment through a work or enterprise account. The tool is not available on free Gmail accounts. Gary explains that once Duet is enabled, a window pane labeled 'help me organize' appears on the right side of Google Sheets, ready for users to input prompts and generate content.
📝 Utilizing Prompts for Employee Performance Review Tracker
Gary demonstrates how to use Duet AI by copying various prompts into Google Sheets to generate a generic employee performance review tracker. The generated tracker includes a basic format with columns for information typically needed in a performance review. He emphasizes that users can customize this template by adding different elements and tweaking the content as needed.
📋 Speeding Up the Process with Additional Prompts
To expedite the process, Gary pastes more prompts to generate additional templates, such as an employee onboarding checklist and an employee exit checklist. Each template comes with its own set of columns tailored to the specific use case, like task status, priority, due date, and notes. He suggests that users can create a bank of different prompts and save them for future use, allowing for easy customization and adaptation.
🔄 Customizing the Employee Exit Checklist
Gary takes the basic employee exit checklist a step further by customizing it with additional columns and options. He adds a new column labeled 'D' with a dropdown menu containing options like HR, marketing, and accounting. This customization allows for more targeted and specific data entry, showcasing the flexibility and adaptability of Duet AI within Google Sheets.
🚀 Upcoming Features and Final Thoughts
Gary concludes the video by mentioning an upcoming feature of Duet AI that will enable users to select data and have it analyzed. He encourages viewers to explore Duet AI with the provided prompts, which cater to various job roles. Gary signs off, promising more tips, tricks, hacks, and updates in future videos.
Mindmap
Keywords
💡Google Workspace
💡Duet AI
💡Generative AI
💡Prompts
💡Employee Performance Review Tracker
💡Employee Onboarding Checklist
💡Customization
💡Templates
💡Work Account
💡Enterprise License
💡Data Analysis
Highlights
Introduction to Duet AI in Google Workspace by Gary the Google guy.
Duet AI is not a free add-on and requires payment through a work account or Enterprise license.
Duet AI can be found in Google Sheets as a window pane on the right side labeled 'Help me organize'.
Generative AI will create content based on prompts added by the user.
Demonstration of creating an employee performance review tracker using Duet AI.
Customization of the generated tracker with additional chips and tweaks.
Creation of an employee onboarding checklist with task status, priority, due date, and notes.
Use of pre-made prompts to streamline the process of creating various templates.
Saving and reusing a bank of different prompts for efficiency.
Creating an employee exit checklist with generic task, due date, status, assigned to, and notes.
Elaboration on the employee exit checklist by adding a custom dropdown column for HR, marketing, accounting, etc.
Upcoming feature of Duet AI to analyze selected data.
Provision of 10 different prompts in the video description for various job roles.
Gary the Google guy encourages viewers to explore Duet AI with the provided prompts.
The video serves as a tutorial on how to use Duet AI within Google Sheets to enhance productivity.