If you quote jobs from memory or a napkin, you've probably eaten more than one job's profit without noticing until tax season. This weekend, build a job-cost tracker that a non-spreadsheet person can set up in an afternoon — using Gemini's new ability to draft a Google Sheet from a plain-English prompt, then wiring it to email you a summary every week without you touching it again.
What changed: Sheets can build itself now
Google has been folding Gemini directly into Sheets instead of leaving it as a side chat window. Two pieces matter for this project. First, Gemini can generate and edit a full spreadsheet — tabs, headers, formulas, and formatting — from a written description instead of you assembling it column by column, according to Google's Workspace announcements. Second, a feature called Fill with Gemini reads the columns you've already started and finishes the pattern for you, either from a few example rows or a typed instruction, as Google describes in its rollout notes. Availability depends on your Workspace or personal Google AI plan, so check whether Gemini shows up in your Sheets toolbar before you start. If it's not there yet, everything below still works by hand, just with more typing.
Step 1: Draft the tracker with one prompt
Open a blank Sheet, open the Gemini panel, and describe the tracker instead of building it cell by cell. Something like:
Build a job-cost tracker with one row per job. Columns: job name, customer, start date, materials cost, labor hours, labor rate, total cost, quoted price, and profit. Add a summary tab that totals cost and profit by month.
Gemini will draft the headers, the formulas linking labor hours and rate to a labor cost column, and a rollup tab. Don't trust it blindly — click into the formula bar on a couple of cells and confirm total cost is actually adding materials and labor, and that profit is quoted price minus total cost, not the other way around. That's the same habit as checking a subcontractor's math: fast to do, expensive to skip.
Step 2: Let Fill with Gemini finish the boring columns
Once the structure exists, populate a few real rows yourself — two or three finished jobs, with real numbers. Then select the empty cells below and use Fill with Gemini (drag the fill handle, or use the Fill button and type an instruction) to extend patterns, like rounding labor cost to the nearest dollar or writing a one-line job description from a customer name and job type. It's built for exactly this kind of repetitive column-filling, per Google's help documentation — you're teaching it your format with real examples instead of describing rules from scratch.
Step 3: Have it email you every Monday
A tracker you have to remember to open doesn't get used. Add a small Apps Script that reads last week's rows and emails you a summary automatically. In your Sheet, go to Extensions > Apps Script and paste something like:
function weeklyJobSummary() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Jobs');
const data = sheet.getDataRange().getValues();
const oneWeekAgo = new Date();
oneWeekAgo.setDate(oneWeekAgo.getDate() - 7);
let totalProfit = 0;
let jobCount = 0;
const lines = [];
data.slice(1).forEach(row => {
const [job, customer, startDate, , , , , , profit] = row;
if (startDate instanceof Date && startDate >= oneWeekAgo) {
totalProfit += Number(profit) || 0;
jobCount++;
lines.push(job + ' (' + customer + '): profit ' + profit);
}
});
const body = jobCount
? jobCount + ' jobs this week.\n\n' + lines.join('\n') + '\n\nTotal profit: ' + totalProfit
: 'No jobs logged this week -- check the tracker.';
MailApp.sendEmail('you@yourbusiness.com', 'Weekly Job Summary', body);
}
Then click the clock icon (Triggers) in the Apps Script editor, add a new trigger for weeklyJobSummary, set it to time-driven, and choose a weekly schedule. Adjust the column positions in the destructuring line to match wherever your own columns landed — Gemini's draft won't always match this exact order.
Where this earns its keep
- Underpriced jobs show up fast. A weekly email that lands whether you look or not catches the job that quietly lost money before it becomes a pattern.
- No new software to manage. This lives in a tool you already have open, so there's no login to remember or subscription to justify.
- It's a starting point, not a system of record. For real accounting, keep using your bookkeeping software — this tracker is for the gut-check, not the tax return.
Total build time is under two hours, most of it spent double-checking that Gemini's formulas match what you actually meant. That checking step is the whole point: the tool drafts fast, but you're still the one who signs off on the math.