What is your goal?
I am building a daily delivery briefing scenario in Make for a local wine delivery service.
The scenario reads paid delivery orders from Google Sheets Orders_Log.
Each row contains:
order_number
delivery_date
delivery_area
delivery_window
delivery_town
accommodation_name
full_delivery_address
customer_whatsapp
delivery_notes
I want Make to generate a Google Maps route link with multiple stops.
Route logic:
Start:
Frazione Campanella 7, Castello di Annone, AT, Italy
Delivery stops:
All paid orders for the selected delivery date, ordered by delivery_area / delivery_window.
Final destination:
Enoteca Assetati, Via Cavour 83/A, Asti, Italy
The route link should be included in an internal email and WhatsApp briefing.
What is the problem & what have you tried?
I already have a Make scenario that reads rows from Google Sheets and aggregates the order data.
I need help understanding the best way to build a Google Maps directions URL from multiple rows.
Questions:
Should I aggregate all full_delivery_address values and join them with / inside a Google Maps URL?
What is the correct format for a Google Maps route URL with multiple stops?
Should addresses be URL-encoded in Make before inserting them into the link?
Is it better to use addresses, Google Maps URLs, or latitude/longitude if available?
How can I order the stops before building the URL?
Is there a limit to the number of stops in a Google Maps directions URL?
Expected result:
A clickable link like:
Example output in the email:
Google Maps route:
Open route
Relevant flow:
Google Sheets — Search Rows
→ Tools / Aggregator
→ Email
→ HTTP WhatsApp
Error messages or input/output bundles
No error yet. I am trying to design the correct formula/structure before implementing it.
Example delivery addresses:
Start:
Frazione Campanella 7, Castello di Annone, AT, Italy
Stop:
via test 8, Mombercelli, AT, Italy
Final:
Via Cavour 83/A, Asti, AT, Italy