Prisma Reviews / Guides / How to Export Google Reviews

By Francisco García Domene, CEO of Prisma Reviews · Updated Nov 2026

How to Export Google Reviews

If the business is yours, you can export its Google reviews without scraping: Google Takeout gives you a one-off JSON copy of your Business Profile data, and the Google Business Profile API returns every review, 50 per page, once Google approves your project. The Places API is not an export tool: it returns 5 reviews per place and Google doesn’t allow storing them. Scraping is the only way to “export” reviews of businesses you don’t manage, and it isn’t an official route. This guide is part of our Google Reviews API guide.

What are the ways to export Google reviews?

How do you export Google reviews with Google Takeout?

Google Takeout exports the data of products tied to your Google account, including Google Business Profile.

1. Sign in at takeout.google.com with the account that owns or manages the profile.
2. Select Deselect all, then tick Google Business Profile.
3. Choose the file type and delivery, and create the export.
4. Download the archive when Google emails you, and look for the reviews files (JSON) per location.

Takeout is free and official, but it’s a snapshot: you repeat it by hand, and you still have to turn JSON into a spreadsheet.

How do you export Google reviews with the Business Profile API?

If you have an approved Google Cloud project, page through reviews.list for each location and write the rows out:

curl "https://mybusiness.googleapis.com/v4/accounts/ACCOUNT_ID/locations/LOCATION_ID/reviews?pageSize=50" \
  -H "Authorization: Bearer $GOOGLE_OAUTH_TOKEN"
# Repeat with &pageToken=<nextPageToken> until there is no nextPageToken

Each page returns up to 50 reviews plus averageRating and totalReviewCount. Ratings come as words (ONE to FIVE), so map them to numbers. Getting access takes a profile verified for 60+ days and an application: see how to get Google Business Profile API access.

Why can’t you export Google reviews with the Places API?

Two reasons. It returns at most 5 reviews per place, and Google’s Places policies list “copy and save … user reviews” among the things you may not do. An “export” built on the Places API breaks both the math and the terms.

Is it legal to scrape Google reviews?

Scraping is not an official Google route, and Google’s terms don’t permit automated collection of its content. Many tools do it anyway, and courts in the US have looked at scraping public data case by case. That’s a legal and business risk you take on yourself, not a technical detail. If the reviews are of your own business, you don’t need to scrape: use one of the official routes above. For the full comparison, read Google Reviews API vs scraper.

How do you export Google reviews to CSV with Prisma?

Connect the Google Maps listing of a place you own or manage (you declare it with owner_attestation), then page through GET /v1/reviews and write a CSV. The script below runs as is with a test key (pk_test_…), which returns sample data:

// export-google-reviews.mjs: node export-google-reviews.mjs > google-reviews.csv
const KEY = process.env.PRISMA_API_KEY; // pk_test_… for sample data, pk_live_… for real reviews
const esc = (v) => `"${String(v ?? "").replaceAll('"', '""')}"`;

console.log("date,rating,author,text,reply,url");
let cursor = null;
do {
  const params = new URLSearchParams({ platform: "google_maps", limit: "100" });
  if (cursor) params.set("cursor", cursor);
  const res = await fetch(`https://api.prismareviews.com/v1/reviews?${params}`, {
    headers: { Authorization: `Bearer ${KEY}` },
  });
  const page = await res.json();
  for (const r of page.data) {
    console.log([r.created_at, r.rating, r.author, r.text, r.reply?.text, r.url].map(esc).join(","));
  }
  cursor = page.next_cursor;
} while (cursor);

PRISMA_API_KEY=pk_test_YOUR_KEY node export-google-reviews.mjs > google-reviews.csv

Change platform=google_maps to yelp, tripadvisor or trustpilot, or drop it, and the same script exports every platform you’ve connected, in the same columns. To keep a Google Sheet up to date instead of a one-off file, see Google reviews to Google Sheets.

What it costs: Google Maps is read through a data provider, about 20 reviews per paid read. The free plan includes 100 free reads once; Beam (€49 a month) includes 2,500 reads. See pricing.

How do the export options compare?

FAQ

Can I export my Google reviews for free?

Yes. Google Takeout exports your Business Profile data, reviews included, as JSON at no cost. The Business Profile API is also free per call, but needs Google’s approval.

Can I export Google reviews to Excel or CSV?

Not directly from Google: Takeout and the API both give JSON. Convert it with a script like the one above, or use a tool that writes CSV.

Can I export Google reviews of another business?

Not through an official route. The Places API returns 5 reviews and doesn’t allow storing them; anything more means scraping, which Google’s terms don’t permit.

Does exporting Google reviews include my replies?

Yes. Takeout, the Business Profile API and Prisma all include the owner’s reply with each review.

How often can I export Google reviews?

Takeout is manual, whenever you request it. With an API you can export on a schedule, or keep a copy updated with webhooks as new reviews arrive.