Integrations

Another way to import data into Caplena is by using direct integrations with external platforms such as Google Maps, Trustpilot, Tripadvisor, Qualtrics, and more.

With integrations, you can scrape reviews for products, services, apps, locations, or businesses by simply providing a URL or unique identifier.

🔍 In this article :

1. How Integrations Work 

2. Review Platforms

• Google Maps

• Trustpilot

• Apple App Store

• Google Play Store

• Amazon

• G2

• Capterra

• Yelp

• Tripadvisor

3. Connected Accounts

• Brandwatch

• Qualtrics

• Medallia

 

---

 

How Integrations Work

Each integration consists of one or more integration items, think of these as the specific resources you want to analyze (e.g., reviews for a location on Google Maps or an app in an App Store).

For example, if you're comparing two retail locations:

• You create a Google Maps Integration

• It contains two integration items: reviews Location 1 and Location 2, or more, of course)

• Caplena will combine these into a single project

 

---

Syncing Data Automatically

A key benefit of using integrations is automatic synchronization. When enabled:

• Caplena fetches new reviews daily at 2:00 AM UTC

• Reviews are added to your project automatically

• No manual work required

You can turn synchronization off anytime from the Data Sources page by toggling it off in the integration item settings. If you have a lot of items, you can also do this in bulk now.

---

Billing & Credits

Integrations do not incur extra fees, imported texts cost 1 credit each, just like any other upload.

• You’re only billed when saving the project

• With sync enabled, credits are deducted daily as new reviews come in

• Caplena provides an estimate of the review count for each integration item before the upload

---

 

Reviews Platforms

Below is a list of platforms currently supported by Caplena’s integration feature, including the required input format and example links for each.

---

1. Google Maps

Input format:
<Name>, <Address>, <Country>

Example:
WERK 8, Dornacherstrasse 192, 4053 Basel, Switzerland

---

 

Why Some Locations Are Not Showing in Your Project

If a location (like a train station or address) isn’t appearing in your project, it’s usually because the system can’t find an exact match using the search term you provided.

This happens when the location is too general or returns multiple results on Google Maps.

Let’s say you enter:

Wien Hauptbahnhof, 1100 Wien

This might show multiple results in Google Maps (like entrances, platforms, shops), so the system doesn’t know which one to use, and skips it.

---

 How to fix it

To make sure a location is included, use a more specific version of the name — something that returns exactly one result in Google Maps.

Examples that work better:

•  vienna central station train station, Gleis 8, am hauptbahnhof 1, 1100 vienna

  You can test this yourself:

1. Go to Google Maps

2. Type your search term

3. Check that it goes to one clear place (not a list)

4. Use that exact search in your project

---

 

 

2. Trustpilot

Input format:
https://www.trustpilot.com/review/<domain>

Examples:

• https://www.trustpilot.com/review/cyberghostvpn.com

• https://www.trustpilot.com/review/www.smtp2go.com

---

3. Apple App Store

Input format:

• Default (US): https://apps.apple.com/app/<name>/<identifier>

• Other regions: https://apps.apple.com/<region>/app/<name>/<identifier>
  (Supported regions: ca, at, it, us, au, fr, ch, mx, es, de)

Examples:

• https://apps.apple.com/app/bear/id1091189122

• https://apps.apple.com/de/app/fifa-soccer/id1094930513

---

4. Google Play Store

Supports reviews for apps, movies, and books.

Input format:

• Apps: https://play.google.com/store/apps/details?id=<app-bundle>&hl=<lang>

• Movies: https://play.google.com/store/movies/details/<name>?id=<identifier>

• Books: https://play.google.com/store/books/details/<name>/?id=<identifier>

Languages supported:
hl=de, hl=fr, hl=en, hl=it, hl=es, etc.

Examples (Apps):

• https://play.google.com/store/apps/details?id=org.coursera.android&hl=de

• https://play.google.com/store/apps/details?id=com.pluralsight

---

5. Amazon

Input formats (both accepted):

• With product name: https://www.amazon.<country>/<name>/dp/<ASIN>

• Without name: https://www.amazon.<country>/dp/<ASIN>

Supported Amazon stores:
US, UK, DE, FR, IT, ES, CA, JP, IN, AU, MX, BR, TR, AE, SA, NL, SG, PL, SE, EG, BE

Examples:

• https://www.amazon.de/Colgate-Charcoal-Whitening-Zahnpasta-Zahnbürste/dp/B088VCM63D

• https://www.amazon.com/dp/B00WBJGUA2

---

6. G2

Input format:
https://www.g2.com/products/<product-name>/reviews

Example:
https://www.g2.com/products/clickup/reviews

---

7. Capterra

Input format:
https://www.capterra.com/p/<identifier>/<name>/

Example:
https://www.capterra.com/p/177841/NetSuite/

---

8. Yelp

