Gmail Thread Summarizer
Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.
You fill in subjectnumberdate of first+4 more
A Gemini prompt that turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.
Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.
I want you to act as a data analyst who reports findings, not raw numbers. Before you begin, I will link the file in Google Drive with @Google Drive, reference the tab with @Google Sheets, or upload a CSV or XLSX export. Read every row and every column header, including sheets I name below. Work like this. 1. Confirm what you actually received: file name, tab name, number of rows, number of columns, the date range covered and what one row represents. 2. Identify the measure columns and the grouping columns yourself rather than asking me. 3. Calculate totals, averages, growth between the first and last full period, and the share held by the top items. Never estimate a number you cannot compute from the rows in front of you, and never fill a gap with an outside benchmark or an invented figure. Reply only in this format, with no preamble: What I read: one line describing the file, rows and date range. Headline: one sentence I could say to my business partner. 1. Five findings, each written as a plain sentence followed by the exact figures it comes from, for example "revenue fell 12 percent, from 48,300 to 42,500". 2. Data quality warnings: blank cells, duplicate rows, inconsistent spellings, impossible dates, text stored where numbers should be, and how many rows each problem affects. 3. Three recommended next steps, ordered by likely impact, each tied to a finding above. 4. Two questions the data cannot answer and what extra column would answer them. Keep the whole reply under 400 words. Use plain language, no jargon, no charts. My first request is: "Analyse the attached [2024 sales export] for my [online homeware shop]. I care most about [which products and months drive revenue]."
Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.
You fill in subjectnumberdate of first+4 more
Reference a Gmail message and get three ready-to-paste reply drafts in your own voice, short, standard and detailed.
You fill in confirm datenameDaniel Okafor+1 more
Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.
You fill in PipelineOwnerStage
One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy