Google Maps Review Extraction and Sheet Synchronization - n8n Workflow

Marketing and SEO professionals needing to monitor local business reputation data.
Businesses that want a centralized spreadsheet of their customer feedback.
Users seeking advanced n8n templates showcasing dynamic looping and state management.
Anyone looking for a reliable, automated solution for data extraction using an n8n node.

Tracking local business reviews is critical for reputation management and competitive analysis. Manually collecting this data can be tedious and time-consuming. This n8n workflow solves this by providing a robust, automated pipeline. Using the SerpApi n8n node, the automation finds businesses based on a user-defined query and then systematically fetches pages of associated reviews. The inherent complexity of Google Maps API pagination is managed entirely within the flow using specialized code nodes and flow control. This specific n8n workflow ensures that whether your search returns a single business or a list of competitors, the review data is reliably extracted, structured, and synchronized to a connected Google Sheets document. This powerful n8n template saves countless hours and provides clean, actionable data.

The process begins with the Execute Workflow n8n trigger, initiating the data retrieval. First, the Set Review Limit n8n node establishes the maximum number of reviews to fetch per business (default is 50). The core search happens via the Search Google Maps SerpApi n8n node, using a standard Google Maps query (e.g., 'italian restaurants in austin tx').

The If - Local or Place Results n8n node then intelligently branches the flow, determining if the search returned a single business (placeresults) or multiple local businesses (localresults). If multiple results are found, the Split Local Results and Loop Over Places n8n nodes initiate an iterative process to handle each business sequentially.

For each business, the Initialize Vars code n8n node sets up necessary variables (like placeid, placename, and pagination counters). The Get Reviews SerpApi n8n node fetches the first batch of reviews. Reviews are checked by the If Reviews Present n8n node, then split by the Split Reviews n8n node, and finally appended to the target sheet using the Append Reviews Google Sheets n8n node.

Crucially, the Update Review Count & Next Page Token n8n node updates the global state variables required for pagination. The Route Next Step switch n8n node directs the flow: it either loops back to fetch the next page of reviews, proceeds to the next business in the list, or successfully terminates the n8n workflow. The flow uses the Set num for Pagination n8n node to correctly adjust the requested review count for subsequent pages.

To use this n8n template, follow these setup steps:

1. Import: Import the provided JSON file into your n8n instance to set up this complex n8n workflow.


2. SerpApi Credentials: Set up your credentials for the SerpApi n8n node. Your API key can usually be found in your SerpApi dashboard.


3. Google Sheets Setup: Connect your Google Sheets account as a credential in n8n.


4. Spreadsheet Creation: Create a new Google Sheet with the exact column headers required: name, iso_date, rating, and snippet.


5. Configure Google Sheets n8n Node: Open the Append Reviews n8n node and connect it to your newly created Google Sheet document ID and sheet name.


6. Customize Search Query: Update the Search Google Maps SerpApi n8n node with your specific geographical or business search query.


7. Execution: Use the manual Execute Workflow n8n trigger to test the automation and begin syncing your review data.

Execute Workflow (n8n trigger): The manual n8n trigger used to start the data synchronization process.
Set Review Limit (Set n8n node): Defines the maximum number of reviews that will be retrieved for any single place. Default is set to 50.
Search Google Maps (SerpApi n8n node): Performs the initial Google Maps search based on a user-defined query, returning potential local business results.
If - Local or Place Results (If n8n node): A critical flow control n8n node that checks the JSON output structure to determine if a single place or multiple local results were returned.
Initialize Vars (Code n8n node): Sets up required static workflow data variables, including the placeid, placename, and pagination variables (count, nextpagetoken). Essential for maintaining state within this iterative n8n workflow.
Get Reviews (SerpApi n8n node): Fetches reviews using the googlemapsreviews operation, dynamically handling the nextpagetoken for sequential page requests.
Split Reviews (Split Out n8n node): Prepares the array of reviews for bulk insertion by the subsequent Google Sheets n8n node.
Append Reviews (Google Sheets n8n node): The data sink; appends the extracted and structured review data to the target spreadsheet.

• Route Next Step (Switch n8n node): Manages the complex pagination and looping logic, deciding whether to fetch the next page of reviews, loop to the next business, or end the n8n workflow.