Google API in excel

Ok so this might sound a little garbled but I am a noob and trying to teach myself this and having trouble knowing where to start. I am trying to build myself a spreadsheet that I can input addresses into and it will automatically calculate the miles the time so then I can use what the line haul is paying to determine whether or not it meets the criteria for what I need to make per mile before I accept or turn down the road. I have seen some premade distance calculators in Excel, but they are a little pricey and they are also proprietary, which means that I can’t alter them to add an additional data that I need for calculating my runs. In the research that I’ve done I know that I need to get a Google route API key as use power query in order to get the API to function correctly in my Excel workbook. But what I don’t understand is how to make everything native to my workbook. Example I would like column a to be start address and column B to be the finish address and to just be able to input the City or the address in each column and calculate it without having to open power query or a separate window or pull the data from somewhere else if that makes sense. So I know that I need to make some sort of VBA loop function and a macro inside my workbook that will do that for me, but this is where I’ve hit the wall of my very, very very small amount of knowledge. I know that I’m going to need to go into the API documentation and alter the programming to suit my needs because I don’t need all of the information that the API key has in it. I only need the start to finish the miles and the time. So what I’m running into is threefold a how to alter the programming which some of my programmer friends have told me to just use Claude, which I get, but I still would like to learn a little bit, but I’m not too proud; B how to do a VBA loop function that will record what I needed to do so I don’t have continue to open power query, and instead have it native to the workbook and three link all of that to a macro which I think I can figure out on my own because I do know that much. I hope this makes sense. I know that there are some videos out there that explain this to some degree but but it’s usually for functions that don’t apply to this. I appreciate any help and if I’m just being dumb and need to pay the hundred and 150 bucks to just have it done for me that would be the ability to modify the workbook then I’ll just suck it up and do so. I just find that I’m fascinated by this and I do think it would be an interesting skill have I just feel like I need a bit of help finding the resources I need to teach myself this