EasyRoutes + Google Sheets
Add stop latitude/longitude values to Google Sheets rows for newly completed EasyRoutes routes
Need to log delivery stop locations for reporting, analysis, or delivery heat map generation? This automation creates a row in Google Sheets for each new stop on a completed EasyRoutes route, detailing precise latitude and longitude coordinates to help track delivery patterns or visualize route data from a centralized source.
Need to log delivery stop locations for reporting, analysis, or delivery heat map generation? This automation creates a row in Google Sheets for each new stop on a completed EasyRoutes route, detailing precise latitude and longitude coordinates to help track delivery patterns or visualize route data from a centralized source.
- When this happens...Route Updated
Triggers on any route updates (create, update, delete, etc). You may configure which specific updates you want to subscribe to via the topics input configuration. The payload for these events is the updated route.
- automatically do this!Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
- Free forever for core features
- 14 day trial for premium features & apps
TopicsRequired
Try ItClient Stop ID
Order Name
Address 1
Address 2
City
Province Code
Country Code
Zip
First Name
Last Name
Company
Phone
Email
Latitude
Longitude
Note
Priority
Attributes
Tags
Type
Delivery Date
Shopify Attribute Names
Shopify Attribute Values
Item Name
Quantity
Grams
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try It
Stop Status Updated
Triggers when a stop status is updated on a route (i.e. ready for delivery, out for delivery, attempted, delivered). The payload is the updated stop. The deliveryStatus field will indicate the updated status.
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try It
