How do I open Sheet Agent?
- In Google Sheets, go to Extensions → AI for Sheets → Sheet Agent.
- Or open Use AI Formulas and switch to the Agent tab in the sidebar.
How do I ask better questions?
Prompts that work well
- What are the top 3 trends you see in this sheet?
- Summarize this table into 5 bullet points for a weekly update.
- Find anomalies and explain what might have caused them.
- Create a short executive summary and list recommended next actions.
Can I insert results back into my sheet?
Yes. If the Agent returns a table, you can use the Insert button to paste it into the sheet at your active cell.
Can I attach images or PDFs?
Yes. In the Agent sidebar, use the file attachment button to add an image or PDF, then ask questions about it.
Frequently Asked Questions
Does Sheet Agent cost more usages?
Yes. Sheet Agent calls are higher cost than most formulas. If you are optimizing for cost, use formulas like =ANALYZE and =GEN for smaller, targeted tasks.
What if my sheet is too large?
Try asking a narrower question, using fewer columns, or splitting work into smaller tabs. If you see a data size error, reduce the amount of data you are analyzing.
Where can I learn the formulas?
See Formula reference for examples of =GEN, =ANALYZE, =VISION, and more.