Route Planner Agent - Google Maps API's [Kinda Solved]

Hey guys 👋

I'm trying to figure out how I connect my n8n instance with the Google Maps Directions API and ask for an effective route based on a list of addresses 🗺️

So my workflow is intended to work like this:

A have a spreadsheet full of clients with their corresponding addresses, and last inspection dates.
Each client needs inspection of their facilities on a given time each year.
I now want to connect a chat trigger to an AI agent, that has the spreadsheet and the Google Maps Direction API as tools. Based on these tools it should be able to read the 'last inspection date" and address from the sheet and based on my demand from the chat, it should reply with a list in chronological order displaying which clients to visit based on their address and last inspection date.

All I know is that I have to connect the Google Maps Directions API by using an HTTP request node - and that's it 😳

Have any of you guys had any luck with this? 🙏

14 comments