Here’s what to do:

For example:

Copy the prompt, go to Google Sheets and then click on Ask Gemini (up right with profile logo). After that, add the prompt.

Gemini sheets.png


The prompts:

  1. @Google Sheets – Build a 12-month financial projection model, including revenue, expenses, and profit forecasts.
  2. @Google Sheets – Create a KPI tracking dashboard for my business, with monthly and quarterly targets.
  3. @Google Sheets – Generate a lead tracking spreadsheet with columns for contact details, follow-up status, and conversion probability.
  4. @Google Sheets – Design an ad performance tracker to measure click-through rates, conversions, and ROI across platforms.
  5. @Google Sheets – Automate a sales pipeline tracker with formulas to calculate deal value and conversion rates.
  6. @Google Sheets – Build a task management system with priority levels, deadlines, and progress tracking.
  7. @Google Sheets – Generate a monthly budget planner to track income, expenses, and savings.
  8. @Google Sheets – Create an influencer outreach database, including engagement metrics and collaboration history.
  9. @Google Sheets – Develop a pricing comparison table for my competitors’ products and services.
  10. @Google Sheets – Build a customer feedback tracking system to analyze trends and pain points.