How to connect Gemini to Google Sheets
You can connect Gemini to Google Sheets with the GPT for Sheets add-on:
Step 1: Install the GPT for Sheets and Docs add-on
Install from the marketplace: https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Step 2: Launch GPT for Sheets and Docs
In a Google spreadsheet, go to Extensions > GPT for Sheets and Docs > Open
Step 3: Use Gemini in Google Sheets
Select gemini-2.5-flash from the top model switcher dropdown. Gemini is now connected to Google Sheets, and you can ask it to do tasks via the sidebar with the Agent or the bulk tools, or use GPT functions.
You can use gemini-2.5-pro and other Gemini models if you set your own API key.