Import Tripadvisor Data To Google Sheets

Import Tripadvisor data to Google Sheets
Reading Time: 5 minutes

Looking for a simple and efficient way to scrape Tripadvisor data? You could not have found a better place. This article covers exactly that: import Tripadvisor data to Google Sheets.

We can scrape different kinds of data from Tripadvisor such as flight information, hotels data, rentals and restaurants information, and various other data–most data from Tripadvisor, in other words.

We’ll use an extension in Google Sheets to import Tripadvisor data to Google Sheets by using Tripadvisor API. And not just scrape Tripadvisor data but automatically update the imported data so that whenever a change in the information occurs, the same is reflected in the imported data.

But all that later. Let us first take a look at the steps we’ll encounter.

Steps to import Tripadvisor data to Google Sheets:

  1. Install the Amigo extension
  2. Get the endpoint URL
  3. Import the data to Google Sheets

How to import Tripadvisor data to Google Sheets

Install the Amigo Data extension in Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Amigo in Google Workspace Marketplace

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Get the API endpoint URL

Sign up or log in to RapidAPI.

Search for Tripadvisor API in the RapidAPI Hub and click the first result. Or click this link to go directly to the API documentation page.

Click on the Subscribe to Test button and subscribe to a plan of your choice, post which you’ll be able to make request to the API and import Tripadvisor data to Google Sheets.

Subscribe to the API

Click Endpoints to go back to the API Playground. On the left is the list of the type of data that can be retrieved.

Types of data available for import

Expand any of the endpoints collection and click on the specific endpoint to retrieve the data. For example, to import the rental details for a particular rental property, expand the Vacation Rentals and click the Rental Details endpoint.

Vacation rentals endpoints

In the Required Parameters we’ll need to specify the rental ID.

Required parameter

The rental ID can be found with the Rental Search endpoint.

The rental ID

After entering the parameter, click the Test Endpoint button to view the results. The result will be displayed in JSON format under the Results section on the right, if the parameter is valid.

The API endpoint URL along with the headers–which will be required to import Tripadvisor data to Google Sheets–can be found in the Code Snippets section.

Change the language from Node.js (Axios) to Shell→cURL. Copy the URL and note also the headers.

The endpoint URL and headers

Import the data to Google Sheets

Open Google Sheets and launch Amigo. To connect to Amigo, go to Extensions→Amigo: Data Exports and Reports→Connect.

Launching the Amigo Add-on

We’ll be presented with a list of sources to connect and import data. Select Custom API.

Select Custom API as the source to connect

Paste the endpoint URL (without the apostrophes) in the API URL field.

Entering the endpoint URL

Then expand the Details tab and enter the headers. The headers can be found in the Code Snippets. The characters to the left of the colon are the header names and those to the right are the header values. Enter these as separate headers. Do not include the apostrophes.

Name: X-RapidAPI-Host, Value: tripadvisor16.p.rapidapi.com

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Entering the headers

Preview of the data

The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.

Snippet of the Tripadvisor data imported to Google Sheets

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and many other useful–and also cool–things you can do with Amigo Data.

Some recommended articles:

Import Zillow data to Google Sheets

Import AirDNA Data To Google Sheets

Import FlightRadar Data To Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial