← All use cases

Use case B15 · Business

Lawn-care owner uploads CRM production data to ChatGPT to price aeration and overseeding

Cory Overman, owner, Shades of Green (via Lawn & Landscape) ·

The short version

What they did

To set prices for aeration and overseeding, Overman uploaded production data from his CRM into ChatGPT. It returned an average cost per single pass for a lawn, per double pass, and how much seed is needed per square foot. He also runs customer texts, service descriptions and job descriptions through ChatGPT.

Result (as claimed)

“It would have taken us several days and many manhours to do this manually and ChatGPT figured it out in 10 minutes.”

Prompt

I own a lawn-care business and want to review aeration and overseeding costs before setting prices. My past year’s CRM export is [attach job sizes, passes, labor hours and materials]. Labor, material and overhead rates are [paste], with units explained in [notes].

1. Calculate average cost for a single and double pass by lawn size, and seed used per square foot.
2. Show the formulas, source fields and number of jobs used. List unusual or incomplete jobs separately; explain any exclusion.
3. Give a cost table by lawn size and list assumptions or missing rates I must confirm.

Use plain words and consistent units. Don’t invent prices, silently drop jobs or substitute selling price for cost. If the export lacks a needed field, ask before calculating that part. I’ll check the costs before choosing prices.

Do it yourself

These steps are my suggested way in, not Cory Overman’s setup.

What you need

  • A chat assistant that can analyze spreadsheet files, such as ChatGPT or Claude.
  • An export of past jobs from your CRM or job software: size, hours, materials and price.
  • Your labor rate and a rough overhead rate.

Start simple

  1. Export one service for the last year. Remove customer names and addresses.
  2. Upload the file and paste the prompt above. Add your labor and overhead rates.
  3. Ask it to show the calculation step by step and the jobs it excluded.
  4. Ask for a price table by job size at two or three target margins.
  5. Compare the table with what you charge today. Pick prices yourself.

Take it further

  • Repeat for each service so you can compare margin across your whole menu.
  • Ask which job sizes or areas lose money once drive time is included.
  • Rerun it each season with fresh data and keep the old tables to compare.

Check your work

  • Recalculate two or three jobs by hand from the raw file. The totals should match.
  • Check the row count. If it used fewer jobs than you exported, ask why.
  • Prices are a business decision. Test a new price on a few jobs before you change it everywhere.

Before you rely on it

  • This is general information, not financial, tax or accounting advice for your situation.
  • AI tools make arithmetic mistakes and misread statements, and they sound just as sure when they do. Check every number against your own records before you act on it.
  • For decisions with tax, loan, insurance or retirement consequences, talk to a qualified professional who knows your situation.

Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Not stated. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.

More in Finance for owners

New cases go out every Saturday in Inside AI.