route optimization

[Phil_Waite]

Hi,

I currently use zeo routeplanner for my appsheet app to create routes. I just need the order number which I then put back into my appsheet app and create delivery paperwork in order from the drop numbers. 

Is there a way I can do route optimization in googlesheets or with appsheet so I donl;t have to use Zeo.

I found this example app but it doesn't weem to work. 

https://www.appsheet.com/templates/Routing-tool-for-drivers-and-dispatchers-using-Google-Maps-API?ap...

I just need to get drop numbers including froma starting and finishing point.

Thanks

Phil

[Landan_QREW]

If I am following correctly, I think you can use this API. I used this in a project recently to order stops in a route.

I would recommend using Apps Script to manage this process. You can use an AppSheet bot to call your Apps Script.

[alberto8]

What was the process with which you created the app, can you help me please?

[JorgeGzz1284]

I collected the information I wanted from latlong, in a list separated by / with element type lat long and then integrated this formula as a link
formula: "https://www.google.es/maps/dir/"&TEXT([listlatlong])&"/@"&TEXT(INDEX([_THISROW].[listlatlong], COUNT([_THISROW].[listlatlong])))& "&z=" & "6" & "&layer=t"
like this is the link to maps

https://www.google.es/maps/dir/32.474699, -116.999123/32.470786, -117.002521/32.426081, -116.962947/...