How to connect Gemini to Google Sheets
You can connect Gemini to Google Sheets with the GPT for Sheets extension:
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-1.5-flash from the top model switcher dropdown. Claude is now connected to Google Sheets, and you can ask it to do tasks via the GPT functions or bulk tools.
You can use gemini-1.5-pro if you set your own API key.