SUMMARY: We need a Python script to retrieve SerpAPI's Google Map data and export it a spreadsheet. We need the script to paginate the search to return as many results as possible for a given coordinate, and then iterate that entire script for several more Latitude/Longitude coordinates. This would effectively search for and list results for several different geographic areas and export them all to the same spreadsheet. I already have a basic script in motion from ChatGPT but am struggling to get it to paginate correctly AND iterate over several coordinates. I'm happy to share the script as as starting point if it's helpful. FUNCTIONALITY AND INPUT VARIABLES I need to be able to easily change the following variables, but these variables will remain constant as we iterate the search for several coordinates: • A text query in this format: "heating and air companies" • A Google Maps zoom level in this format: 15z • A maximum number of results, which can be a multiple of 20 according to SerpAPI's documentation since their google Maps PAI pulls 20 per page 60 • `data` An optional parameter for advanced searching that we can input whatever we want. Example that we'd input to filter to 3.5 stars and higher: !3m1!4b1!4m3!2m2!5m1!4e8 • Then, the script will iterate these parameters over a list of Latitude Longitudes (can be listed however is easiest. E.g. comma separated, hard returns, etc.): @34.0496942,-84.6792922 @35.0792945,-85.2996335 @35.9695067,-83.919476 OUTPUT: Exporting resulting data to a spreadsheet. The final file MUST have the following data if available: - Filename structure: serpapi_`yymmdd`_`query`.xlsx - Google Business Name - *Google "Book online" link URL (if it exists) - Google Company Website - Google Company Phone - Google Company address - Google Rating - Google Rating Count - Google Place ID - Original variable used for search query (e.g. "heating and air companies") - Original variable used for google maps zoom level - Original variable used for coordinates - Original variable used for data TRAINING: 15-30 minute call once the buildout is complete to briefly walk me through how it works and answer a few questions on how we can iterate on it. REQUIREMENTS: We must be able to pull as many results are available using pagination and then iterate the search over however many Coordinates we have, all exporting to the same spreadsheet. The goal is to be able to pull several thousand results at a time, or however many is reasonable. RESOURCES: SerpAPI's Google Maps playground example: https://serpapi.com/playground?engine=google_maps&q=heating+and+air&ll=%4033.952026%2C-84.5540039%2C15.5z&hl=en&data=!3m1!4b1!4m3!2m2!5m1!4e8&type=search Somewhat unrelated but helpful overview of SerpAPI Google Maps and how the parameters use coordinates, query, pagination, and "zoom level" of Google maps to return results https://www.youtube.com/watch?v=naigldB0nTY&t=248s And again, I have a Python script draft that can be used to start with/understanding what I'm looking for.

I need someone to create two maps with errors showing the route. I will attach an example and the two routes I need done to look similar.

Seeking a professional experienced with google maps/ local listings. We have several locations and a large service area and our google listing/ pin never shows ever in local results, additionally we cannot get our reviews to show in all locations of the business. Its a mess and we need help.