Draft a weekly client-margin review from logged delivery hours
At a glance
A freelancer tutorial combines spreadsheet calculations with AI summaries to identify accounts needing a scope or pricing conversation. This workflow is listed under Freelancing, Client Management.
- Agents / tools
- Jotform, Google Sheets, AI by Zapier, Gmail
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Connect Jotform, Sheets, AI by Zapier and Gmail in Zapier. In Sheets, record each client's monthly revenue, weekly hours budget, hourly delivery cost, direct weekly cost and minimum margin. 2) Create a Friday review form for client, week, hours, status, completed work, blockers and unpaid work. Send a Friday reminder and map New Submission to Create Spreadsheet Row in a separate raw-data tab. Test one submission. 3) In a calculation tab, join each response to its client's setup. Calculate weekly revenue = monthly revenue / 4.33; cost = hours × hourly cost + direct cost; margin = revenue − cost; margin percentage = margin / revenue. Flag budget and margin breaches. 4) Schedule a Friday Zap to retrieve the calculated rows and ask AI to summarize attention areas without recalculating figures. Save the result with Gmail Create Draft; review figures and wording before contacting clients.
Worth knowing
Include your own delivery time at a nonzero hourly cost. This tutorial reports no measured savings.