Google Sheets QUERY and ARRAYFORMULA with Gemini: prompts, formulas and checks
AI-generated summary Gemini in Google Sheets generates formulas from plain-English requests and attempts repairs on errors when users have an eligible plan and smart features turned on. Google states that conversation history in the side panel is lost upon browser reload or when closing the file, and content added by Gemini may be visible outside the domain.