Google Maps reviews to Google Sheets sync using SerpApi
UnknownWhat this workflow does
This workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Serpapi (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Review Limit (Edit Fields (Set)): sets 1 field: review_limit
- Search Google Maps (Serp Api): google maps
- If: checks a condition and branches into true / false
- Initialize Vars (Code): runs custom JavaScript code
- Split Local Results (Split Out): splits a list into separate items
- Get Reviews (Serp Api): google maps reviews
- Loop Over Places (Loop Over Items (Split in Batches)): loops over the items in batches
- If: checks a condition and branches into true / false
- Split Reviews (Split Out): splits a list into separate items
- Append Reviews (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-serpapi is verified or supports 3.0 (used in Search Google Maps, Get Reviews).
Nodes used (9)
- If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Serp Api
n8n-nodes-serpapi.serpApi - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
Sync Google Maps Reviews to Google Sheets for Any Google Maps Query How it works This workflow accepts any query you might run on actual Google Maps to search for places. The search happens through SerpApi's Google Maps API. Once the workflow receives place…