{"product_id":"n8n-workflow-auto-draft-google-maps-review-replies-serpapi","title":"n8n Workflow: Auto Draft Google Maps Review Replies (SerpApi)","description":"\u003ch3\u003eAuto-Draft Google Maps Review Replies with n8n (SerpApi + Claude via OpenRouter)\u003c\/h3\u003e\n\u003cp\u003eTurn new Google Maps reviews into ready-to-approve public responses—automatically. This n8n workflow uses \u003cstrong\u003eSerpApi\u003c\/strong\u003e to pull fresh, unanswered Google Maps reviews, then uses \u003cstrong\u003eOpenRouter (Claude)\u003c\/strong\u003e to classify each review and draft an appropriate reply. Drafts are saved to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for approval and a single \u003cstrong\u003eGmail\u003c\/strong\u003e digest is emailed to you.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually or on a schedule\u003c\/strong\u003e and loads your property details, review tone, and the target Google Maps \u003ccode\u003edata_id\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads previously drafted review IDs\u003c\/strong\u003e from Google Sheets to avoid duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches newest reviews via SerpApi\u003c\/strong\u003e and filters to only reviews that are \u003cstrong\u003enew\u003c\/strong\u003e, \u003cstrong\u003eunanswered\u003c\/strong\u003e, and contain meaningful text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies each review with OpenRouter (Claude)\u003c\/strong\u003e into: standard, needing reservation verification, or possibly fake\/disputed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts a category-specific public reply\u003c\/strong\u003e and includes an internal note.\u003c\/li\u003e\n  \u003cli\u003eAdds confirmation tags when needed (e.g., \u003ccode\u003e[VERIFY RESERVATION: ...]\u003c\/code\u003e, \u003ccode\u003e[CONFIRM: ...]\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves each draft\u003c\/strong\u003e to Google Sheets as an approval log entry (so it won’t be drafted again), labeled as \u003cstrong\u003ePENDING APPROVAL\u003c\/strong\u003e or \u003cstrong\u003eNEEDS DATA\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one HTML Gmail digest\u003c\/strong\u003e containing all newly created drafts from the run.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall and mid-size businesses that need consistent, timely responses to Google Maps reviews.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers and SaaS operators managing multiple properties and wanting a controlled approval flow.\u003c\/li\u003e\n  \u003cli\u003eTeams that want reservation verification prompts before committing to specific follow-ups.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/credentials: \u003cstrong\u003eSerpApi\u003c\/strong\u003e, \u003cstrong\u003eOpenRouter (Claude)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets (OAuth2)\u003c\/strong\u003e, \u003cstrong\u003eGmail (OAuth2)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSetup includes duplicating the provided Google Sheets template and configuring \u003ccode\u003eapproval_sheet_id\u003c\/code\u003e, plus your Google Maps \u003ccode\u003edata_id\u003c\/code\u003e, tone, signature, offline contact email, and digest recipient.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830414631091,"sku":"N8N-18228","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xlqz8sR2JzxAF-LYn3HJb_LH2ElMKM.png?v=1786698600","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-draft-google-maps-review-replies-serpapi","provider":"N8N Commerce","version":"1.0","type":"link"}