For Email Marketing Specialists ·
From your ESP, export campaign performance data as CSV. Most ESPs export a format like:
| Campaign Name | Send Date | List Size | Delivered | Opens | Unique Opens | Clicks | Unique Clicks | Unsubscribes | Revenue |
|---|
Import to Google Sheets: File → Import → Upload CSV → Import data.
Instead of looking up formula syntax, describe what you want in plain English:
Examples:
"Add a column that calculates open rate as a percentage (unique opens / delivered)"
→ Gemini writes: =IFERROR(E2/C2*100, 0) and explains what it does
"Calculate the average open rate for campaigns sent on weekdays vs. weekends"
→ Gemini writes a more complex formula using AVERAGEIF with day-of-week conditions
"Highlight cells in column F where click rate is below 2% in red"
→ Gemini walks you through setting up conditional formatting with the right range and condition
What you should see: The formula appears in the cell you selected, with a plain-English explanation. You can ask follow-up questions ("what does the IFERROR part do?") to understand the formula before using it.
Google Sheets' Smart Fill detects patterns and automatically continues them:
Use this for: extracting dates, cleaning inconsistent campaign name formats, converting ESP-formatted data to your standardized format.
With your full dataset populated and formulas added:
"Looking at my campaign data, which day of the week has the highest average open rate?"
"Do campaigns with subject lines under 40 characters perform better than those over 40 characters?"
"What were the top 5 and bottom 5 performing campaigns this quarter and what do they have in common?"
Gemini reads your spreadsheet data and responds with analysis. For pattern questions, it often generates charts automatically.
"Write a 3-paragraph executive summary of our email performance this quarter based on this data.
Highlight: overall vs. benchmark performance, best campaign, worst campaign, and one recommendation."
Gemini reads the data and writes the narrative. Copy it into your report or email.
Gemini in Sheets availability depends on Google Workspace plan. Basic formula generation may work with a standard Google account; advanced analysis features typically require Workspace Business or Google One AI Premium.