Importing Reviews

If you have reviews, ratings, or feedback on Google, Facebook, Yelp, or other sites, you can bring them into MRM so they appear in your dashboard and on your Showcase. This page explains where to find the import options and how each method works. The best way to import Google reviews is the Google My Business integration—it syncs automatically and keeps your ratings and feedback up to date, helping you manage your reputation in one place.

Where to Import

Go to Reviews in the sidebar and click Add. A modal opens with three tabs: Quick Import, Manual Entry, and Upload CSV. For Google reviews, you can also connect Google My Business under Settings > Integrations.

Google My Business (Recommended for Google Reviews)

The Google My Business integration is the best way to import and manage your Google reviews. It syncs your reviews automatically and keeps them up to date—no manual imports or URL pasting. Your ratings and feedback from Google appear in MRM, and you can reply to reviews directly from your dashboard.

How it works:

Go to Settings in the sidebar and click Integrations.
Find Google My Business under Review Integrations and click Connect.
Sign in with your Google account and authorize the connection.
Choose which business locations to sync. Reviews from those locations are imported and kept up to date.
Click Sync or Resync anytime to pull in the latest reviews.

Once connected, new Google reviews appear in MRM automatically. You can reply to them, assign tags, filter by location, and display them on your Showcase. Reviews stay in sync, so you always have the latest ratings and feedback in one place.

Google My Business is the recommended method for importing Google reviews. It syncs automatically, supports multiple locations, and lets you reply to reviews from MRM—so you can manage your reputation without switching between tools.

If you have multiple locations, select which ones to sync when connecting. Reviews will be tagged by location so you can filter and report by store or branch.

Quick Import (from a Website URL)

Import reviews directly from a public review page. Paste the URL and MRM will fetch the reviews for you. Use this when you don't have the Google My Business integration or when importing from Facebook, Trustpilot, Yelp, or LinkedIn.

Supported sites: Google, Facebook, Trustpilot, Yelp, LinkedIn

Steps:

Go to Reviews and click Add.
Open the Quick Import tab.
Under Website, choose the review site (Google, Facebook, Trustpilot, Yelp, or LinkedIn).
Paste the URL of your business's review page. The placeholder shows the format—for example, your Google Maps place URL or your Facebook reviews page.
If you use locations, optionally assign the imported reviews to a location.
For Google, Facebook, Trustpilot, and Yelp, you can check Positive only to import only 4- and 5-star reviews.
Click Import Recent Reviews.

The import runs in the background. You'll see a confirmation when it's scheduled. Reviews appear in your list shortly after. You may receive an email when the import completes.

For Google reviews, prefer the [Google My Business integration](#google-my-business-recommended-for-google-reviews) for automatic, ongoing sync. Quick Import from a URL is a one-time fetch.

The URL must point to a public review page. If the page structure changes or the site blocks the import, the import may fail. You'll receive an email if that happens.

Manual Entry

Add one review at a time. Enter the customer's name, contact info, rating, review text, date, and optionally the source, location, and tags.

Steps:

Go to Reviews and click Add.
Open the Manual Entry tab.
Fill in the customer section (first name, last name, email, phone, company).
Fill in the review section (rating, review text, date, source, location, tags).
Click Save.

The review appears in your list immediately.

Manual entry is ideal when you have a few reviews or want to add one quickly. For larger batches, use Quick Import or CSV upload.

CSV Upload

Upload a CSV file to import up to 1,000 reviews at once. The import runs in the background; you'll see a confirmation when it's scheduled. Reviews appear in your list shortly after. You may receive an email when the import completes.

Steps:

Go to Reviews and click Add.
Open the Upload CSV tab.
Click Download Template to get a sample file with the correct headers.
Fill in your data and save as CSV (UTF-8).
Click Upload CSV and select your file.

CSV Headers

Header	Required	Description
first_name	Yes	The reviewer's first name.
last_name	No	The reviewer's last name.
email	No	The reviewer's email address.
phone	No	The reviewer's phone number.
company	No	The reviewer's company name.
score	Yes	The rating (1–5).
review	No	The review text.
source	No	The slug or UUID of a source. Must match a source in Settings > Sources.
location	No	The slug or UUID of a location. Must match a location in Settings > Locations.
tags	No	Comma-separated list of tag slugs. Tags must exist in your project and be for reviews.
created_at	No	The date of the review. Use YYYY-MM-DD format.

What happens during import: Each row creates or finds a customer (by email or phone) and attaches a review to them. If the customer already exists, the review is added to their profile. If not, a new customer is created.

Each row must have either an email or a phone number so MRM can associate the review with a customer. Without a way to identify the reviewer, the import may skip or fail for that row.

Download an example CSV template from [melo.ca/csv/reviews.csv](https://melo.ca/csv/reviews.csv).

After Import

Google My Business – Reviews sync automatically. New reviews appear in MRM as they come in. Use Sync or Resync on the integration page to pull the latest data.
Quick Import – The import runs in the background. You may receive an email when it completes. Reviews appear on the Reviews page as they are processed.
CSV Upload – Same as Quick Import. The import is scheduled and runs in the background.
Manual Entry – The review appears immediately.

Once reviews are in your project, they appear in your Showcase, widgets, and analytics. You can reply to them, assign tags, or filter by location.

Tips

Connect **Google My Business** first if you have Google reviews. It's the easiest way to import and manage your reputation—reviews sync automatically and you can reply from MRM.

Use the **Positive only** option when importing from Google, Facebook, Trustpilot, and Yelp if you want to focus on 4- and 5-star reviews for your showcase or marketing.

If you have multiple locations, assign a location when importing so you can filter and report by location later.

Tags in the CSV must use tag slugs (the URL-friendly name) and must already exist in your project under Settings > Tags. Use comma-separated values for multiple tags. Tags must be for reviews, not customers.