Pull Business Data from Google API

Hello, I am looking for a way to pull business data from Google. I believe this can be done with Google API. I will need the data pulled into a Google sheet (see below link to template). I am specifically looking to pull data for businesses that 1) fall within categories: Advertising Agency, Marketing Agency, Internet Marketing Service & Website Designer, and 2) are within certain US cities: Los Angeles, New York, San Fransisco, Chicago, Miami etc..

https://docs.google.com/spreadsheets/d/1guAQmEzKBljw5iuA4_DbUmNDr-tisXntsosPCSiyqng/edit?usp=sharing