Automate Your Solo Business: From First Enquiry to Sent Invoice

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Automate Your Solo Business: From First Enquiry to Sent Invoice.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Automate Your Solo Business: From First Enquiry to Sent Invoice.

Connect one chain of five steps: an enquiry form that records the details, an AI-drafted reply you approve, a quote you price and send, an invoice created from the accepted quote, and a scheduled payment reminder. Build it a link at a time, keep yourself as the approver, and test it on five real enquiries before it touches a customer.

The temptation is to automate the invoice first, because it is where the money is. Resist it. The enquiry is the link that makes the rest reliable: if the form captures the right details, every later step has the data it needs, and nobody retypes anything. Most failed solo automations break at the form, not at the invoice.

Follow me on Instagram@sagnikteaches

The chain, link by link

Take a one-person kitchen fitting business. It receives around six enquiries a week, writes quotes for about half of them after a site visit, and sends roughly eight invoices a month, some of them stage payments. Before the chain, admin takes the owner an hour or more on each job from first message to final payment, mostly in evenings. Here is the chain as designed.

Connect on LinkedInSagnik Bhattacharya
LinkWhat happensAI roleOwner role
1. FormCustomer fills in a short form; a row is added to a sheetNoneNone
2. Reply draftA draft acknowledgement lands in the inbox, with questionsWrites the draft from the form dataReads, edits, sends
3. QuoteA quote summary is drafted after a site visitStructures the notesSets every price
4. InvoiceAn accepted quote becomes an invoiceChecks line items matchApproves and sends
5. ReminderUnpaid invoices trigger a reminder on a scheduleDrafts wording per stageApproves the list

The AI never sets a price, never commits to a date and never sends alone. Those three limits are the reason a one-person business can trust the chain. Everything it does is drafting and checking; every decision stays with the owner.

Subscribe on YouTube@sagnikteaches

Link one: a form that gives the later steps what they need

The form is the foundation, and it should ask only what the next steps use. A form with twenty fields lowers completion; one with three loses the details you need. For the kitchen fitter, eight fields cover it.

  • Name and email (required)
  • Phone (optional)
  • Type of job: new kitchen, replacement worktops, units only, something else
  • Rough room size or number of units
  • Is the existing kitchen already removed? (yes, no, not sure)
  • Preferred start window: within a month, within three months, just researching
  • Budget band: under $5,000, $5,000 to $15,000, over $15,000, not sure
  • Anything else you want me to know (free text)

Any form tool that stores answers in a spreadsheet will do. The one rule is that each answer lands in its own column with a fixed header, because the next step reads those columns by name. If you later rename a column, the chain breaks silently, which is why the header names go into a short note kept beside the sheet.

Add a "something else" job type and route those rows differently, as described in the FAQ: no draft, a plain email notification, and nothing else. Odd requests are where AI drafts embarrass people.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Link two: the reply draft you approve

When a new row appears, the automation sends the row to an AI step, which writes a reply, and saves it as a draft in your email, not a sent message. The draft should acknowledge the specific job, ask the one or two missing questions, and propose a next step such as a site visit. A prompt that works:

You write first replies for a one-person kitchen fitting business.
Use only the enquiry details below. Never state a price, a start
date, or a guarantee. Do not claim to have seen the property.

Tone: warm, plain, under 110 words. Greeting "Hi [first name]".
Sign-off "[your name]".

The reply must:
1. Say what they asked for, in one sentence, using their words.
2. Ask for the single most useful missing detail (if the existing
   kitchen is not yet removed, ask about timing; if the room size is
   missing, ask for it).
3. Offer a site visit and ask for two days that suit them.

Enquiry:
Job type: {{job_type}}
Room size: {{room_size}}
Existing kitchen removed: {{removed}}
Start window: {{start_window}}
Budget band: {{budget}}
Notes: {{notes}}

An illustrative result for a row reading "new kitchen, about 12 square metres, not yet removed, within three months, $5,000 to $15,000":

Hi [first name],

Thanks for getting in touch about a new kitchen. Since the old
units are still in place, could you tell me roughly when you would
want them out? That helps me plan the order of work.

I would like to see the room before I give you a figure. Could you
suggest two days in the next fortnight when I could visit?

Best wishes,
[your name]

What you would fix: the draft is sensible, but "about 12 square metres" has been dropped, so it does not show it read the form. Add a line to the prompt: "Mention the room size back to them as a check." Small improvements like this come from the test round below, not from guessing in advance.

If the form data is poor, say the notes say "ASAP!!! need quote today", the draft should not mirror the urgency. Add a rule: "Never promise a quick turnaround; offer the next available visit slot in the notes field if one is given." Your calendar, not the AI, owns promises about time.

Link three: from site visit to a quote you price

Pricing a kitchen needs a person on site. The AI's job begins afterwards, turning your rough notes into a structured quote summary so that you spend your time on figures rather than formatting. Dictate or type the notes in whatever order they come, then paste them into a prompt that returns a fixed layout.

Turn these site notes into a quote summary with these headings:
Scope (bullet list, by room area), Assumptions, Exclusions,
Questions for the customer, and a blank Price table with one row
per scope item and an empty Price column.

