Google Sheets API Expert Needed
Budget: $10 – $30 USD
I have a need 2 formula created for a google sheet.
I am using the following formula to give me the miles between 2 locations. The formula I'm using works perfectly works perfectly however I need to be able to use the same formula but using my API key so that I will not have a limit on the amount of times I can do an API request.
A1 B1 C1
Start Location End Location Miles
Atlanta, Ga Miami, FL =GOOGLEMAPS(A1,B1,"miles")
A4
=HYPERLINK("https://www.google.com/maps/dir/"&A18&"/"&B1,"Get Directions")
Here an example:
https://docs.google.com/spreadsheets/d/19ywT5oUwNV8hggvs_4VuzTRtBa1wbaoTjQNiPKeM5h0/edit?usp=sharing
I am using the following formula to give me the miles between 2 locations. The formula I'm using works perfectly works perfectly however I need to be able to use the same formula but using my API key so that I will not have a limit on the amount of times I can do an API request.
A1 B1 C1
Start Location End Location Miles
Atlanta, Ga Miami, FL =GOOGLEMAPS(A1,B1,"miles")
A4
=HYPERLINK("https://www.google.com/maps/dir/"&A18&"/"&B1,"Get Directions")
Here an example:
https://docs.google.com/spreadsheets/d/19ywT5oUwNV8hggvs_4VuzTRtBa1wbaoTjQNiPKeM5h0/edit?usp=sharing