Input format:
https://www.yelp.com/biz/<business-name>

Examples:

• https://www.yelp.com/biz/tibits-basel

• https://www.yelp.com/biz/franchia-vegan-cafe-new-york

---

9. Tripadvisor

Input format:
https://www.tripadvisor.com/Attraction_Review-<location>/<place-id>-Reviews-<place-name>.html

Examples:

• https://www.tripadvisor.com/Attraction_Review-g294265-d324542-Reviews-Gardens_by_the_Bay-Singapore.html

• https://www.tripadvisor.com/Attraction_Review-g187497-d190146-Reviews-Basílica_de_la_Sagrada_Família-Barcelona_Catalonia.html

---

 

Connected Accounts

Brandwatch

Our Brandwatch integration allows you to seamlessly import social media query results directly into Caplena for analysis.

Follow the steps below to set up your integration:

---

 

Step 1: Open Integrations Settings

1. Log in to your Caplena account.

2. Navigate to Account Settings > Integrations.

3. Select Brandwatch from the available options.

 

---

 

Step 2: Add Your Brandwatch Account

1. Click Add Account.

2. Fill in the following fields:

   • Connection name – Give your connection a unique name.

   • Username – Your Brandwatch username.

   • Password – Your Brandwatch password.

   • Project name – You can find this in your Brandwatch account.

---

 

Step 3: Connect the Account

Once all fields are filled out, click Add Integration to authorize the integration.

---

 

Step 4: Import Brandwatch Data into Caplena

1. Go to your Projects dashboard in Caplena.

2. Click Import Data.

3. Select Brandwatch from the integration list.

4. Choose the Brandwatch account and specific survey you'd like to import.

---

 

Qualtrics

Integrating Qualtrics with Caplena allows you to seamlessly analyze open-ended responses from your Qualtrics surveys.

Follow the steps below to set up your connection:

---

 

Step 1: Access Integration Settings

1. Log in to your Caplena account.

2. Navigate to Account Settings.

3. Scroll to the bottom and click on Integrations.

4. In the top-right section, select Qualtrics.

 

---

 

Step 2: Fill in Connection Details

Click Add Account and complete the required fields:

• Connection Name
  Choose a label to identify your Qualtrics connection. This is especially helpful if you manage multiple integrations.

• API Key
  You can find this in your Qualtrics account under:

  • Account Settings → Qualtrics IDs → API section

• Datacenter ID
  Also found in:

  • Account Settings → Qualtrics IDs → User section

---

 

Step 3: Connect the Account

Once all fields are filled in, click Add Integration to finalize the setup. You’ll now see Qualtrics listed under your connected accounts.

---

 

Step 4: Import Your Survey Data

1. In Caplena, go to Projects.

2. Click Import Data or New Project.

3. Choose Qualtrics from your list of connected integrations.

4. Select the desired account and survey you wish to import.

---

 

Medallia

Integrating Medallia with Caplena allows you to automatically import and analyze open-ended feedback from your Medallia surveys.

Follow the steps below to set up your connection:

---

 

Step 1: Access Integration Settings

1. Log in to your Caplena account.

2. Navigate to Account Settings.

3. Scroll to the bottom and click on Integrations.

4. In the top-right section, select Medallia.

---

 

Step 2: Fill in Connection Details

Click Add Integration and complete the following fields:

• Connection Name
  Choose a label to identify your Medallia connection (e.g. Medallia_NPS_Q4_2025). This is for your reference in Caplena.

• Client ID
  Provided by your Medallia administrator or developer portal. Used for API authentication.

• Client Secret
  A secure key that works with your Client ID to authorize the connection.

• Token URL
  The authentication endpoint for your Medallia environment (e.g., https://login.medallia.com/oauth/token). If unsure, please check with your Medallia admin.

• Query
  This is the specific API endpoint or request used to retrieve your feedback data. The exact structure will depend on your Medallia setup.

---

 

Step 3: Connect the Account

Once all fields are filled in, click Add Integration to finalize the setup. You’ll now see Medallia listed under your connected accounts.

---

 

Step 4: Import Your Survey Data

1. Go to Projects in Caplena.

2. Click Import Data or New Project.

3. Choose Medallia from your list of connected integrations.

4. Select the account and define which data to import using your predefined query.

---

 

Frequently Asked Questions (Medallia & Qualtrics)

What happens if I delete columns in Caplena?

If you delete columns in Caplena, the data from Medallia or Qualtrics that corresponded to those columns will no longer sync. The synchronization will continue, but without updating those removed columns.

What happens if I add new columns in Caplena?

New columns added manually in Caplena will not be filled by Medallia or Qualtrics syncs. They will remain empty unless populated manually.

What happens if I add new columns in Medallia or Qualtrics?

New columns added in Medallia or Qualtrics will not be included automatically in the sync. They will not appear in Caplena unless the query used in the integration is updated accordingly.