Download a list of store reviews from Google Places in CSV format

Obtain data from Google Places using the text search information acquisition API and facility store detailed information acquisition API.

Google Places is a service where Google compiles information about businesses and places.
By using Google Places, you can get information about "places," which are defined as facilities, geographic locations, and famous spots available on Google Maps.
This application uses the facility and store information obtained using the Google Places text search information acquisition API to obtain the store name, address, and reviews using the facility and store detailed information acquisition API.
Please use the pre-registered APIKEY and text search characters.

• Download specifications
• Try HULFT Square

How to install and use it

Script Details

No.13_GooglePlaces_GooglePlaces_Store review information acquisition (01 Main)

Call the GooglePlaces text search information retrieval API to retrieve facility store information that matches the text search.
Based on the acquired facility store information, the facility store detailed information acquisition API is called for each facility store to acquire facility store details and reviews.
The results obtained from the API are in JSON (XML) format, but HULFT Square converts them to CSV format before outputting them for easier secondary processing.
Set the APIKEY you registered in advance in the script variable [APIKEY], and the string you want to search for in the script variable [Text search string].
The output destination for the downloaded data is set to "/OpenData/OpenData_No13_GooglePlaces_GooglePlaces_Store Review Information Acquisition" in HULFT Square Storage. If you want to download to a different output destination, change the "Review Information CSV Output" file to the desired path.

• Download specifications
• Try HULFT Square

How to install and use it