Getting started

Install the add-on, open it from the Extensions menu, then try your first AI formula.

Step 1: Install from Google Workspace Marketplace

Open the marketplace listing and click Individual install: AI for Sheets .

Google Workspace Marketplace listing with the Individual install button highlighted

Step 2: Choose your Google account

Select the Google account you use with Google Sheets.

Choose an account prompt during AI for Sheets installation

Step 3: Click Continue

When Google asks you to confirm the sign-in, click Continue.

Google sign-in screen with the Continue button highlighted

Step 4: Select all permissions

On the permissions screen, click Select all.

Permissions screen with Select all highlighted

Step 5: Finish install

Scroll down and click Continue to complete the install.

Permissions screen with the Continue button highlighted

Step 6: Open it in Google Sheets

Open a Google Sheet, then go to Extensions → AI for Sheets → Use AI Formulas.

Google Sheets Extensions menu with Use AI Formulas highlighted

Step 7: Enter your first AI formula

Type this into a cell and press Enter:

=GEN("hi there")
Google Sheets with the =GEN formula typed into a cell

Step 8: Get a result

The response will appear in your cell.

Formula result shown in a Google Sheets cell with the AI for Sheets sidebar open

Tips

  • Write prompts that say exactly what you want in one sentence.
  • Use fill down to run the same prompt for many rows.
  • Not sure which function to use? See Formula reference.
  • For images or PDFs, use Upload/Download Files to generate URLs that work with =VISION and =PDF.

Was this page helpful?

Your feedback helps improve this content.