Freelancers & Consultants7 min readUpdated Oct 14, 2026

How to Turn Project Overruns Into Better Pricing Rules for Your Next Client With NotebookLM

Review scope, time logs, revisions and client requests to improve future pricing and contract rules, with the math checked outside Gemini Notebook.

NotebookLMpostmortempricingscope controlfreelancersconsultants

Workflow summary

Quote this workflow accurately

Markdown version
Best for
Operators who need a repeatable, practical workflow instead of a blank prompt.
Input
The original signed scope, proposal or statement of work and fee assumptions. Estimated hours, actual time logs, approved change orders, client requests and direct costs. Gemini Notebook access with permission to proc...
Primary tool
NotebookLM
Output
Review scope, time logs, revisions and client requests to improve future pricing and contract rules, with the math checked outside Gemini Notebook.
Main risk
The review blames the client rather than the process. Ask what the original quote failed to constrain or price, and what communication checkpoint could prevent a repeat.
Verification step
Scope, revisions and client approvals are traced to actual records. Hourly variance, percentages, costs and project margin reconcile with the original spreadsheet. An expanded client scope is not mislabeled as bad est...

Continue from this article

The problem and who this is for

When a freelance project consumes more work than expected, the useful outcome is not another retrospective memo. It is a changed quoting rule that prevents the same mistake next time. This workflow is for freelancers, consultants and small service firms with one recent project, a signed scope, tracked hours and a record of revisions or delays.

Google renamed NotebookLM to Gemini Notebook on July 16, 2026. This article retains its established NotebookLM title and URL so existing links continue to work, but uses the current product name in the instructions. The core workflow remains source-grounded and still requires human checking.

Prerequisites

  • The original signed scope, proposal or statement of work and fee assumptions.
  • Estimated hours, actual time logs, approved change orders, client requests and direct costs.
  • Gemini Notebook access with permission to process client documents, or a safer approved alternative.
  • A spreadsheet tool to validate arithmetic and calculate the financial effect independently.
  • The quote or contract template you intend to improve.

Data and permission check: Only upload materials your organization has authorized for the specific Google account and workflow. Remove unnecessary personal details and do not assume a personal Google account has the same protections as an organization-managed Workspace account. A privately shared notebook can expose its uploaded sources to viewers, so keep sharing restricted and do not send a notebook link as a substitute for a final approved document.

How to gather source material

  1. Export the original scope and price assumptions as a PDF. Find the original breakdown, not a revised quote created after the overrun.
  2. Export time logs or task records as CSV or Google Sheets with categories such as initial work, revisions, waiting, client changes and rework.
  3. Collect documented change requests and decisions from email or project tools, removing unrelated personal data and confidential client information you lack permission to upload.
  4. Summarize the final invoice and approved extras. Keep a clear distinction between billed revenue, time spent, direct costs and fees waived.
  5. If key decisions exist only in Google Docs comments or footnotes, copy them into a separate dated record because Google says they are not imported as notebook source content.

Step-by-step workflow

  1. Set the analysis boundary. Choose one completed project or one comparable project class, and confirm your right to process the documents.
  2. Create a source notebook. Upload the original scope, exported time logs, change history and outcome summary. Google documents support for CSV and Google Sheets, but spreadsheet imports have limits. Use clean files with stable headers and dates.
  3. Ask for evidence-backed causes. Request a comparison of estimated work versus actual work and a list of changes that caused extra effort. Separate missed estimates, additional client scope, internal rework, waiting time and other causes.
  4. Check the math in a spreadsheet. Confirm the original estimated hours, actual hours, billed revenue and labor or direct costs. Calculate hour variance = actual hours - estimated hours; calculate hour overrun percentage = (actual hours - estimated hours) / estimated hours x 100, only when estimated hours is greater than zero. Keep profit margin (profit / revenue) distinct from markup (profit / cost).
  5. Write at most three new rules. Ask for one or two pricing controls and one scope-control clause, each with a concrete trigger and an action the business can implement in future proposals.
  6. Test a rule against a real example. Apply the proposed rule to the reviewed project. Would it have changed the quote, exposed an unpriced revision, or triggered a change order? If not, tighten it.
  7. Update the quote template. Put the accepted rules, revision limit language, exclusions, and approval steps in the next proposal. Get appropriate business or legal review for binding contract language.

Primary tool instructions: Gemini Notebook

Gemini Notebook is useful for source tracing and extracting patterns, not for accepting unverified pricing calculations. Use a web notebook with selected scope, time-log, and correspondence sources. Ask for evidence references to each overrun cause. A custom Data Table may help you map scope and revision changes; export it to Sheets when available, then check formulas and original values in the spreadsheet.

For larger or numeric-heavy logs, analyze the time data in your spreadsheet first and import a validated summary rather than trusting a model to recompute the whole ledger. Code-execution features and usage limits vary by account, so this workflow does not depend on paid model capabilities.

Alternative tool instructions

