Skip to content
UsecaseBoard
← All use cases
indiehackersFreelancing

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.

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.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →