Routing Mumbai Service Enquiries by Pincode: A Small Lookup That Sends Each Lead to the Right Person

Description and use

Automatic routing of Mumbai service enquiries by pincode lets small businesses quickly assign leads to the right staff member using a Google Sheet as the data source.

Problem

Small service businesses in Mumbai need to assign incoming enquiries to the correct staff member based on geographic area, but manually determining the owner is time‑consuming and error‑prone.

Outcome

Enquiries are routed automatically to the correct staff member, reducing manual effort and preventing unanswered leads.

Workflow

• Extract pincode from enquiry text using regex
• Look up pincode in the Google Sheet table
• If match found, assign owner and backup; else assign default owner
• Log routing reason (matched, unknown_pincode, no_pincode_ask) next to the lead
• If owner is on leave, route to backup

Evidence

Small service businesses in Mumbai (AC repair, pest control, tutors, caterers) often have staff who cover specific areas.

Source

Keep it in Google Sheets so the owner can edit it without a developer.

Source

If the owner of an area is on leave (mark it in the sheet), route to the backup. Missing this is how leads sit unanswered for a day.

Source

Write the routing reason next to each lead. When a customer complains, you can see why it went where it did.

Source