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

 

---

 

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.

---

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

---

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.