Sending Quotes Faster: Simple Automation for Service Providers

Service providers in Kenya who send quotes within the same day win more work than those who take two or three days. You can automate quotes for your service business using a Google Form to collect requirements, a Google Sheet for pricing calculations, and a template that generates a professional quote in minutes instead of hours.

Why Speed Matters More Than You Think

When a customer in Nairobi requests a quote for event decoration, plumbing, photography, graphic design, or catering, they rarely contact just one provider. They message three or four through WhatsApp, Instagram, or referrals, and they go with whoever responds clearly and quickly.

The delay is not because you are slow. It is because the quoting process involves too many manual steps. You receive a vague WhatsApp message ("How much for a birthday party?"), ask follow-up questions over several back-and-forth messages, mentally calculate the cost, type up a quote on your phone, and send it. If you are busy with another job, the quote waits until evening or the next day.

By then, the customer has already paid a deposit to someone who replied in two hours.

The automation in this guide tackles three specific bottlenecks: collecting complete information upfront (so you do not need five follow-up messages), calculating prices quickly (using formulas instead of mental math), and formatting the quote professionally (using a template instead of typing from scratch each time).

What You Are Building

The quote automation flow works like this:

1. Customer fills in a Google Form with their requirements (what they need, when, where, quantity)
2. Their response lands in a Google Sheet that calculates the estimated price based on your rates
3. You review the calculated quote, adjust if needed, and copy it into a template
4. You send the formatted quote to the customer on WhatsApp or email

Steps 1-3 happen mostly automatically. Step 4 is a quick copy-paste. The entire process takes 10-15 minutes per quote instead of 45 minutes to an hour.

Step 1: Create a Quote Request Form

The goal of this form is to collect enough detail that you can price the job without a long conversation. Every service is different, so adapt these fields to your specific business.

For a general service provider:

• Your name (short answer, required)
• Phone number (short answer, required)
• What service do you need? (dropdown or checkboxes listing your services)
• Brief description of the job (paragraph, required: "Tell us what you need done, including any specific requirements")
• Location (short answer: where the work will happen)
• Preferred date or deadline (date picker)
• Budget range (dropdown: Under a reasonable amount / a reasonable amount-15,000 / a reasonable amount-50,000 / Over a reasonable amount / Not sure)
• How did you hear about us? (dropdown: WhatsApp, Instagram, Referral, Google, Other)

For a photographer:

Replace the generic fields with: Event type (wedding, corporate, portrait, product), Number of hours needed, Location, Number of final edited photos expected, Video included? (Yes/No).

For a caterer:

Replace with: Event type, Number of guests, Meal preference (buffet/plated), Menu type (Kenyan, Continental, Mixed), Venue (we deliver / client's venue / need venue recommendation).

For a plumber or electrician:

Replace with: Type of work (installation, repair, inspection), Property type (residential, commercial), Urgency (routine, this week, emergency today).

The key: every question on the form replaces a WhatsApp follow-up message. If you normally ask five questions before you can quote, put those five questions on the form.

Step 2: Set Up the Pricing Sheet

Open the Google Sheet linked to your form. Next to the automatic response columns, add your pricing columns:

Name	Phone	Service	Description	Location	Date	Budget	Base Price	Transport	Materials	Discount	Total Quote	Status

Base Price: Use a formula that looks up your service rates. If you have a rate card (e.g., Photography: a reasonable amount, Catering per plate: a reasonable amount, Plumbing call-out: a reasonable amount), create a separate "Rates" tab and use VLOOKUP to pull the base price based on the service selected.

=VLOOKUP(C2, Rates!A:B, 2, FALSE)

Transport: If your pricing varies by location, add a transport fee column. You can create location-based pricing (within CBD: KES 0, within Nairobi: a reasonable amount, outside Nairobi: a reasonable amount+) and look it up automatically or fill it manually.

Materials: For services that require materials (construction, decoration, catering), estimate based on the description. This column will usually be manual since material needs vary per job.

Total Quote: A formula that adds the columns:

=H2+I2+J2-K2

Status: Track where each quote stands: New / Quoted / Accepted / Declined / Expired.

Step 3: Build Your Quote Template

Create a professional-looking quote template that you can fill in quickly. You have two good options.

Option A: Google Docs template

Create a Google Doc with your business name, logo, contact details, and a standard layout:

[Your Business Name]
[Phone] | [Email] | [Location]

QUOTATION
Date: [date]
Quote #: [number]
Valid for: 14 days

Prepared for: [Customer name]
Phone: [Customer phone]

Service: [Service description]
Date of service: [Preferred date]
Location: [Location]

Breakdown:
- [Service]: KES [amount]
- Transport: KES [amount]
- Materials (estimated): KES [amount]

Total: KES [total]

Payment terms: about half deposit to confirm booking.
Balance due on completion.
M-Pesa Paybill: [number] | Account: [your name or business]

This quote is valid for 14 days from the date above.
Thank you for considering [Business Name].

Duplicate this template for each new quote, fill in the details from your sheet, export as PDF, and send via WhatsApp.

Option B: WhatsApp-friendly text format

For faster quotes where a PDF feels excessive, format the quote as a clean WhatsApp message:

"Hi [Name], thank you for your inquiry. Here is your quote:

[Service]: KES [amount] Transport: KES [amount] Materials: KES [amount] Total: KES [total]

This quote is valid for 14 days. To confirm, send a about half deposit (KES [amount]) to M-Pesa [Till/Paybill], Account: [name].

Questions? Reply here or call [number]."

Most Kenyan service businesses will find the WhatsApp format more practical for smaller jobs (under a reasonable amount) and the PDF format better for larger projects where the client might need to share the quote with someone else for approval.

Step 4: Send and Follow Up

Once you have the quote ready, send it promptly. Same-day turnaround should be your standard for requests received during business hours.

Follow-up schedule: If the customer has not responded after two days, send a polite follow-up: "Hi [Name], just checking if you received the quote I sent for [service]. Happy to answer any questions or adjust the scope." One follow-up is appropriate. Two maximum. After that, let it rest.

Track all of this in your sheet's Status column. At the end of each week, review how many quotes you sent, how many were accepted, and your conversion rate. If you are sending 10 quotes and only converting 1, the issue might be pricing, response speed, or the quality of leads coming in.

Making It Even Faster with AI

Once your form and template are set up, you can add AI tools to speed up specific steps.

Writing service descriptions. If a customer's form response is vague ("I need decoration for a party"), use ChatGPT or Claude to expand it into a professional scope of work: "Event decoration for birthday party at [location]: balloon arch, table centerpieces (6 tables), backdrop setup, and cleanup after event."

Adjusting tone. If you write quotes quickly and they sound too casual, paste your draft into an AI tool and ask it to make the language more professional while keeping it friendly.

Creating estimates for unusual requests. When a customer asks for something you have not priced before, describe the work to an AI tool and ask it to help you think through the cost components. This is not a substitute for your expertise, but it helps you avoid forgetting line items.

For a practical introduction to using these AI tools and connecting them into workflows, the business automation guide for Kenyan SMEs covers the fundamentals with Kenyan business examples.

Common Mistakes to Avoid

Quoting without enough detail. If the form response is incomplete, call or message the customer for clarification before quoting. A wrong quote is worse than a slow quote because it leads to disputes later.

No expiry date. Always include a validity period (7-14 days is standard). Prices for materials, venue hire, and subcontractor rates change. A quote from three months ago should not be binding.

Forgetting M-Pesa details. The easier you make it to pay, the faster you get deposits. Include your M-Pesa Paybill or Till number in every quote. If you accept bank transfers, include those details too.

Not following up. Many customers intend to accept but get busy and forget. A single polite follow-up recovers a significant number of quotes that would otherwise expire silently.

Underpricing to win the job. If your automated pricing calculation shows a margin that is too thin, do not override it just to be cheaper. Winning a job at a loss is worse than losing a job. Trust your numbers.

To learn how to connect forms, sheets, and messaging tools into complete automation workflows from scratch, try the free welcome module of the AI and Automation course.

FAQ

How do I handle customers who still want to negotiate after receiving the quote?

Build a small buffer into your pricing. If your minimum acceptable price is KES 20,000, quote a reasonable amount-24,000. When the customer negotiates, you can offer a modest discount without cutting into your actual margin. Note that some services (medical, legal, professional consulting) should not negotiate on price since it signals uncertainty about your own value.

What if I offer too many different services to list on one form?

Create two or three forms, one for each main service category, and share the relevant link based on what the customer asks about. A photographer might have one form for weddings, another for corporate events, and a third for portraits. This keeps each form short and specific, which improves completion rates.

Should I include my prices on the form itself?

For standardised services with fixed pricing (passport photos, standard haircuts, routine plumbing checks), yes. Showing prices upfront filters out customers whose budget does not match. For custom services where every job is different (catering, event decoration, construction), no. Collect the details first and provide a tailored quote.

How do I stop competitors from using my form to see my pricing?

Your form collects information; it does not display your rates. The pricing formulas are in your private Google Sheet, not visible to anyone filling in the form. If you are still concerned, require a phone number and verify it belongs to a real potential customer before sending the quote.