Connect Trustpilot to AI, Sheets, Databases & BI Tools
Windsor.ai's Trustpilot connector extracts your Trustpilot data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.
How to connect Trustpilot to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Trustpilot and grant Windsor.ai access to your Trustpilot data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Trustpilot data.
Trustpilot fields
Windsor.ai's Trustpilot connector offers 57 fields, organized in 3 tables such as General, configured_business_units, private_reviews. Here are 30 of them:
-
Date (
date): The review creation date, or the last requested day for business unit profiles. -
Account Name (
account_name): The name of the Windsor.ai Trustpilot account. -
Account ID (
account_id): The ID of the Windsor.ai Trustpilot account. -
configured_business_units.badFit (
configured_business_units__badfit): configured_business_units.badFit -
Data fetched at (
data_fetched_at): UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that... -
private_reviews.businessUnit (
private_reviews__businessunit): private_reviews.businessUnit -
configured_business_units.country (
configured_business_units__country): configured_business_units.country -
Data Source (
datasource): The name of the Windsor connector returning the row -
private_reviews.businessUnitHistory (
private_reviews__businessunithistory): private_reviews.businessUnitHistory -
configured_business_units.displayName (
configured_business_units__displayname): configured_business_units.displayName -
Day of month (
day_of_month): Day of the month -
private_reviews.companyReply (
private_reviews__companyreply): private_reviews.companyReply -
configured_business_units.id (
configured_business_units__id): configured_business_units.id -
Month (
month): Number of the month -
private_reviews.complianceLabels (
private_reviews__compliancelabels): private_reviews.complianceLabels -
configured_business_units.name (
configured_business_units__name): configured_business_units.name -
Now (
now): Current timestamp -
private_reviews.consumer (
private_reviews__consumer): private_reviews.consumer -
configured_business_units.numberOfReviews (
configured_business_units__numberofreviews): configured_business_units.numberOfReviews -
Source (
source): The name of the Windsor connector returning the row -
private_reviews.countsTowardsLocationTrustScore (
private_reviews__countstowardslocationtrustscore): private_reviews.countsTowardsLocationTrustScore -
configured_business_units.score (
configured_business_units__score): configured_business_units.score -
Today (
today): Today's date -
private_reviews.countsTowardsTrustScore (
private_reviews__countstowardstrustscore): private_reviews.countsTowardsTrustScore -
configured_business_units.status (
configured_business_units__status): configured_business_units.status -
Week (
week): Week (Sun-Sat). -
private_reviews.createdAt (
private_reviews__createdat): private_reviews.createdAt -
configured_business_units.websiteUrl (
configured_business_units__websiteurl): configured_business_units.websiteUrl -
Day of week and day number (
week_day): Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. -
private_reviews.experiencedAt (
private_reviews__experiencedat): private_reviews.experiencedAt
Use Trustpilot data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Trustpilot is connected to Windsor.ai, you can ask questions about your Trustpilot data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Trustpilot data
AI assistants
ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)
Spreadsheets
Google Sheets, Excel, Airtable
Databases & warehouses
BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store
BI & dashboards
Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau
File storage
Amazon S3 Storage, Azure Blob Storage
Code
Python/R Code