Delivery Run Sheet Template: Google Sheets + Live Map Setup

A delivery run sheet template is a structured spreadsheet used to organize daily delivery schedules, driver assignments, and customer addresses. Using the InstaMaps Google Sheets add-on, you can convert a standard delivery sheet into a live map and generate tracking links for drivers without leaving your workbook.

This setup is built for local delivery businesses, farm box operators, and multi-stop courier services managing 10 to 150 stops a day. By replacing static PDF run sheets with a Google Sheets template, dispatchers end up with a single dashboard that tracks completion status and pushes route changes directly to a driver's phone in real time.

Who should use a Google Sheets run sheet template

This approach fits specific operational sizes and technical requirements. You should use a Google Sheets delivery run sheet template if:

1. You run a small local courier service, pharmacy delivery, or landscape material supplier handling 30 to 150 stops per day.

2. You manage a local farm CSA delivering produce to 50 to 200 local addresses weekly.

3. You dispatch 3 to 5 independent contractors who need dynamic routing links sent directly to their personal mobile phones.

In these scenarios, a spreadsheet template avoids the per-seat or per-vehicle subscription fees of enterprise routing software like Routific or Onfleet. A Sheets-based workflow gives you total control over your data structure without locking you into a proprietary dashboard.

Who should not use this template: Operations managing a 50-truck fleet requiring live GPS telemetry, driver behavior monitoring, or barcode scanning hardware. Google Sheets cannot handle continuous ping data or direct hardware integration at scale. If your routing requires strict compliance tracking or dynamic automated rerouting based on live traffic algorithms, rely on dedicated enterprise routing software instead.

Step-by-step: Building the delivery run sheet template

1. Open the template: Go to get-instamaps.com/templates and copy the delivery run sheet workbook to your Google Drive. Open the sheet and click Extensions > InstaMaps > Enable formulas to open the sidebar.

2. Structure the columns: In row 1, label your standard data columns: Order ID (A), Customer Name (B), Full Address (C), Latitude (D), and Longitude (E).

3. Input the data: Paste your daily route addresses into column C. For a 47-stop route, this covers cells C2 through C48.

4. Standardize formatting: If you pasted messy data from an email, select cell D2 and use the sidebar to insert `=CLEAN_ADDRESS(C2:C48)`. This standardizes capitalization and formatting issues before geocoding.

5. Geocode the locations: Click cell E2. Rather than typing the syntax manually, use the sidebar's Build-the-workflow button. The sidebar automatically writes `=GEOCODE(C2:C48)` into cell E2, filling the column with verified coordinate data. The free tier handles 100 lookups per day, which increases to 1,000/day with a free email unlock.

6. Generate the master map: Select cell G2. Click Build-the-workflow to insert `=INSTAMAP(D2:D48, E2:E48)`. This formula returns a live, hosted, shareable map URL that plots every address on your run sheet. Every time you add a new address to column C, the map automatically plots the new point without requiring a manual refresh.

7. Create turn-by-turn routing links: To provide drivers with a clickable Google Maps link, select cell H2 and insert `=ROUTE_LINK(C2:C12)`. This generates a URL for the first 11 stops using Google Maps' official URL scheme (the maximum allowed stops per link).

8. Divide long routes: If you have exactly 47 stops, you must divide the route into link segments. Place `=ROUTE_LINK(C2:C12)` in cell H2 for stops 1 through 11. Place `=ROUTE_LINK(C13:C23)` in cell I2 for stops 12 through 22. Continue this pattern across the row to create a multi-segment route guide for your driver.

Generating a phone crew link with =LOGBOOK_LINK()

Sending drivers a raw spreadsheet link often fails because mobile screens make scrolling through rows and columns cumbersome. Instead of sharing the sheet itself, generate a dedicated mobile interface using two distinct functions.

1. Deploy the mobile link: In cell J2, type `=LOGBOOK_LINK()`. This formula generates a unique, mobile-friendly URL tied directly to your current workbook.

2. Distribute to drivers: Text or email this URL to your driver. When the driver opens the link on their phone, they see a clean, touch-optimized list of their assigned stops. They do not need the Google Sheets app installed, nor do they need an InstaMaps account to view the page.

3. Capture driver inputs: The `=LOGBOOK_LINK()` page features built-in input fields. Drivers can tap buttons to mark a stop as "Delivered", "Attempted", or "Failed", and type specific notes into a text box such as "Left package at the side door."

4. Sync inputs back to the sheet: To route these mobile inputs back to your master dispatch sheet, use the companion formula. In cell K2, enter `=LOGBOOK(J2)`, pointing directly at the cell containing your logbook link.

Whenever a driver updates their status on their phone, the `=LOGBOOK()` formula captures that text and writes it natively into cell K2. If a driver attempts a delivery at 14:32 and leaves a note, the dispatcher sees that exact input populate in the sheet within seconds.

For a team of 5 crews, you generate 5 distinct logbook links. If Crew A handles rows 2 through 48, input `=LOGBOOK_LINK(C2:C48)` in cell J2 to isolate their route. Create a second link in cell J3 for Crew B's route using `=LOGBOOK_LINK(C49:C95)`. This segmentation ensures drivers only see their assigned stops and cannot accidentally edit the wrong rows.

By pairing `=LOGBOOK_LINK()` and `=LOGBOOK()`, the driver's phone acts as a simple data entry terminal, keeping the master sheet secure from accidental edits while capturing exact proof of delivery notes.

