<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Harbour Data</title>
    <description>The latest articles on DEV Community by Harbour Data (@harbourdata).</description>
    <link>https://dev.to/harbourdata</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4244332%2Fdb2027f7-010a-40b4-bf46-dbb14d139473.png</url>
      <title>DEV Community: Harbour Data</title>
      <link>https://dev.to/harbourdata</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/harbourdata"/>
    <language>en</language>
    <item>
      <title>How to track a hotel's price for every night of the next 2 months (no API key)</title>
      <dc:creator>Harbour Data</dc:creator>
      <pubDate>Sat, 14 Nov 2026 11:02:54 +0000</pubDate>
      <link>https://dev.to/harbourdata/how-to-track-a-hotels-price-for-every-night-of-the-next-2-months-no-api-key-22jb</link>
      <guid>https://dev.to/harbourdata/how-to-track-a-hotels-price-for-every-night-of-the-next-2-months-no-api-key-22jb</guid>
      <description>&lt;p&gt;Hotel prices swing wildly by date. The same London hotel I checked this week ranged from &lt;strong&gt;£144 to £360 a night&lt;/strong&gt; within a single week. If you're a revenue manager, a travel startup, or just planning a trip around a flexible date, you want that whole curve, not one number.&lt;/p&gt;

&lt;p&gt;Google Hotels has the data, but Google offers no public hotel-price API. This post shows how to get a &lt;strong&gt;price calendar&lt;/strong&gt;: one hotel's nightly price across up to 180 check-in dates, as a spreadsheet, in about a minute.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Disclosure: I built the tool used here, &lt;a href="https://apify.com/harbourdata/google-hotels-scraper" rel="noopener noreferrer"&gt;Google Hotels Scraper on Apify&lt;/a&gt;. It's paid per result (about $2.50 per 1,000 rows), and Apify's free plan credit covers small experiments like this one.&lt;/em&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Find the hotel's link
&lt;/h2&gt;

&lt;p&gt;Open the hotel on &lt;a href="https://www.google.com/travel/hotels" rel="noopener noreferrer"&gt;Google Hotels&lt;/a&gt; and copy the URL. It contains &lt;code&gt;/travel/hotels/entity/...&lt;/code&gt;. That ID is all you need.&lt;/p&gt;

&lt;h2&gt;
  
  
  2. Run the price calendar
&lt;/h2&gt;

&lt;p&gt;No code required: open the Actor, paste the link into &lt;strong&gt;Specific hotels&lt;/strong&gt;, set your first check-in date, a 1-night stay, and &lt;strong&gt;Price calendar (days)&lt;/strong&gt; = &lt;code&gt;60&lt;/code&gt;, then click &lt;strong&gt;Start&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;Or from Python:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;apify_client&lt;/span&gt; &lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nc"&gt;ApifyClient&lt;/span&gt;

&lt;span class="n"&gt;client&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nc"&gt;ApifyClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"YOUR_APIFY_TOKEN"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;run&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;actor&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"harbourdata/google-hotels-scraper"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;call&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;run_input&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="s2"&gt;"hotelUrls"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"https://www.google.com/travel/hotels/entity/ChkIseK87saGv4e2ARoML2cvMTF4dngxM2t3EAE"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="s2"&gt;"checkInDate"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2027-01-05"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="s2"&gt;"checkOutDate"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2027-01-06"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;   &lt;span class="c1"&gt;# 1-night stays&lt;/span&gt;
    &lt;span class="s2"&gt;"priceCalendarDays"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;60&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;         &lt;span class="c1"&gt;# the next 60 check-in dates&lt;/span&gt;
    &lt;span class="s2"&gt;"currency"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"GBP"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;rows&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="kt"&gt;list&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;client&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;dataset&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;run&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"defaultDatasetId"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;iterate_items&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;You get one row per date, with &lt;code&gt;checkInDate&lt;/code&gt;, &lt;code&gt;pricePerNight&lt;/code&gt;, &lt;code&gt;totalPrice&lt;/code&gt;, taxes, and the hotel's rating and star class.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Find the cheap and expensive nights
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="n"&gt;df&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;DataFrame&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;rows&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"checkInDate"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"pricePerNight"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;dropna&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"weekday"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;to_datetime&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;checkInDate&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;dt&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;day_name&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;nsmallest&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"pricePerNight"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;                       &lt;span class="c1"&gt;# cheapest nights&lt;/span&gt;
&lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;groupby&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"weekday"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;pricePerNight&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;mean&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nb"&gt;round&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;    &lt;span class="c1"&gt;# average by day of week&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Dates where Google shows no price (sold out or not bookable) come back with &lt;code&gt;"availability": "no_price_for_these_dates"&lt;/code&gt;, so they're easy to filter.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Compare booking sites too
&lt;/h2&gt;

&lt;p&gt;Turn on &lt;strong&gt;Include every booking site's price&lt;/strong&gt; and each row also lists what Booking.com, Expedia, Trip.com, Agoda, the hotel's own site and others charge for that night, with booking links. That's handy for checking &lt;strong&gt;rate parity&lt;/strong&gt;, meaning whether an online travel agency is undercutting the hotel's own website.&lt;/p&gt;

&lt;h2&gt;
  
  
  Ideas
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Hotels:&lt;/strong&gt; a weekly scheduled run on your own property plus 5 competitors gives you a cheap rate-shopping report.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Travel apps:&lt;/strong&gt; "best night to book" features, or price-drop alerts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Analysts:&lt;/strong&gt; seasonality and event spikes. Concert and match nights stand out immediately.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you try it and something's missing, open an issue on the Actor page. I read them all.&lt;/p&gt;

</description>
      <category>python</category>
      <category>webscraping</category>
      <category>travel</category>
      <category>datascience</category>
    </item>
  </channel>
</rss>
