Use Grades.com in your reporting tool.

BigQuery export

Pro and Premium: your reviews, review versions, daily scores, AI Reputation answers and a daily summary in your own BigQuery dataset, synced nightly (hourly on Premium). Set it up in Company Settings > Notifications & exports > BigQuery export. Tables grades_reviews, grades_review_versions, grades_scores, grades_ai_reputation and grades_summary_daily (the warehouse twin of review-metrics?interval=day). Any tool that reads BigQuery reads them directly.

Excel (Power Query)

Data > Get Data > From Other Sources > Blank Query > Advanced Editor, and paste the Power BI query below. From Web only takes a URL or a fixed list of headers, without Authorization. Refresh with Refresh All, on open, or every few minutes while the workbook is open.

Verified against Microsoft's documentation (timed refresh: not verified).

Tableau

Use Tableau's REST API Connector (Tableau Exchange, Tableau 2023.3 and later, extracts only): GET https://app.grades.com/api/v1/reports/review-metrics?interval=month&limit=10000, authentication Bearer with your key, records at $.data[*]. Its paging is by offset, so use page numbers (page=1, 2, ...) or keep a request under 10,000 rows. Web Data Connector 3.0 is deprecated: do not build on it. Without the connector, connect to a CSV report saved to a file or a Google Sheet.

Verified against Tableau's documentation (Tableau Cloud refresh of this connector: not verified).

Supermetrics

Connector builder (a paid add-on of your Supermetrics account): headers and cursor paging are built in, as below. Custom data import (Supermetrics Hub): fetch a URL with the header Authorization: Bearer gk_live_..., for example a report with ?format=csv. JSON/CSV/XML connector: source URL plus JSONPath data.*; it has no header field, so it needs a URL key (key=gk_live_url_...). Prefer the connector builder or custom data import, which send the header.

JSON/CSV/XML connector: Anyone with this link can read your review data. Use a URL key limited to the businesses you need, and rotate it if the link is shared.

{
  "url": "https://app.grades.com/api/v1/reports/review-metrics?interval=day&limit=10000",
  "headers": [{"name": "Authorization", "value": "Bearer gk_live_..."}],
  "pagination": {"type": "cursor", "nextPageParameterName": "cursor",
                 "nextPagePath": {"source": "jsonPath", "value": "$.meta.next_cursor"}},
  "dataPath": "$.data"
}

Verified against Supermetrics' documentation.

Coupler.io

Source JSON: URL https://app.grades.com/api/v1/reports/review-metrics?interval=day&limit=10000, method GET, request header Authorization: Bearer gk_live_..., path data. It does not page: keep a request under 10,000 rows, or add one source per page (&page=2, ...) and join them with Append. Schedules run from every 15 minutes to monthly, by plan.

Verified against Coupler.io's documentation.

Databox

Data Manager > Custom Integration (beta): base URL https://app.grades.com/api/v1, header Authorization: Bearer gk_live_..., cursor paging with cursor from meta.next_cursor (or page numbers with page). Each sync replaces the data, so ask for the whole date range every time.

Verified against Databox's documentation.

Klipfolio

A REST/URL data source: the URL of a report, the header Authorization: Bearer gk_live_..., format JSON. No cursor paging: use limit=10000 or page numbers. Sources refresh only while the account has active users.

Not verified: Klipfolio's help pages were not available to us.