Instead of paying for last-mile software that limits your communication-like Circuit's lack of WhatsApp integration or Upper removing time-window texts-you can text customers a live tracking link generated in Google Sheets. InstaMaps builds branded tracking pages showing an exact "N stops away" ETA directly from your delivery spreadsheet.
This setup is built for independent dispatchers, local couriers, and small delivery fleets tired of rigid routing app constraints. You retain total control over your customer notifications, providing a live driver location map that updates automatically as you progress through your route sheet.
- →Some route planning apps like Circuit lack native WhatsApp integration, while others like Upper have removed built-in customer time-window texts.
- →You can bypass these restrictions by generating live, branded tracking pages in Google Sheets and texting the URL directly to customers.
- →InstaMaps provides the =TRACKING_LINKS() formula to output a shareable page showing exactly how many stops away a driver is.
- →The =LOGBOOK_LINK() formula creates a hosted delivery logbook for each route, which can be sent via SMS or WhatsApp.
- →The =INSTAMAP() formula generates a live, hosted map URL that automatically updates driver locations as your sheet changes.
- →This workflow runs entirely in Google Sheets, costing nothing up to the 100 free daily lookups limit.
How do I text customers delivery updates when my routing app lacks native WhatsApp integration?
When last-mile platforms fail to provide reliable communication tools, dispatchers hit a wall. A recent Circuit reviewer noted a critical gap: "No native integration with WhatsApp, which is essential for last-mile communication." Similarly, an Upper reviewer reported that their built-in customer time-window texts were removed from the platform, leaving drivers without a way to notify recipients.
If your routing software restricts SMS or lacks WhatsApp integration, you can bypass these limitations by sending a simple, trackable URL via your own devices. InstaMaps is a free Google Sheets add-on that generates live, hosted tracking pages directly from your delivery manifest. Instead of relying on the routing app to push out automated texts, you maintain full control over the channel.
You copy a generated link from your spreadsheet and paste it into WhatsApp Business, your standard SMS gateway, or a basic cell phone text. When the customer clicks the link, they view a live page displaying "N stops away" based on the real-time data in your sheet. As your dispatchers update row statuses in Google Sheets-changing a cell from "Pending" to "Completed"-the hosted tracking page automatically recalculates the customer's position in the queue. This solves the missing WhatsApp integration without requiring complex API webhooks or expensive per-message routing software fees.
Why do delivery apps restrict or remove customer text features?
Delivery platforms frequently restrict or remove native SMS features due to escalating carrier fees, strict A2P 10DLC compliance rules, and high API costs. When a platform includes built-in customer messaging, they absorb the cost of every outbound text. If a carrier flags the traffic volume as spam, or if a recipient marks an automated time-window text as spam, the platform faces penalties. To protect their margins, routing apps often restrict daily text limits or remove the feature entirely, similar to the Upper reviewer who had their customer texts removed.
Relying on closed routing software for customer communication means the software vendor controls your delivery updates. A spreadsheet-based approach reverses this. By managing your route in Google Sheets and using InstaMaps to generate the tracking URLs, you decouple your routing logic from your messaging provider.
You can send the generated link using your own WhatsApp Business account, a low-cost SMS gateway like Twilio, or a standard mobile phone. Because the tracking page is just a standard URL hosted by the =TRACKING_LINKS() function, you completely avoid the per-message markup charged by routing platforms. You control the SMS gateway, manage your own carrier compliance, and dictate when the texts go out. If one SMS gateway increases prices or shuts down, you simply switch providers and keep pasting the same tracking links from your sheet into the new system.
How do you generate live "N stops away" tracking links in Google Sheets?
To generate live customer tracking links directly inside your delivery sheet, install the InstaMaps add-on. Open Google Sheets, navigate to Extensions > InstaMaps > Enable formulas. The sidebar allows you to insert formulas without typing them, and its Build-the-workflow button writes whole chains of location formulas for you.
To create individual tracking pages that show a live queue position:
Structure your sheet: Put your route order in column A (e.g., A2:A50 for 49 stops). Column B should contain the customer's name, and Column C can track the VISIT_STATUS (e.g., "Pending", "En Route", "Completed").
Insert the tracking formula: Click an empty cell, such as D2. Type =TRACKING_LINKS(A2:A50). Alternatively, use the InstaMaps sidebar to auto-fill the exact cell references.
Review the generated URLs: The formula instantly outputs a unique, hosted URL for every row in your range.
Can Google Sheets create a branded delivery logbook for customer texts?
Yes. While individual =TRACKING_LINKS() show a single customer their specific "N stops away" position, you can also generate a macro-level overview of your entire route. The =LOGBOOK_LINK() function creates a single, hosted URL that summarizes your entire delivery queue's status.
To use it, click an empty cell at the top of your sheet-such as cell F1. Type =LOGBOOK_LINK(A2:A50). This generates one master URL for your route.
When you text this link to a customer, it provides a verifiable, branded tracking page that displays the overall route progress without exposing your other customers' personal data. Instead of just seeing "Stop 4 of 50," the logbook page displays the route's general status, such as "The driver has completed 3 stops and is currently en route to the next location." This is particularly useful for bulk text messages or WhatsApp broadcasts sent to an entire apartment building where multiple orders are dropping in the same time window.
If you need to embed this live route overview onto your own company website, you can use the =INSTAMAP() function right next to your logbook link. =INSTAMAP() returns a live, hosted shareable map URL that updates the moment you change a cell in your sheet, giving customers both a text status update and a visual map of the driver's local area.
Worked example: Texting 47 live tracking links from a single sheet
Consider a local farm delivery service running a fixed 47-stop route today. The dispatcher needs to text customers delivery updates and live tracking links so they know exactly when to step outside.
Instead of manually copying and pasting Google Maps URLs into individual messages, the dispatcher lays out the spreadsheet like this:
Column A (Addresses): Delivery locations in cells A2:A48.
Column B (Status): The current stop number or driver status (e.g., "En route to Stop 5") in B2:B48.
Column C (Tracking Links): The formula =TRACKING_LINKS(A2:A48, B2:B48) in cell C2.
Limits and honest alternatives to spreadsheet SMS routing
Using a spreadsheet to generate customer tracking links has distinct limitations. InstaMaps provides a free tier of 100 lookups per day. If your route requires more than 100 geocoding actions or tracking link generations, you will hit the daily ceiling. You can increase this capacity to 1,000 lookups per day by completing a free email unlock directly within the add-on.
Furthermore, Google Sheets does not natively send SMS messages. InstaMaps builds the URLs and maps, but it does not function as an automated SMS gateway. Once you generate your =TRACKING_LINKS(), you must manually copy those links from Column C and text them to your customers using your smartphone, WhatsApp Business, or a mail-to-SMS gateway.
If you only need basic navigation and do not require customer-facing tracking pages, use =ROUTE_LINK(A2:A48). This function uses Google Maps' official URL scheme and outputs a standard navigation link for a maximum of 11 stops. You can text this single link directly to a driver for turn-by-turn routing, though it does not provide the live "N stops away" ETA that the tracking pages offer to the end customer.
Finally, the live hosted map generated by =INSTAMAP() operates on a slight delay. It updates when the sheet changes, but it is not a real-time, sub-second GPS pinging system. If a customer is looking at the tracking page, they will see the driver's marker move along the route based on dispatcher inputs, but it relies on sheet updates, not automated vehicle telemetry.
Who is this Google Sheets tracking workflow for?
This workflow is ideal for small businesses, independent contractors, and regional delivery fleets. If you operate a 5-crew landscaping company or a local appliance delivery service, dedicated route planning software is often too rigid and expensive.
InstaMaps is built for teams that need to text customers delivery updates without paying enterprise API fees. Instead of subscribing to a monthly routing platform that strips out features or lacks WhatsApp integration, you can manage everything from a Google Sheet.
Local delivery fleets: Farms, bakeries, or pharmacy couriers needing to send "N stops away" updates without building a custom app.
Independent contractors: Handymen, mobile mechanics, or tutors who want to text a client a live arrival time simply by updating a single spreadsheet cell.
Dispatchers using WhatsApp: Teams that rely on WhatsApp Business for customer communication and need a way to generate shareable, live tracking URLs that work perfectly when pasted into a chat.
Who should skip this: National logistics companies requiring automated SMS API triggers, electronic proof of delivery (POD) scans, or direct telematics integration with truck hardware. InstaMaps relies on manual data entry or sheet updates to move the map marker.
Map your Salesforce accounts in under 5 minutes — no admin setup.
Common Questions
Google Sheets cannot send SMS texts natively on its own without a third-party integration. However, you can use InstaMaps to generate a live tracking link in your sheet, then pass that URL into an SMS gateway like Twilio, or copy the link into your existing business text messaging app. This gives you full control over how and when you text customers delivery updates.
Use the `=TRACKING_LINKS()` function in InstaMaps to create a live URL for each row in your delivery sheet. When a customer opens that link on their phone, they view a hosted page displaying their exact delivery status and an "N stops away" countdown. As you mark orders complete in the sheet, the customer's page updates automatically.
Yes, Google Sheets paired with the InstaMaps add-on is a highly flexible alternative. While a Circuit reviewer noted the platform lacks native WhatsApp integration, and an Upper reviewer had their customer time-window texts removed entirely, InstaMaps simply generates standard URLs. You can paste these tracking links into WhatsApp, SMS, or email without worrying about a platform blocking your communication.
The InstaMaps add-on is completely free to use. The free tier includes 100 map and formula lookups per day, which increases to 1,000 lookups per day when you register with a free email unlock. Generating live tracking links and hosted maps does not require a paid subscription.
Yes, the tracking links generated by InstaMaps are standard web URLs, meaning they open natively in any mobile browser. Whether a customer uses an iPhone or an Android device, they can click the link in their standard SMS or WhatsApp text message to view the live delivery ETA without needing to install a separate app.
Yes, the `=INSTAMAP()` formula takes your spreadsheet's location data and returns a live, hosted shareable map URL. You can also use `=LOGBOOK_LINK()` to provide a chronological view of the route. As you update the driver's current location or visit status in your Google Sheet, the hosted map URL updates automatically for anyone viewing the link.
Stop paying for routing apps that remove the features you need. Install InstaMaps to generate live customer tracking pages and "stops away" ETAs directly from your spreadsheet.
Install InstaMaps free