Do not invent quantities or prices. If a note is ambiguous, list it
under Questions for the customer. Keep customer wording where
possible.

Notes:
wall units x6, base x5, 2 tall. worktop 3.2m + 1.1m return, laminate.
sink swap, plumber? ask. old units out, tip run. walls need skim
behind hob. tiling not mine. customer wants start before March.

The assistant returns the headings, a scope list that mirrors your notes, "plumber?" under questions, "tiling" under exclusions, and a price table with the right number of rows but blank prices. You then fill the prices yourself. The filled-in quote is where the human judgement sits, and the summary just removes the typing.

The check at this step is simple. Count the items in your notes against the scope list. If the notes say six wall units and the summary says five, the summary is wrong. Models handle counting poorly, so verify every quantity, as the tutorial on why AI is bad at maths in quotes and invoices explains.

Link four: the invoice, without double entry

This is where the chain earns its keep, because retyping a quote into an invoice is the classic place for a transposed figure. Many invoicing tools can convert an accepted quote straight into an invoice, and where yours does, that built-in feature beats anything custom. If yours can, the link is a person pressing one button and a person reading the result.

Where the tools cannot convert, use an automation to copy the line items across, and add a checking step. Ask an AI step to compare the quote total with the invoice total, and flag any difference before the invoice is saved as a draft. The comparison needs figures only, not customer data, which also keeps the privacy footprint small.

For stage payments, set the plan in the quote: for example 30% on acceptance, 40% when units are fitted, 30% on completion. Create the first invoice on acceptance, and keep the others as saved drafts with a note of the trigger. A one-person business gets into trouble by invoicing late, simply because the job was done and the owner moved to the next one. A saved draft with a clear trigger solves that without any AI.

Sequential invoice numbers should always come from the invoicing tool itself, never from an automation or an AI, since gaps and duplicates cause trouble at year end.

Link five: reminders that sound like you

Overdue invoices need a schedule, not a mood. A common pattern has three stages: a friendly note a day or two before the due date, a polite one on the day after, and a firmer one a week later. Many invoicing tools can send reminders on a timetable, and that built-in feature is the first thing to try. Use AI where it helps: drafting the wording of each stage so it sounds like the owner, then pasting it into the tool's reminder templates once.

Before and after, illustrative. The generic template reads: "This is an automated reminder that invoice 1042 is overdue. Please remit payment immediately." The version drafted from the owner's own style reads: "Hi [first name], just a quick nudge that invoice 1042 for the kitchen units was due yesterday. If it has already gone through, please ignore this. If anything is holding it up, let me know and I will help sort it." The second gets paid faster from good customers and does not insult them.

Keep a person in the loop on the final stage. Anything beyond the second reminder gets a review: has the customer raised a complaint about the work? Is a stage payment waiting on something you owe them? A reminder that arrives during a dispute is worse than none, and no automation can see a dispute that lives in a phone call.

Tool costs and time saved for a one-person chain

For a one-person business, the tooling is small. The form and spreadsheet can be free. An automation platform that links them to email and an AI step is the main cost. Zapier's free plan allows 100 tasks a month, but only two-step Zaps, so a chain with a form, a sheet row, an AI draft and an email draft needs a paid plan; the Professional tiers start at $19.99 a month billed annually ($29.99 monthly) for 750 tasks. Make has a free tier of 1,000 credits a month, and its paid plans are sold in credit allowances, so read its pricing page for the current entry price. Check both vendors' pages for current limits, because they restructure plans often.

A rough count helps you pick a tier. If an enquiry uses four steps that count, and you receive twenty-four enquiries a month, that is around 100 tasks, comfortably inside the 750 allowance. The AI step may count as several tasks depending on settings, so test with a handful of runs and read the usage meter before you decide. The AI drafting step is usually the smallest cost. Short drafts for six enquiries a week, sent through your own API key, are likely to come to a few dollars a month at most, though you should check the current rate for the model you choose. If you use the automation platform's own built-in AI step instead, check how that is billed, because an AI run can use more than one task or credit.

The time sum, illustrative, for the kitchen fitter in a month of 24 enquiries, 12 quotes written after site visits and 8 invoices:

  • Replies: 8 minutes each before, 2 minutes to review a draft after. 24 x 6 minutes saved = 144 minutes.
  • Quote write-ups: 25 minutes before, 10 minutes after. 12 x 15 = 180 minutes.
  • Invoices: 10 minutes before, 5 minutes after. 8 x 5 = 40 minutes.
  • Reminders: 5 minutes before, 1 minute to approve the list. 8 x 4 = 32 minutes.
  • Total: 396 minutes, a little over six and a half hours a month.

Six and a half hours is not a transformed business. It is an evening and a half back each month, plus fewer slips, and that is a realistic return for a first chain. The tutorial on how much time AI saves a solo consultant shows similar ranges.

Testing with five real enquiries

Do not announce the chain to customers on day one. Take five real enquiries from the last month, including a good one, a vague one, one that wanted a price straight away, one from outside your usual jobs and one with a spelling-heavy message. Type each into the form as if you were the customer, using a test email address you own, and follow it through.

