Export Google Local Results to CSV
John
Search Google local listings and download them as a CSV: name, address, type, rating, reviews, and price. Exports to Excel and Sheets too.
Input
Output fields
Sign up on Apify or log in
The Google Local API | Local Pack & Business Search SERPs Actor is ready to run with the inputs already set for "Export Google Local Results to CSV". Sign up or log in and you'll land in Apify Console with a copy of this exact task.
Start the "Export Google Local Results to CSV" task
The Google Local API | Local Pack & Business Search SERPs Actor will start running based on the input automatically. You can also change all the input fields, like search query, to match your specific use case.
Receive the "Export Google Local Results to CSV" output
Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as local results.
Integrate into your workflow
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Export Google Local Results to CSV" task via API.

Export Google Local Results to CSV uses the places view, which keeps only local_results: position, title, type, rating, reviews, price, address and place_id for each business. Excel and Google Sheets open the CSV directly.
The example sends q set to coffee and nothing else. Add location, such as Austin, Texas, United States from the README, to pick a city, and raise max_pages when one page of coffee shops is not enough.
Run the task through its run endpoint on the Apify API, then request the dataset items with format=csv and view=places. apify-client in Python or Node can start the run and save the CSV in a few lines.
In the Apify Console open the task, choose Actions, then Schedule, and set 0 9 * * 1 for Mondays at nine. Each run makes a new dataset to download as CSV, or a webhook can send the file onward.
Add https://mcp.apify.com/?tools=actors,docs,johnvc/google-local-api in Claude or any other MCP client and ask for coffee shops in a city as a CSV table. The agent runs the Google Local API and formats local_results as rows you can copy out.
The Google Local API bills a setup charge per run plus one per page processed, no subscription. Downloading the coffee export as CSV, Excel or JSON adds nothing; only the pages fetched and setup are billed. The rate is on the Actor page.
Find med spa leads uses the overview view, which wraps local_results in search_parameters and search_metadata. Export Google Local Results to CSV uses the places view, so the download carries only the business listings.