How to Use Gemini in Google Sheets | AI Function Tutorial, by Jotform on YouTube. 14 min 2 s.
- Video length
- 14 min 2 s
- Time to do it
- 20 minutes
- Difficulty
- Easy
- Steps
- 9
What you need
Steps
Open your spreadsheet in Google Sheets and look for the Gemini icon in the top right corner. Click it to open the side panel.
Type a prompt that describes the table you want, such as columns for campaign name, budget and status. Press Enter and review the suggested table.
Ask Gemini to format a range or write a formula in plain words, for example total the budget column. Check the formula before you accept it.
Select your data range, open Insert and choose Pivot table. Ask Gemini to suggest a pivot table layout for summarizing the data.
Use the Gemini panel to ask questions about your data, like which rows have the highest values. Read the answer and confirm it against the sheet.
Ask Gemini to build a dashboard with charts for your key numbers. Adjust the chart ranges if the suggested layout misses columns.
Type =AI followed by your prompt in a cell to generate a result directly in the sheet. Fill the formula down to apply it to more rows.
Use =AI prompts to generate sample data or clean messy entries such as names and emails. Review the output before you keep it.
Ask Gemini to find duplicate rows in your range, then delete or merge the matches it flags.
Tips and common mistakes
Always check AI-written formulas and results against a few rows by hand before relying on them.
Gemini features in Sheets may need a paid Google Workspace plan, so confirm your access first.
Keep prompts specific about column names and ranges to get more accurate answers.
Save a copy of your sheet before letting AI clean or delete data.
Questions
Do I need a paid plan to use Gemini in Google Sheets?
Gemini features in Sheets are tied to Google Workspace plans that include Gemini. Some accounts see the icon only after an admin enables it.
What does the =AI function do?
It sends a prompt from a cell to Gemini and returns the answer in that cell. You can fill it down to apply the same prompt to other rows.
Can Gemini create pivot tables for me?
It can suggest a pivot table layout and fields based on your data. You still insert the pivot table and check the result yourself.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
