EasyRoutes + Google Sheets + Filter by Zapier
Create new Google Sheets rows for new updates to stop statuses in EasyRoutes
Want a centralized record of completed and attempted delivery proof? This integration automatically adds a new row to Google Sheets whenever a stop is marked as completed or attempted in EasyRoutes, containing any collected proof of delivery items (photos, eSignatures, and/or driver notes) all in one place.
Want a centralized record of completed and attempted delivery proof? This integration automatically adds a new row to Google Sheets whenever a stop is marked as completed or attempted in EasyRoutes, containing any collected proof of delivery items (photos, eSignatures, and/or driver notes) all in one place.
- When this happens...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.
- automatically do this...Only continue if...
Set up rules to specify when this Zap can continue running.
- then do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- 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
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
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 ItOnly continue if...Required
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try It
