To use Duet AI in Google Sheets, follow these simple steps to unlock its powerful features like smart autofill, formula suggestions, data categorization, and even natural language queries.
✅ What Is Duet AI in Google Sheets?
Duet AI is Google Workspace’s generative AI assistant that helps automate and enhance spreadsheet tasks using machine learning and natural language prompts. Think of it as your built-in data expert.
🚀 How to Use Duet AI in Google Sheets
1. Check Eligibility
Duet AI is only available in:
- Google Workspace Labs (for early testers)
- Duet AI-enabled Google Workspace plans (like Business Plus, Enterprise, or Education Plus)
📝 You need admin access or an account that supports Duet AI to use it.
2. Enable Duet AI
If you’re eligible:
- Open Google Sheets
- Click on Tools > Help me organize (Duet AI panel opens)
- Or click on the Duet AI (sparkle wand) icon in the toolbar
If you don’t see this:
- You may need to ask your Workspace admin to enable Duet AI
- Or sign up via Google Workspace Labs
3. Use “Help Me Organize”
This Duet AI tool generates a custom table for you:
- Click “Help me organize”
- Type your prompt (e.g., “Create a content calendar for YouTube uploads”)
- Hit Create — Duet AI will auto-generate a table
- You can revise or insert it directly into your sheet
4. Use Natural Language for Formulas
Duet AI allows you to write formulas in plain English.
🧠 Example:
- Type: “Sum of sales where region is West”
- Duet AI converts it into:
=SUMIF(B2:B100, "West", C2:C100)
This is a huge time-saver if you’re not confident with functions.
5. Smart Autofill
Duet AI predicts and fills data based on patterns it detects in your sheet.
➡️ Example:
- Enter a few rows of emails, job titles, or dates.
- Select the range → Right-click → Autofill using Duet AI
6. Use “Help Me Write” (Optional)
Though more common in Docs, some Workspace users can access Duet AI’s “Help me write” directly in Sheets—especially for descriptions, email drafting, or notes within cells.
📊 Example Use Cases
| Task | Duet AI Feature | Benefit |
|---|---|---|
| Creating templates | Help Me Organize | Saves time |
| Building formulas | Natural Language Formula | No need to remember syntax |
| Data entry | Smart Autofill | Increases accuracy & speed |
| Reporting summaries | Help Me Write (in cells) | Adds context automatically |
| Categorizing raw data | Smart suggestions | Easy data organization |
🔗 Related Links
🙋♀️ FAQs
❓ Is Duet AI free?
No. Duet AI is part of premium Workspace tiers, and not included in standard Gmail accounts.
❓ Can I use it on mobile?
Not yet. Duet AI is currently only available on desktop versions of Google Sheets.
❓ Is my data private?
Yes, per Google, your prompts and data are not used to train public models.
🔚 Final Thoughts
Duet AI in Google Sheets is like having a mini data analyst at your side. Whether you’re a beginner or a pro, it simplifies tasks like table creation, data organization, and formula writing — all with a simple prompt.