⭐Google Business Reviews Fetcher
The Google Business Reviews Fetcher automatically collects and tracks Google reviews for a single business location. Instead of manually checking Google Maps for new reviews, this tool fetches review data on a schedule and tracks changes over time through snapshots.
Why Use This Tool
Perfect for:
Businesses monitoring their Google reviews over time
Tracking new reviews as they come in
Building a historical record of all reviews
Exporting review data for reporting or analysis
Monitoring owner response rates
Key Benefits:
📸 Snapshot-based tracking - See exactly what changed each time
🔄 Smart depth calculation - Automatically optimizes API costs
📊 Deduplication - Only tracks new reviews, skips duplicates
👁️ Visibility tracking - Detect when reviews disappear or reappear on Google
🔔 Email alerts for low-rating reviews via Automations
💾 Export reviews to CSV for analysis
⏰ Scheduled or manual fetching
Quick Start Guide
This tool requires you to set up a Google Places API key to search for Google businesses. Please read the guide at: Setup Google Places API key
Step 1: Add a Business
Navigate to Google Business Reviews Fetcher in the sidebar
Click "Create New Fetcher"
Search for your business using the business search field
Enter a friendly name (e.g., "Downtown Seattle Location")
Step 2: Configure Fetch Settings
Initial Depth (First run only)
How many historical reviews to fetch on first run
Range: 10 - 4,490 reviews (in multiples of 10)
Example: Set to 1,000 to fetch complete review history
This only runs once - pulls all historical reviews
Subsequent Depth (Optional)
How many reviews to fetch on future runs
Leave at 0 for automatic (recommended)
Or set a custom value if you know your review volume
How Automatic Depth Works:
Schedule Interval
0 = Manual only (you click "Fetch Data" when needed)
7 = Weekly (runs every 7 days)
30 = Monthly (runs every 30 days)
Custom = Any number of days
Location & Language
Select the geographic location and language for review fetching
Example: United States - English
Queue Priority
Standard Queue: Up to 45min processing, $0.00075 per 10 reviews
Priority Queue: Up to 1min processing, $0.0015 per 10 reviews
Step 3: Save and Run
Click "Add Business"
Initial fetch starts automatically
You'll be redirected to the snapshot page showing progress
Understanding the Business Detail Page
After creating a business, you'll see the detail page with:
Business Information Card
Shows configuration and tracking details:
Address: Business name and location
Place ID: Google's unique identifier for this business
Schedule: How often reviews are fetched (Manual, Weekly, etc.)
Queue Priority: Standard or Priority processing
Initial Depth: Number of reviews fetched on first run
Last Run: When reviews were last fetched
Total Snapshots: How many times reviews have been fetched
Location & Language: Geographic and language settings
Snapshots History Table
Every time you fetch reviews, a new snapshot is created. The table shows:
Columns:
Date: When the snapshot was created
Depth: How many reviews were requested from the API
Found: Total reviews returned by Google
New: Reviews that didn't exist in previous snapshots
Duplicates: Reviews already captured in previous snapshots
Status: Pending → Processing → Completed (or Failed)
Type: Scheduled (automatic) or Manual (you clicked "Fetch Data")
Example Snapshot Flow:
Actions
Fetch Data: Manually trigger a new snapshot
Edit: Change business settings (except business selection)
Delete: Remove business and all snapshots
Bulk Actions
From the main business list, you can select multiple businesses using the checkboxes and perform bulk actions:
Fetch Reviews: Trigger a review fetch for all selected businesses at once. The fetches run sequentially to avoid API overload.
This is useful when you want to manually refresh reviews for multiple businesses before generating reports.
Viewing Review Data (Snapshot Page)
Click on any snapshot date to view the reviews captured in that snapshot.
Snapshot Information
Shows details about this specific fetch:
Date: When this snapshot was created
Depth: How many reviews were requested
Reviews Found: Total reviews returned by Google
New Reviews: Reviews discovered for the first time
Duplicates Skipped: Reviews already in previous snapshots
Status: Completion status
Type: Manual or Scheduled run
Business Rating: Overall star rating and total review count
Missing Reviews: Reviews that disappeared from Google since last snapshot (shown only if > 0)
Reinstated Reviews: Reviews that reappeared after being missing (shown only if > 0)
Reviews Table
Cumulative View (Default)
By default, the snapshot page shows all reviews ever collected for this business with their current visibility status. This gives you a complete picture of all reviews regardless of which snapshot first captured them.
To see only reviews from this specific snapshot, enable the "Only show reviews in this snapshot" toggle above the table.
Review Columns:
Reviewer: Name, photo, profile (if available)
Shows review count and photo count
"Local Guide" badge if applicable
Rating: Star rating (1-5)
Number of "helpful" votes
"View on Google" link to see review on Google Maps
Review Date: When the review was posted
Review Text: Full review content
Expandable for long reviews
Shows review images if attached
Owner Response: Business reply to the review
Shows if owner has responded
Full response text
Status: Review visibility status (see below)
Review Visibility Tracking
The tool automatically detects when reviews disappear or reappear on Google by comparing each fetch with the previous one. Each review has a visibility status:
New
First time discovered in this fetch
Visible
Currently visible on Google
Missing
Was visible before but no longer on Google (deleted by reviewer or removed by Google)
Reinstated
Was missing but has reappeared on Google
Why do reviews go missing? Reviews can disappear from Google for several reasons:
Reviewer deleted their review
Google removed it for policy violations
Google's spam filter flagged it (may be reinstated later)
Temporary Google Maps data issues
Filters
Rating: Filter by star rating (e.g., show only 1-2 star reviews)
Owner Response: Filter by "With Response" or "No Response"
Visibility: Filter by status (New, Visible, Missing, Reinstated)
Search: Search reviewer names or review text
Export
Click Export to download all reviews (respects current filters) as CSV for:
Client reporting
Analysis in Excel/Google Sheets
Integration with other tools
Long-term archiving
Example Workflows
Workflow 1: New Business Setup
Goal: Track reviews for a coffee shop with ~200 total reviews
Setup:
What Happens:
First run: Fetches 500 reviews, finds 187 total
Week 1: Auto-fetches ~21 reviews, finds 2 new reviews
Week 2: Auto-fetches ~30 reviews (2×2 buffer), finds 3 new
Week 3: Auto-fetches ~30 reviews, finds 1 new
Ongoing: Adapts based on review frequency
Workflow 2: High-Volume Business
Goal: Track reviews for busy restaurant getting 5-10 reviews/day
Setup:
What Happens:
First run: Fetches 4,490 reviews (complete history)
Day 3: Auto-fetches ~27 reviews, finds 18 new
Day 6: Auto-fetches ~36 reviews (18×2), finds 22 new
Day 9: Auto-fetches ~44 reviews (22×2), finds 15 new
Ongoing: Automatically adjusts to review volume
Workflow 3: Manual Monitoring
Goal: Fetch reviews only when needed (e.g., before monthly reports)
Setup:
What Happens:
First run: Manual click, fetches 100 reviews
Month 1: Manual click, fetches 50 reviews
Month 2: Manual click, fetches 50 reviews
Ongoing: You control when to fetch
Setting Up Low-Rating Alerts (Automation)
Get notified by email when new reviews below your rating threshold are detected using the Automations tool.
How It Works
After each fetch completes, the automation system:
Checks for NEW reviews in the snapshot
Filters reviews by your rating threshold (e.g., 3 stars or lower)
Sends email only if matching reviews are found
Skips notification if no reviews match criteria
Step-by-Step Setup
Go to Automations in the sidebar
Click "Create Automation"
Configure the automation:
Basic Settings:
Trigger Configuration:
Add Action → Send Email:
Email Body:
Click "Save Automation"
Available Template Variables
{{trigger.businessName}}
Business name
"Blue Bottle Coffee"
{{trigger.address}}
Business address
"123 Main St, Seattle, WA"
{{trigger.placeID}}
Google Place ID
"ChIJ..."
{{trigger.newReviewsCount}}
Total new reviews found
5
{{trigger.newReviewsMatchingCount}}
Reviews matching threshold
2
{{trigger.ratingThreshold}}
Configured threshold
3
{{trigger.averageRating}}
Business average rating
4.2
{{trigger.totalReviews}}
Total review count
847
{{trigger.reviewsList}}
Formatted list of matching reviews
(see below)
{{trigger.createdAt}}
Snapshot date
"2024-01-15"
Example Email Output
Besides sending emails, you can set up the Automations tool to send data view webhooks, so you can perform other analyses or automations.
Last updated