AI Agents
AI Agents Sheets-only AI workspace hai jo bade spreadsheet tasks ke liye bana hai. Ek chhote single command ki jagah aap desired result batate hain, aur tool questions ka answer de sakta hai, data clean kar sakta hai, formatting apply kar sakta hai, formulas add kar sakta hai, ya filters set kar sakta hai, sab ek hi sidebar session me.
Kahan Milega
Section titled “Kahan Milega”AI Agents ko aap in dono surfaces se khol sakte hain:
- Sidebar: add-on sidebar kholiye, phir AI Agents expand kijiye
- Editor menu: Extensions → Text To Table Converter → 🚀 AI Agents
Apna Pehla Prompt Chalayein
Section titled “Apna Pehla Prompt Chalayein”- Google Sheet kholiye aur ek chhota test range select kijiye.
- Sidebar ya 🚀 AI Agents menu item se AI Agents kholiye.
- Sabse safe pehle run ke liye Use the selected range only enabled rakhiye.
- Ek simple prompt daliye, jaise
Standardize the text in this range. - Run par click kijiye.
- Transcript aur updated cells ko review kijiye.
AI Agents Kya Kar Sakta Hai
Section titled “AI Agents Kya Kar Sakta Hai”- Selected range ke bare me read-only questions ka answer dena
- Cleanup, standardization, extraction, categorization, ya normalization ke liye values ko rewrite karna
- Bold, text color, aur background color jaise direct formatting apply karna
- Conditional formatting rules apply karna
- Final spreadsheet pass me formulas add karna
- Value cleanup ke baad filters apply karna
- Usi active sidebar session me follow-up prompts ke sath task continue karna
Workflow Kaise Chalta Hai
Section titled “Workflow Kaise Chalta Hai”- Question-or-modify routing: read-only prompts bina sheet edit kiye answer de sakte hain
- Selection-aware scope: jab aap current selection tak kaam simit rakhna chahte hain tab Use the selected range only enabled rakhiye
- Automatic range detection: agar aap ye option band karte hain to AI Agents active sheet ka pehla main data region use kar sakta hai
- Chunked processing: bade modification jobs ek hi writeback ke badle chunks me chal sakte hain
- Guarded overwrite behavior: selected range ke bahar likhne se pehle tool pause karke confirmation mang sakta hai
- Transcript aur follow-ups: prompts aur results active sidebar session me visible rehte hain, aur jab current run chal raha ho tab second prompt queue me ja sakta hai
Key Options
Section titled “Key Options”- Use the selected range only Task ko current selection tak simit karta hai. First-time use ke liye ye recommended default hai.
- Web Search Isse tabhi on kijiye jab aapka prompt current ya external information par depend karta ho.
- Apply Formatting Bold, colors, aur emphasis jaise direct formatting changes ki anumati deta hai.
- Apply Conditional Formatting Main data work khatam hone ke baad rule-based highlighting allow karta hai.
- Apply Final Formula Pass Row-by-row edits ke baad formula-based output allow karta hai.
- Apply Filters Agent ko final range par filters create ya update karne deta hai.
Strong Prompt Patterns
Section titled “Strong Prompt Patterns”Standardize all status labels in column C to Open, In Progress, or Closed.Summarize the main anomalies in this range without modifying any values.Rewrite notes in column D to be shorter, then highlight overdue rows in red.Normalize revenue values, add a margin formula in column F, and add a filter for active accounts.
Achhe prompts teen cheezen clear karte hain:
- kya badalna hai
- kahan badalna hai
- final output kaisa dikhna chahiye
First-Time User Ke Liye Recommended Plan
Section titled “First-Time User Ke Liye Recommended Plan”- Chhote sample range se shuru kijiye.
- Use the selected range only enabled rakhiye.
- Pehle ek read-only prompt chalaiye.
- Uske baad ek chhota cleanup prompt chalaiye.
- Phir formatting ya formula-related prompts try kijiye.
- Bahut bade range par seedha jane ke bajay usi sidebar session me follow-up prompts ka upyog kijiye.
Limits Aur Notes
Section titled “Limits Aur Notes”- AI Agents sirf Google Sheets™ me uplabdh hai.
- Chat history sirf current sidebar session me rehti hai, permanent conversation log ke roop me save nahi hoti.
- Bahut bade ranges chunked processing ke bawajud model ya execution limits tak pahunch sakte hain.
- Final formula path me array-style formulas supported nahi hain.
- Agar selection-only mode enabled ho aur kuch selected na ho to run stop ho jata hai.
Troubleshooting
Section titled “Troubleshooting”- Koi selection nahi mili: range select kijiye ya Use the selected range only band kijiye.
- Koi usable data region nahi mila: active sheet me automatic detection ke liye clear main data block nahi hai.
- AI access available nahi hai: sign in kijiye aur ensure kijiye ki AI access ya subscription active hai.
- Overwrite approval manga gaya: selected range ke bahar writes allow karne se pehle warning review kijiye.
- Bada job fail ho gaya: chhote range ya zyada focused prompt ke sath phir se try kijiye.
Related Guides
Section titled “Related Guides” AI Sheet Formulas AIASK, AITRANSLATE, AIVOCAB, AITABLE, aur AIREVERSECALC jaise formulas ko seedha Google Sheets cells me use kijiye.
Sheets Mega Tools AI workflows ke sath additional Sheets cleanup, duplicate-finding, aur formatting tools ka upyog kijiye.
Language & Settings AI permissions aur anya add-on settings ko review kijiye.