Track Daily TripAdvisor Ranking changes and comments in a Google Spreadsheet with Google Apps Scripts

Anđel Bošković
Feb 27, 2019 · 2 min read

Recently I wondered what’s the best way for me to track my TripAdvisor property (Allure Caramel Hotel by Karisma) ranking changes and the number of comments on a daily basis.

I imagined something like this.

TripAdvisor Ranking + Review Scores

This is the setup I came up with:

1. Google Apps Script

For extracting the ranking and number of comments per star level (1–5).

2. Google Spreadsheet

For storing results and generating a graph.

This is how the script looks like.

You can run it in 3 simple steps:

  • Open up the Script editor in a new Google Spreadsheet
Script editor
  • Paste the code, change property name, change property URL and save the document
Paste, Change & Save
  • If you want a daily measurement as I do go to Edit > Current Project’s Triggers > + Add Trigger
Add trigger
  • Set function to run to“exportTripAdvisorRankingToSpreadsheet”
  • Time-Driven
  • Time of Day: eg: Midnight to 1 am and Save

That’s it.

You are all set to have daily updates of your properties TripAdvisor ranking. :)

Let me know, in the comments, if you have any questions

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade