Collect local business data from Google Maps and send it into Google Sheets on a repeatable schedule. Great for sales and growth teams that need fresh, clean prospect lists without manual copy and paste.

A schedule or manual start reads a sheet of Google Maps search URLs and status flags. A parser pulls the keyword and location from each URL, then calls SerpAPI to fetch places and follows the next page links to capture all results. Code nodes merge pages, format fields, and drop blank entries. A duplicate check uses place id before rows are appended or updated in Google Sheets, and the status turns to Success or Error.

You only need a Google account for Sheets and a SerpAPI key. Expect faster list building, better data quality, and repeatable runs every hour or whenever needed. Ideal for building local outreach lists, auditing locations, and tracking competitors in a city.

• Hourly schedule and manual run options for flexible execution
• Reads Google Maps search URLs and status flags from Google Sheets
• Extracts keyword and geo coordinates from each search URL
• Calls SerpAPI for Google Maps data and follows next page links
• Merges all pages, formats fields, and filters out empty items
• Removes duplicates using place id to keep the sheet clean
• Appends or updates rows in Google Sheets and sets status to Success or Error

• Reduce manual work from hours to minutes for each search batch
• Streamline lead collection by up to 80 percent with scheduled runs
• Improve data quality by removing 100 percent of duplicate place ids
• Handle up to 10 times more results with automatic pagination merge
• Connect Google Sheets and SerpAPI in one reliable flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and SerpAPI. See the Tools Required section above for links to create accounts with these services.
3. Create a copy of the provided Google Sheets template and share it with the Google account you will use in n8n. Add your Google Maps search URLs in a column named URL and include a Status column for tracking.
4. Open the node named Google Sheets - Get searches to scrap and set the Document ID to your copied sheet URL. Select the correct sheet tab that holds your search URLs and Status.
5. Set up Google Sheets credentials in n8n Cloud: double click a Google Sheets node, choose Credential to connect with, click Create new credential, then follow the on screen instructions to sign in with your Google account and grant access. Give the credential a clear name.
6. Get your SerpAPI API key from your SerpAPI account page. In n8n, open the node named SERPAPI - Scrape Google Maps URL, choose Credential to connect with, click Create new credential for SerpAPI, and paste your API key.
7. Confirm URL parsing: open the Set node named Extract keyword and location from URL and ensure your sheet has a URL column that matches the expected Google Maps search URL format.
8. Open the node Add rows in Google Sheets and point it to your results tab. Review the field mapping so the output columns like title, phone, rating, reviews, and address land in the right columns.
9. Adjust the Schedule Trigger if needed. Open Run workflow every hours and set the interval to your preferred frequency.
10. Test the flow: click Execute Workflow. Watch the execution log to see SerpAPI requests, merge steps, and sheet updates. Verify new rows appear and that Status changes to Success.
11. Troubleshoot common issues: if no data appears, check that your search URL is a valid Google Maps search link. If you see errors, confirm the SerpAPI key is active and not rate limited. Make sure the Google Sheet is shared with the connected Google account and that the sheet and tab names match in each node.
12. Activate the workflow once the test passes so it runs on the set schedule and keeps your prospect list up to date.