AI Prompts for Gemini for Google Sheets

Write a Google Sheets formula that [DESCRIBE WHAT YOU WANT TO CALCULATE]. My data is in [COLUMNS/ROWS]. I want the result in [TARGET CELL OR COLUMN].

I need a formula to look up [VALUE] from [COLUMN A] and return [VALUE] from [COLUMN B] when there is a match. Use the most appropriate lookup function for this case.

Write a formula that sums [COLUMN] only when [CONDITION, E.G., THE VALUE IN COLUMN B EQUALS "PAID" AND COLUMN C IS GREATER THAN 100].

I want to flag rows where [CONDITION, E.G., THE DATE IN COLUMN A IS MORE THAN 30 DAYS OLD AND COLUMN C IS BLANK]. Write a formula that returns "Yes" or "No" based on this condition.

Explain what this formula does and rewrite it to be more readable: [PASTE FORMULA]. If there is a simpler approach that produces the same result, suggest it.

I have this spreadsheet data: [DESCRIBE STRUCTURE OR PASTE SAMPLE]. Help me identify: trends, outliers, and the key insights a decision-maker would want to know.

My data has these quality issues: [DESCRIBE ISSUES, E.G., DUPLICATES, INCONSISTENT FORMATTING, MISSING VALUES]. Write the formulas or steps to clean each problem.

I need to split [COLUMN WITH COMBINED DATA, E.G., "FIRST LAST" OR "CITY, STATE"] into separate columns. Write the formula for Sheets.

Write a formula to remove duplicates from [RANGE] and return a unique list. I need this as a formula, not the built-in Remove Duplicates tool.

Summarize this dataset for me: [PASTE DATA OR DESCRIBE STRUCTURE AND SAMPLE]. What are the totals, averages, and top/bottom performers by [DIMENSION]?

I want to build a pivot table from this data: [DESCRIBE DATA STRUCTURE]. I want to see [DESCRIBE WHAT YOU WANT TO ANALYZE, E.G., TOTAL SALES BY REGION BY MONTH]. Walk me through the setup.

Design a dashboard layout for tracking [WHAT YOU ARE MEASURING, E.G., WEEKLY SALES PERFORMANCE]. What metrics should I show, how should I structure the sheet, and what chart types work best for each metric?

I have this raw data and I need a summary table that shows [DESCRIBE SUMMARY]. Write the Sheets formulas to build it dynamically so it updates when I add new rows.

What chart type should I use to show [DESCRIBE YOUR DATA AND WHAT YOU WANT TO COMMUNICATE]? Build it in Sheets and recommend the right settings.

Write an Apps Script function to [DESCRIBE AUTOMATION, E.G., EMAIL ME A SUMMARY OF THIS SHEET EVERY MONDAY MORNING / HIGHLIGHT ROWS WHERE COLUMN D IS OVERDUE].

Write a Google Apps Script that [DESCRIBE AUTOMATION: SENDS AN EMAIL WHEN A CELL IN COLUMN B CHANGES TO "DONE" / CREATES A NEW ROW WHEN A FORM IS SUBMITTED / IMPORTS DATA FROM ANOTHER SHEET].

I want to automate this manual process in Google Sheets: [DESCRIBE THE PROCESS]. What is the best approach: formulas, macros, or Apps Script? Walk me through the implementation.

Write a script to format this sheet automatically: [DESCRIBE FORMATTING RULES, E.G., ROWS WITH STATUS "OVERDUE" SHOULD BE RED, ROWS WITH "COMPLETE" SHOULD BE GREEN].

I have [N] sheets with the same structure that I want to consolidate into one master sheet. Write an Apps Script to combine them and add a column identifying the source sheet.

Create a custom function in Apps Script that [DESCRIBE WHAT IT SHOULD DO]. I want to call it from a cell like =MYCUSTOMFUNCTION(arg1, arg2).