β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
π 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
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
Reviews Table

View all reviews with:
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
Filters
Rating: Filter by star rating (e.g., show only 1-2 star reviews)
Owner Response: Filter by "With Response" or "No Response"
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
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