Monitoring completions with =VISIT_STATUS()

Dispatchers need to monitor completion rates without manually checking each driver's mobile page throughout the day. The `=VISIT_STATUS()` function automates this tracking.

1. Map the status: In column L, row 2, enter `=VISIT_STATUS(J2)`, where J2 contains the `=LOGBOOK_LINK()` for that specific route.

2. Automated updates: When a driver taps "Delivered" on their mobile interface, the status pushes through the logbook. The formula checks the logbook feed continuously. If a driver marks a stop as failed at 10:15 AM, the dispatcher's dashboard reflects the change before the driver reaches the next address.

3. Filter the dashboard: Dispatchers can apply a standard Google Sheets filter to column L. As a 200-home farm delivery progresses, applying a filter to hide "Delivered" stops leaves only the "Failed" or "Pending" addresses on the screen. This highlights exactly where dispatchers need to intervene.

Because the data updates natively, you can build summary charts tracking overall route completion percentages without manual data entry.

Worked example: A 5-crew route across a 200-home farm

Start with a 200-row farm dataset in Sheet1. Column A holds customer names (A2:A201), and Column B holds addresses (B2:B201). Filter this master list down to 47 active deliveries for today, pasted into Sheet2 at B2:B48. Column C assigns crews.

To divide the 47 stops equally among 5 crews, label C2:C10 as "Crew 1", C11:C19 as "Crew 2", up to "Crew 5".

Next to the Crew 1 assignment in E2, generate their specific routing link using =ROUTE_LINK(B2:B10). Because this formula uses Google Maps' official URL scheme, it hard-stops at 10 or 11 waypoints maximum. We are safely under the limit at 9 stops.

To give Crew 1 a visual map they can view without leaving their phone browser, write =INSTAMAP(B2:B10) in cell F2. This generates a live, hosted URL that drops pins for all 9 stops. If dispatch adds a late delivery to row 11, the map at F2 updates automatically.

To track completion on the run sheet, generate a mobile-friendly link for the crew in G2 using =LOGBOOK_LINK("Crew 1", B2:B10). The driver opens this link on their phone and taps a button to log arrivals.

Back in the Google Sheet, =LOGBOOK("Crew 1") in H2 pulls the exact timestamp logs from that mobile interface directly into the spreadsheet. Finally, wrap your view of the route with =VISIT_STATUS("Crew 1") in I2 to automatically calculate and display "4/9 stops completed".

Repeat this block down the rows for the remaining crews. For Crew 2, use =ROUTE_LINK(B11:B19) in E3, =INSTAMAP(B11:B19) in F3, =LOGBOOK_LINK("Crew 2", B11:B19) in G3, and =VISIT_STATUS("Crew 2") in I3.

Because the =INSTAMAP() formula relies on a live hosted URL, you can embed the five crew maps into a dispatch dashboard. Instead of manually calling drivers to ask for ETAs, dispatch monitors H2:H6 for automatic timestamp updates. If =VISIT_STATUS() reads "0/9" at 9:00 AM, dispatch knows the crew hasn't started. If it reads "9/9" at 11:30 AM, dispatch can pull their =ROUTE_LINK() and send them to assist Crew 3, who might be stuck at 2/9. This replaces static PDF printouts with a spreadsheet that reacts to cell changes in real time.

Limits and honest alternatives

This template setup relies on Google Sheets, which imposes specific constraints on delivery routing. First, the =ROUTE_LINK() formula uses the standard Google Maps URL scheme. Google enforces a strict maximum of 11 stops (10 waypoints plus the destination) per link. If a crew has 12 stops, =ROUTE_LINK(B2:B13) will fail to generate a valid turn-by-turn navigation link. You must split routes into batches under 11 stops, or rely solely on =INSTAMAP() for a bird's-eye view of the pins.

Second, there are no live GPS breadcrumbs. The =LOGBOOK_LINK() provides a "push-button" interface for drivers to log their status, but dispatch cannot see the vehicle moving on a map in real time. If a driver ignores the link, the =LOGBOOK() and =VISIT_STATUS() formulas remain stagnant.

If your operation requires passive GPS tracking, geofencing that auto-detects arrivals, or routes with 30+ stops per vehicle optimized for time-window constraints, Google Sheets cannot handle the processing. In those cases, abandon the spreadsheet and use dedicated routing software like Onfleet, Routific, or Circuit. InstaMaps works best for local delivery farms, multi-family real estate checks, and service calls under 11 stops per crew. If you are processing 500+ stops a day across 20 crews, the manual drag-and-drop required to assign stops in Column C will bottleneck your morning dispatch. Switch to a dedicated platform.

Template access and lookup limits

Download the exact workbook pattern shown above at get-instamaps.com/templates. This provides the pre-formatted columns, crew assignment logic, and embedded InstaMaps formulas ready for your delivery data.

The InstaMaps Google Sheets add-on is free to use. To insert the formulas without manually typing the syntax, open the add-on via Extensions > InstaMaps > Enable formulas. Use the sidebar to select your ranges, or click the Build-the-workflow button to automatically write formula chains across your sheet.

By default, the free tier allows 100 lookups per day. A lookup occurs when a formula processes a new address, such as =GEOCODE() or =REVERSE_GEOCODE(). If you are running a 200-home farm dataset, you will hit the 100-lookup limit before geocoding half the list. You can scale this limit to 1,000 lookups per day by completing a free email unlock directly within the add-on sidebar.

Common Questions