TestWhat to checkPass looks like
Form to sheetEvery answer in the right columnNo blanks or shifted columns
Draft replyMentions the job, asks one question, no priceYou would send it with a small edit
Odd requestRouted with no draftA plain notification and no AI text
Quote summaryQuantities match your notesZero count errors
InvoiceTotal matches the quoteIdentical to the cent
ReminderRight wording at the right daySent to your test address on schedule

Log every edit you make to a draft, with the reason, in a column of the same sheet. After five tests you will know which lines to add to the prompt. Run the same five again until drafts need only light edits, then switch the chain on for real enquiries with you still approving every message. Review the log once a week for the first month.

When one trigger fires twice

Picture an illustrative solo photographer whose chain creates an invoice whenever a booking status in the sheet changes to "confirmed". A customer's row is edited twice in an afternoon, first to confirmed, then to fix a typo in the address. The platform treats the second edit as a new trigger, and two identical invoices go out for the same session.

It surfaces because the customer emails, kindly, asking which of the two to pay. The fix is to trigger only when the status is confirmed and an "invoice sent" column is empty, and to write the invoice number into that column as soon as the invoice is created. Any step that creates something with consequences needs a guard that stops it running twice. Ask of every link: what happens if this fires again for the same record?

Keeping customer details safe inside the chain

A chain moves personal details between several tools: the form, the sheet, the automation platform, the AI step and your inbox. Each hop is a place where data can sit longer than you intended. Three habits keep this tidy for a one-person business.

  • Send the AI only what it needs. The reply prompt uses job type, room size, timing and notes. It does not need the customer's phone number or street address, so leave those columns out of the step. Fewer fields also means fewer ways for a draft to repeat something it should not.
  • Clear the sheet on a schedule. Once an enquiry is lost or the job is finished and paid, delete the personal columns after a period you decide, say twelve months, and keep only job type and value for your own records. If you have customers in the EU, data-protection law governs how long you keep these details, so ask an adviser if you are unsure what you must keep.
  • Know where the AI step runs. Read the privacy page of whichever AI service your automation calls. Business-grade plans and API use generally do not train on your content by default, but settings differ, so confirm it rather than assuming.

Here is a short worked check. The kitchen fitter lists every place a customer's email address appears: the form tool, the sheet, the automation platform's run history, the email draft and the invoicing tool. Five places. Two of them, the platform's run history and the form tool's own storage, keep data the owner had forgotten about. The fix is to reduce the run history retention in the platform settings where it allows, and to delete old form entries every quarter. It takes ten minutes to write the list and saves a surprise later.

What to leave out of the chain for now

Resist adding steps in the first month. Do not add AI to decide which customers to prioritise, to negotiate on price or to reply to complaints. Each of those depends on judgement, tone and context that your drafts do not carry. Do not connect payment-taking tools to any step that an AI writes into, and keep bank details out of any prompt.

When the chain has run for a month with few corrections, the natural extensions are a thank-you message after the final payment and a review request a week later, and perhaps a holding message when an enquiry arrives out of hours. The freelancer invoices and chasers tutorial has more wording to borrow. If you would like help drawing the chain for your own business, that is what an AI implementation consultation is for.

Five signs the enquiry-to-invoice chain is working

  • Response time: the first reply goes out the same working day, every time. Measure the gap between the form arriving and the reply sending.
  • Edit rate: the share of drafts you send without changing more than a sentence climbs over the month.
  • Quote-to-invoice errors: zero totals that differ between quote and invoice.
  • Days to pay: average days from invoice to payment falls, even slightly, once reminders are scheduled.
  • Your evenings: the admin you used to do after dinner shrinks. If it does not, look for the link where you are still retyping.

Questions from one-person businesses about this chain

Can AI send the quote or invoice for me?

It can draft them, and your tools can send them, but the first version should have you approve each one. Prices, scope and legal wording carry real consequences. Move to automatic sending only for message types where a month of logs shows you changing almost nothing.

Which automation tool should I use?

Any that connects your form, email and invoicing software will do. Zapier and Make are the common general-purpose ones, and many invoicing tools have built-in reminders and quote-to-invoice buttons. Prefer the built-in feature over a custom step when both can do the job.

How many enquiries do I need before this is worth building?

Around ten a month is a sensible floor for the full chain. With fewer, build only the first link, a saved reply draft, and the rest by hand. The test is whether you currently spend more than a couple of hours a month on the admin the chain would cover.

What if an enquiry does not fit the form?

Add an option for 'something else' and route those to your inbox untouched, with no AI draft. A chain that tries to answer every odd request will eventually reply badly to one. Let it handle the common cases, and leave the strange ones to you.

Further reads

Sources: Zapier's pricing page and Make's pricing page, read on 5 November 2026 (Make's paid-plan prices did not display, so none are quoted). Check current plan limits before you build, as both vendors revise them.

Want this chain mapped for your own business?

On a 1:1 call we can lay out your enquiry-to-invoice steps, decide which ones are worth automating first, and check whether your current tools can already do them.

Book a 1:1 call with me