If Gemini Notebook is not approved for client files, perform the calculations directly in a spreadsheet and use your existing authorized document tool to review a sanitized closeout memo. The outcome is the updated quote rule, not a special AI artifact.

Copy/paste prompt for Gemini Notebook

{
  "task": "Audit one completed client project and draft practical pricing and scope rules for future proposals",
  "inputs": [
    "Signed original scope and quoted fee",
    "Actual time logs and direct-cost records",
    "Change orders, revision history and relevant client correspondence",
    "Documented results and lessons from project closeout"
  ],
  "constraints": [
    "Use only selected records and cite source filenames for causes.",
    "Distinguish excess hours from monetary loss and client-requested scope additions from estimating errors.",
    "Do not invent a standard markup, hourly rate, contingency, schedule, contract clause or project margin.",
    "When data is missing, state Cannot determine and identify the missing records.",
    "Propose at most three reusable pricing or scope controls, with exact situations that trigger them.",
    "Draft sample language as a proposal template for human review, not legal advice."
  ],
  "output": {
    "original_scope_and_assumptions": "source-backed summary",
    "overrun_causes": "evidence with confidence or uncertainty",
    "numbers_to_verify": "quoted fee, estimated hours, actual hours, direct cost, realized revenue",
    "future_rules": "no more than three testable rules",
    "proposal_clauses": "plain-language placeholders for attorney or business review",
    "owner_actions": "specific changes to quotation template"
  }
}

Quality checks

  • Scope, revisions and client approvals are traced to actual records.
  • Hourly variance, percentages, costs and project margin reconcile with the original spreadsheet.
  • An expanded client scope is not mislabeled as bad estimation if it was separately approved and billed.
  • The recommended rules specify what changes, when it changes, and who must approve it.
  • The quote template actually gets updated and tested on a later proposal.

Common failure modes and fixes

The review blames the client rather than the process. Ask what the original quote failed to constrain or price, and what communication checkpoint could prevent a repeat.

Some time logs are missing. Present ranges or Not established, not invented precision.

The model confuses markup with margin. Recalculate from revenue and cost using the correct denominators in a spreadsheet.

The rule is just 'charge more'. Rewrite it as a defined revision limit, a change-order trigger, or a clearly scoped contingency calculation grounded in actual project history.

Tools Used

  • Gemini Notebook, formerly NotebookLM: /go/notebooklm

Check affiliate disclosure before using any redirect as an affiliate link.

Sources Checked

  • Google, NotebookLM is now Gemini Notebook (July 16, 2026): https://blog.google/innovation-and-ai/products/gemini-notebook/notebooklm-gemini-notebook/ (accessed 2026-10-14).
  • Google Help, Add or discover new sources for your notebook: https://support.google.com/gemininotebook/answer/16215270?hl=en (accessed 2026-10-14).
  • Google Help, Create a notebook in Gemini Notebook: https://support.google.com/gemininotebook/answer/16206563?hl=en (accessed 2026-10-14).
  • Google Workspace Help, Gemini Notebook account and data handling: https://support.google.com/gemininotebook/answer/16337734?hl=en (accessed 2026-10-14).
  • Google Workspace, Generative AI privacy and data handling: https://knowledge.workspace.google.com/admin/generative-ai/generative-ai-in-google-workspace-privacy-hub (accessed 2026-10-14).
  • Google Help, Sharing notebooks and viewer access: https://support.google.com/gemininotebook/answer/16322204?hl=en (accessed 2026-10-14).
  • Google Help, Import and update Google Drive sources, including comment limitations: https://support.google.com/gemininotebook/answer/16215270?co=GENIE.Platform%3DDesktop&hl=en (accessed 2026-10-14).
  • Google Help, Manage Gemini Notebook usage limits: https://support.google.com/gemininotebook/answer/17670842?hl=en (accessed 2026-10-14).

Quarterly Refresh Flag

Review by 2027-01-12. Verify Google product names, source formats, Drive syncing, notebook sharing and data policies, and the workflow-specific claims before the next article refresh.

Something off in this workflow?

Related Workflows

How to Turn a Discovery Call Recording Into a Fixed-Price Quote With NotebookLM

Use a recorded discovery call, a cleaned transcript, and NotebookLM to draft a fixed-price quote that spells out scope, assumptions, and exclusions before the project starts.

Read Workflow

How to Decide Whether a Client Project Should Be Hourly, Fixed Fee, or Retainer With AI

Use AI to sort a new client request into the right pricing model by looking at scope clarity, revision risk, cadence, and dependency load before you quote.

Read Workflow

How to Reply When a Client Tries to Add Work That Was Not in Scope With AI

Use an email thread and your original scope to draft a calm, professional reply that separates in-scope work from added work before you absorb free extras.

Read Workflow
Reader Feedback

Help keep PromptedWork sharp

Share a broken step, outdated prompt, or general feedback. This is only for improving this specific workflow.