55,009 views
I teach you how to connect Google Sheets with Google Maps to calculate routes with distances and times between addresses and coordinates. Code to convert addresses to latitude and longitude: https://tesel.mx/producto/plantilla-p... You can purchase the finished template with the most current code here: https://tesel.mx/producto/plantilla-p... You can read the original post on our website: https://tesel.mx/calcular-rutas-con-d... Direction Finder Documentation: https://developers.google.com/apps-sc... Do you like our content and want to help keep the channel running? Consider making a voluntary contribution here: https://pay.tesel.tech/u/tesel/USD/20 Subscribe to the channel to stay up-to-date with more technology guides and information. Looking for a reliable technology provider? Contact us at https://tesel.tech! We are also certified Google Partners and can help you have Google Workspace in your business. English: Follow us on our networks: Twitter: / teseltech Facebook: / teseltech Voiceover: Alekz https://alekz.tech Alekz Twitter: / aalkz Production: Alekz for Tesel Background music: Jason Shaw, used under the Creative Commons license 00:00 Intro 00:15 Calculating routes with Google Maps and Google Sheets 00:53 Preparing our addresses and coordinates 01:30 Preparing our route and distance sheet 01:54 Setting up our Apps Script project 02:47 Creating the route between the points 05:34 Calculating distances between addresses in our sheet 06:57 Writing the route in the sheet 08:40 Complete code to calculate routes in Google Sheets 08:49 Checking the data in Google Maps 09:33 Official documentation and usage limits 10:21 Like and subscribe to Tesel