Connectors

/

TrustPilot

Data replication

Sync TrustPilot data anywhere.

TrustPilot is an online review platform that allows customers to share their experiences and opinions about businesses they have interacted with. The platform provides a space for customers to leave reviews and ratings, which can help other potential customers make informed decisions about whether to use a particular business or not. TrustPilot also offers businesses the opportunity to respond to reviews and engage with customers, helping to build trust and improve their reputation. The platform is used by millions of people worldwide and covers a wide range of industries, from retail and hospitality to finance and healthcare.

  • Standard
  • Alpha
  • 1 stream
Sync TrustPilot dataRead the docs
TrustPilot

One connector

Everything TrustPilot can do in Airbyte

  • Sync to your warehouse

    Land 1 TrustPilot table in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate TrustPilot once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the TrustPilot connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync TrustPilot

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version0.4.12
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 11 steps

  1. Go to the TrustPilot website and log in to your account.
  2. Navigate to the API section of your account settings.
  3. Generate an API key by clicking on the ""Generate new API key"" button.
  4. Copy the API key to your clipboard.
  5. Open the Airbyte platform and navigate to the ""Sources"" tab.
  6. Click on the ""TrustPilot"" source connector.
  7. Enter your API key in the appropriate field.
  8. Enter the name of the data source you want to connect to.
  9. Click on the ""Test connection"" button to ensure that the connection is successful.
  10. If the connection is successful, click on the ""Save"" button to save the configuration.
  11. You can now use the TrustPilot source connector to extract data from your TrustPilot account.

1 stream

Every table you can sync from TrustPilot

  • Private Reviews

Authentication

Authenticate TrustPilot once

    • Recommended

    OAuth 2.0

  • API Key

    The API key authentication method gives you access to only the streams which are part of the Public API. When you want to get streams available via the Consumer API (e.g. the private reviews) you need to use authentication method OAuth 2.0.

Explore

Related connectors

TwilioMarketing AnalyticsCertified Sources cloudself-managed-enterprise
TwitterMarketing AnalyticsStandard Sources cloudself-managed-enterprise
Tyntec SMSMarketing AnalyticsStandard Sources cloudself-managed-enterprise
TypeformMarketing AnalyticsCertified Sources cloudself-managed-enterprise
UpPromoteMarketing AnalyticsStandard Sources cloudself-managed-enterprise
WebflowMarketing AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

TrustPilot's API provides access to a wide range of data related to customer reviews and ratings. The following are the categories of data that can be accessed through TrustPilot's API:

1. Reviews: TrustPilot's API provides access to all the reviews submitted by customers, including the text of the review, the rating given, and the date of submission.

2. Ratings: The API also provides access to the overall rating of a business, as well as the individual ratings for different aspects of the business, such as customer service, product quality, and delivery.

3. TrustScore: TrustPilot's TrustScore is a measure of a business's overall reputation based on customer reviews. The API provides access to this score, as well as the factors that contribute to it.

4. Business information: The API provides access to information about the business, such as its name, address, and website.

5. Reviewer information: The API also provides access to information about the reviewers, such as their name, location, and the number of reviews they have submitted.

6. Analytics: TrustPilot's API provides access to analytics related to customer reviews, such as the number of reviews submitted over time, the average rating, and the sentiment of the reviews.

1. Go to the TrustPilot website and log in to your account.
2. Navigate to the API section of your account settings.
3. Generate an API key by clicking on the ""Generate new API key"" button.
4. Copy the API key to your clipboard.
5. Open the Airbyte platform and navigate to the ""Sources"" tab.
6. Click on the ""TrustPilot"" source connector.
7. Enter your API key in the appropriate field.
8. Enter the name of the data source you want to connect to.
9. Click on the ""Test connection"" button to ensure that the connection is successful.
10. If the connection is successful, click on the ""Save"" button to save the configuration.
11. You can now use the TrustPilot source connector to extract data from your TrustPilot account.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving TrustPilot data today

Free for 14 days on Airbyte Cloud. Set up the TrustPilot connector once and let Airbyte keep it in sync.

Try it freeTalk to sales