Schools nearby addresses (Google Places nearby)

[Joe Abraham]

Hi,

I am trying to get address of the closest school near a list of addresses in google sheets. I am currently doing this manually by searching address on google maps and then search nearby and enter "school". Then visually check closest school. I wish there will be some script I can use using google places API. I am new to google script and would appreciate some one shedding some light or useful direction.

Thanks in advance

JSA