{"id":3164,"date":"2025-09-19T10:58:38","date_gmt":"2025-09-19T10:58:38","guid":{"rendered":"https:\/\/www.makcorps.com\/blog\/?p=3164"},"modified":"2025-10-17T13:10:33","modified_gmt":"2025-10-17T13:10:33","slug":"pull-hotel-prices-for-any-city-using-n8n-makcorps-api","status":"publish","type":"post","link":"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/","title":{"rendered":"How to Pull Hotel Prices for Any City with n8n and Makcorps API"},"content":{"rendered":"\n<p>If you need hotel price data, you already know how tricky it can get. Travel agencies rely on it to stay competitive, market researchers depend on it for accurate insights, and businesses in the tourism sector use it to make informed decisions. The problem is, getting that data usually means hiring a developer, writing complex code, or trying to scrape sites that don\u2019t exactly make it easy. Anyone who\u2019s scraped travel platforms before knows how much of a headache it can be.<\/p>\n\n\n\n<p>The good news is you don\u2019t have to go through that. In this guide, we\u2019ll walk you through how to pull hotel prices for any city using <strong><a href=\"https:\/\/www.makcorps.com\/\">Makcorps API<\/a><\/strong> together with <strong><a href=\"https:\/\/n8n.io\/\" target=\"_blank\" rel=\"noopener\">n8n<\/a><\/strong>, a no-code automation tool that makes the whole process straightforward.<\/p>\n\n\n\n<p>And at the end, you\u2019ll also get a <strong>blueprint<\/strong> of the full workflow so you don\u2019t have to build everything from scratch.<\/p>\n\n\n\n<p>So, let\u2019s get started.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #e29a12;color:#e29a12\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #e29a12;color:#e29a12\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#What_Youll_Need\" >What You\u2019ll Need<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_1_Get_Your_API_Key_and_Understand_the_Requirements\" >Step 1: Get Your API Key and Understand the Requirements<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_2_Set_Up_Your_Google_Sheet\" >Step 2: Set Up Your Google Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_3_Start_Building_the_Automation_in_n8n\" >Step 3: Start Building the Automation in n8n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_4_Add_Your_First_Node_HTTP_Request\" >Step 4: Add Your First Node (HTTP Request)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_5_Add_the_Second_HTTP_Request_for_Hotel_Prices\" >Step 5: Add the Second HTTP Request for Hotel Prices<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_6_Organize_the_Data_with_a_JavaScript_Node\" >Step 6: Organize the Data with a JavaScript Node<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_7_Send_the_Data_to_Google_Sheets\" >Step 7: Send the Data to Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Step_8_Test_Save_and_Import_the_Blueprint\" >Step 8: Test, Save, and Import the Blueprint<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Wrapping_Up\" >Wrapping Up:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.makcorps.com\/blog\/pull-hotel-prices-for-any-city-using-n8n-makcorps-api\/#Additional_Resources\" >Additional Resources:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Youll_Need\"><\/span>What You\u2019ll Need<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Makcorps API&nbsp;<\/li>\n\n\n\n<li>An n8n account<\/li>\n\n\n\n<li>A Google Sheet&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>If you prefer watching, here\u2019s a short video tutorial. Otherwise, you can continue reading the step-by-step guide below.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to Pull Hotel Prices for Any City with n8n and Makcorps API\" width=\"720\" height=\"405\" src=\"https:\/\/www.youtube.com\/embed\/VOr3EY2o8yM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Get_Your_API_Key_and_Understand_the_Requirements\"><\/span>Step 1: Get Your API Key and Understand the Requirements<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before we start pulling hotel prices, you\u2019ll need an API key from <strong>Makcorps<\/strong>. The process is simple:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Head over to<a href=\"https:\/\/makcorps.com\" target=\"_blank\" rel=\"noopener\"> Makcorps<\/a> and <a href=\"https:\/\/makcorps.com\/signup.html\" target=\"_blank\" rel=\"noopener\">sign up<\/a> for an account.<br><\/li>\n\n\n\n<li>After registering, you\u2019ll receive a verification email.<br><\/li>\n\n\n\n<li>Once you confirm your email, your API key will be sent to you with your API key.<br><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"351\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/unnamed-9-1024x351.png\" alt=\"\" class=\"wp-image-3174\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/unnamed-9-1024x351.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/unnamed-9-300x103.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/unnamed-9-768x263.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/unnamed-9.png 1484w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>This key is what allows you to access Makcorps data and connect it with your automation in n8n. Keep it safe, you\u2019ll need it in the steps ahead.<\/p>\n\n\n\n<p>Now, there are two parts of the API you\u2019ll want to check out:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hotel Price API by City ID<\/strong> \u2013<a href=\"https:\/\/docs.makcorps.com\/hotel-price-apis\/hotel-api-search-by-city-id\" target=\"_blank\" rel=\"noopener\"> see documentation<br><\/a><\/li>\n\n\n\n<li><strong>Hotel Mapping API for City IDs<\/strong> \u2013<a href=\"https:\/\/docs.makcorps.com\/mapping-api-hotel-city-ids\" target=\"_blank\" rel=\"noopener\"> see documentation<br><\/a><\/li>\n<\/ul>\n\n\n\n<p>The first gives you hotel prices once you have the city ID, and the second helps you find that city ID in the first place.<\/p>\n\n\n\n<p>Take a moment to go through the documentation so you\u2019re clear on the requirements and endpoints. Once that\u2019s done, we\u2019ll move on to preparing the Google Sheet where we\u2019ll pull the data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_Set_Up_Your_Google_Sheet\"><\/span>Step 2: Set Up Your Google Sheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that you know the requirements and have your API key ready, the next step is preparing a Google Sheet to store the hotel data.<\/p>\n\n\n\n<p>For this example, I\u2019m pulling hotel prices for <strong>Paris<\/strong>, but you can replace it with any city you want. The sheet has the following columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>hotel_name<\/strong> \u2013 the name of the hotel.<br><\/li>\n\n\n\n<li><strong>vendor<\/strong> \u2013 the platform or provider listing the price.<br><\/li>\n\n\n\n<li><strong>price<\/strong> \u2013 the cost of the hotel room.<br><\/li>\n\n\n\n<li><strong>review<\/strong> \u2013 customer review data.<\/li>\n<\/ul>\n\n\n\n<p>I\u2019ve named the sheet<strong> \u201cHotel Price List (Paris)\u201d<\/strong> so it\u2019s easy to recognise later when we connect it inside n8n.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s what it looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"698\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-1024x698.png\" alt=\"\" class=\"wp-image-3178\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-1024x698.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-300x205.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-768x524.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-8.png 1296w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>I\u2019ve kept the sheet simple, but if you\u2019ve gone through the<a href=\"https:\/\/docs.makcorps.com\/hotel-price-apis\/hotel-api-search-by-city-id\" target=\"_blank\" rel=\"noopener\"> API documentation<\/a>, you\u2019ll see there\u2019s more data you can pull, like ratings, amenities, or booking links. You can add extra columns if you want to capture those as well.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3_Start_Building_the_Automation_in_n8n\"><\/span>Step 3: Start Building the Automation in n8n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>With the API key and Google Sheet ready, it\u2019s time to build the automation.<\/p>\n\n\n\n<p><strong>1. <\/strong><a href=\"https:\/\/app.n8n.cloud\/register?ps_partner_key=MTU0ZDU1ZGY1NGQ5&amp;ps_xid=kIEmsNVMYniqmm\" target=\"_blank\" rel=\"noopener\"><strong>Create an account on n8n<\/strong><\/a> if you haven\u2019t already.<br><\/p>\n\n\n\n<p>2. Once you\u2019re logged in, head over to the <strong>Workflows<\/strong> section and click on <strong>Create Workflow<\/strong>.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1024x256.png\" alt=\"\" class=\"wp-image-3168\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1024x256.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-300x75.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-768x192.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1536x384.png 1536w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-3.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. A new dashboard will appear. Here, you can give your workflow a clear name.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-1-1024x446.png\" alt=\"\" class=\"wp-image-3166\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-1-1024x446.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-1-300x131.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-1-768x334.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-1.png 1291w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_4_Add_Your_First_Node_HTTP_Request\"><\/span>Step 4: Add Your First Node (HTTP Request)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Inside your workflow, the first thing you\u2019ll need to do is add an <strong>HTTP Request<\/strong> node. This node allows n8n to connect with the Makcorps API and fetch data. Think of it as the bridge between your workflow and the API.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"531\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-2-1024x531.png\" alt=\"\" class=\"wp-image-3167\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-2-1024x531.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-2-300x156.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-2-768x398.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-2.png 1298w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on the <strong>\u201cAdd first step\u201d<\/strong> box in the workflow editor.<br><\/li>\n\n\n\n<li>Search for <strong>HTTP Request<\/strong> and select it.<br><\/li>\n\n\n\n<li>For the first request, we\u2019ll be using the <strong>Hotel Mapping API<\/strong>, because we need the city ID before we can pull prices.<br><\/li>\n<\/ol>\n\n\n\n<p>Here\u2019s how the setup looks:<\/p>\n\n\n\n<p>In this example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Method<\/strong>: GET<br><\/li>\n\n\n\n<li><strong>URL<\/strong>: https:\/\/api.makcorps.com\/mapping<br><\/li>\n\n\n\n<li><strong>Query Parameters<\/strong>: add your <strong>API key<\/strong> and the <strong>city name<\/strong> (here it\u2019s set to <em>paris<\/em>).<br><\/li>\n<\/ul>\n\n\n\n<p>Once that\u2019s done, click <strong>Execute Step<\/strong> to test the request. If everything is entered correctly, you\u2019ll get back the city ID in the response.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"836\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image.png\" alt=\"\" class=\"wp-image-3165\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image.png 514w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-184x300.png 184w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_5_Add_the_Second_HTTP_Request_for_Hotel_Prices\"><\/span>Step 5: Add the Second HTTP Request for Hotel Prices<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that you\u2019ve pulled the city ID from the first request, it\u2019s time to set up another HTTP Request node to fetch the actual hotel prices.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Add a new node by clicking the <strong>plus (+)<\/strong> button in your workflow.<br><\/li>\n\n\n\n<li>Search for <strong>HTTP Request<\/strong> and select it.<br><\/li>\n\n\n\n<li>Use the <strong>Hotel Price API by City<\/strong> endpoint.<br><\/li>\n<\/ol>\n\n\n\n<p>From your first request, you\u2019ll see the <strong>document_id<\/strong> in the output panel. This is the <strong>city ID<\/strong>. Drag and drop it into the city_id field of this new request.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"457\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1024x457.png\" alt=\"\" class=\"wp-image-3170\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1024x457.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-300x134.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-768x343.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1536x685.png 1536w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-5.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, add the required query parameters step by step (don\u2019t skip, as the API won\u2019t work without them):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>api_key<\/strong> \u2013 your Makcorps API key.<br><\/li>\n\n\n\n<li><strong>city_id<\/strong> \u2013 the city ID you just retrieved.<br><\/li>\n\n\n\n<li><strong>checkin<\/strong> \u2013 the check-in date.<br><\/li>\n\n\n\n<li><strong>checkout<\/strong> \u2013 the checkout date.<br><\/li>\n\n\n\n<li><strong>rooms<\/strong> \u2013 how many rooms you want prices for.<br><\/li>\n\n\n\n<li><strong>adults<\/strong> \u2013 how many adults are staying in those rooms.<br><\/li>\n\n\n\n<li><strong>cur<\/strong> \u2013 the currency you\u2019d like the results in (e.g., EUR, USD, GBP).<br><\/li>\n\n\n\n<li><strong>pagination<\/strong> \u2013 for controlling the number of results per request.<br><\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s an example of the endpoint in action:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>https:&#47;&#47;api.makcorps.com\/city?cityid=60763&amp;pagination=0&amp;cur=USD&amp;rooms=1&amp;adults=2&amp;checkin=2023-12-25&amp;checkout=2023-12-26&amp;api_key=YOUR_API_KEY<\/code><\/pre>\n\n\n\n<p>And here\u2019s what the setup looks like inside n8n:<\/p>\n\n\n\n<p>After filling in these fields, click <strong>Execute Step<\/strong>. Sometimes you may need to run it twice before prices display in the output panel. When it works, you\u2019ll see hotel details like:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>hotel name<\/strong><strong><br><\/strong><\/li>\n\n\n\n<li><strong>vendor<\/strong> (for example, Booking.com)<br><\/li>\n\n\n\n<li><strong>price<\/strong><strong><br><\/strong><\/li>\n\n\n\n<li><strong>reviews<\/strong> (ratings and count)<br><\/li>\n<\/ul>\n\n\n\n<p><strong>Note:<\/strong> Always enter the parameters step by step as listed above. Missing one can cause the request to fail.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_6_Organize_the_Data_with_a_JavaScript_Node\"><\/span>Step 6: Organize the Data with a JavaScript Node<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The hotel data you get back from the API is detailed but not immediately ready for a spreadsheet. To make it usable, we\u2019ll process it with a <strong>JavaScript Code<\/strong> node.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"459\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1024x459.png\" alt=\"\" class=\"wp-image-3171\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1024x459.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-300x134.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-768x344.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1536x688.png 1536w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-6.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Add a new node to your workflow and select <strong>Code<\/strong>.<br><\/li>\n\n\n\n<li>Choose <strong>JavaScript<\/strong> as the language.<br><\/li>\n\n\n\n<li>Copy and paste the following code into the editor:<br><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>const out = &#91;];\n\nitems&#91;0].json.forEach(h =&gt; {\n\n&nbsp;&nbsp;const priceRaw = h.price1 || \"\";\n\n&nbsp;&nbsp;const num = String(priceRaw).replace(\/&#91;^\\d.]\/g, \"\");\n\n&nbsp;&nbsp;const priceWithSymbol = num ? `\u20ac${num}` : \"\"; \/\/ change to \u20ac for Euro or any other currency\n\n&nbsp;&nbsp;out.push({\n\n&nbsp;&nbsp;&nbsp;&nbsp;json: {\n\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hotel_name: h.name,\n\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vendor: h.vendor1 || \"\",\n\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;price: priceWithSymbol,\n\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;review: h.reviews?.rating ?? null\n\n&nbsp;&nbsp;&nbsp;&nbsp;}\n\n&nbsp;&nbsp;});\n\n});\n\nreturn out;<\/code><\/pre>\n\n\n\n<p>This code does a few important things:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Picks out the <strong>hotel name<\/strong>, <strong>vendor<\/strong>, <strong>price<\/strong>, and <strong>review rating<\/strong>.<br><\/li>\n\n\n\n<li>Cleans up the price so it displays with a currency symbol.<br><\/li>\n\n\n\n<li>Structures everything neatly for the next step.<br><\/li>\n<\/ul>\n\n\n\n<p>Once you hit <strong>Execute Step<\/strong>, check the output on the right side of the screen. You should now see clean, organised data, ready to be sent straight into your Google Sheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_7_Send_the_Data_to_Google_Sheets\"><\/span>Step 7: Send the Data to Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>With the data structured, the final step is to push it into your Google Sheet.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Add a new node and search for <strong>Google Sheets<\/strong>.<br><\/li>\n\n\n\n<li>From the actions, choose <strong>Append or Update Row<\/strong>.<br><\/li>\n\n\n\n<li>Connect your Google account if you haven\u2019t already.<br><\/li>\n\n\n\n<li>Select your document \u2014 <em>N8N + Makcorps \u2013 Hotel Price Tracker<\/em>.<br><\/li>\n\n\n\n<li>Pick the sheet tab you created earlier \u2014 <em>Hotel Price List (Paris)<\/em>.<br><\/li>\n<\/ol>\n\n\n\n<p>Now it\u2019s time to map the values. In the Google Sheets node, you\u2019ll see fields for each column in your sheet. Instead of typing anything, drag and drop the values from the <strong>input panel on the left<\/strong> into the correct fields:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"706\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-1024x706.png\" alt=\"\" class=\"wp-image-3169\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-1024x706.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-300x207.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-768x529.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-4.png 1219w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hotel Name<\/strong> \u2192 drag {{$json.hotel_name}}<br><\/li>\n\n\n\n<li><strong>Vendor<\/strong> \u2192 drag {{$json.vendor}}<br><\/li>\n\n\n\n<li><strong>Price<\/strong> \u2192 drag {{$json.price}}<br><\/li>\n\n\n\n<li><strong>Review<\/strong> \u2192 drag {{$json.review}}<br><\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how it looks in practice:<\/p>\n\n\n\n<p>Once everything is mapped, click <strong>Execute Step<\/strong>. The node will take the values from the API output and send them into your Google Sheet, filling each column with the right information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"671\" src=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-1024x671.png\" alt=\"\" class=\"wp-image-3172\" srcset=\"https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-1024x671.png 1024w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-300x197.png 300w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-768x503.png 768w, https:\/\/www.makcorps.com\/blog\/wp-content\/uploads\/2025\/09\/image-7.png 1311w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_8_Test_Save_and_Import_the_Blueprint\"><\/span>Step 8: Test, Save, and Import the Blueprint<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once your Google Sheets node is set up, run the workflow and check the data flowing into your sheet. You should now see hotel names, vendors, prices, and reviews neatly added to the right columns.<\/p>\n\n\n\n<p>To make it easier, we\u2019ve also prepared a <strong>blueprint<\/strong> of this workflow. Instead of building everything from scratch, you can simply import the file into your own n8n account:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to your <strong>n8n dashboard<\/strong>.<br><\/li>\n\n\n\n<li>Click on the menu (three dots) in the top-right corner.<br><\/li>\n\n\n\n<li>Choose <strong>Import from File<\/strong>.<br><\/li>\n\n\n\n<li>Upload the blueprint JSON file.<br><\/li>\n<\/ol>\n\n\n\n<p>That\u2019s it \u2014 you\u2019ll have the entire setup ready to use and customise for your own needs.<\/p>\n\n\n\n<p>\ud83d\udc49 <a href=\"https:\/\/drive.google.com\/drive\/folders\/1ueAY7vuJod4rB5P65SRcbk8m3h0-zZ8Y?usp=drive_link\" target=\"_blank\" rel=\"noopener\"><strong>Download the Blueprint Here<\/strong><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Wrapping_Up\"><\/span>Wrapping Up:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Scraping travel sites or writing custom scripts isn\u2019t just time-consuming, it\u2019s frustrating. With <strong>Makcorps API<\/strong> and <strong>n8n<\/strong>, you now have a clean, automated way to track hotel prices in any city directly into a Google Sheet, requiring no code.<\/p>\n\n\n\n<p>Ready to take the next step? Start automating your hotel price tracking today with<a href=\"https:\/\/makcorps.com\" target=\"_blank\" rel=\"noopener\"> Makcorps<\/a>. <a href=\"https:\/\/makcorps.com\/signup.html\" target=\"_blank\" rel=\"noopener\">Sign up<\/a> now and get 30 free API calls to begin with.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Additional_Resources\"><\/span>Additional Resources:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/extract-hotel-prices-from-multiple-vendors-using-google-sheet-api\/\">Extract Hotel Prices from Multiple Vendors Using Google Sheet API<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/build-hotel-price-tracker-with-loveable\/\">Build a Hotel Price Tracker with Loveable<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/build-booking-hotel-price-finder-with-loveable\/\">Build a Booking Hotel Price Finder with Loveable<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/track-cheapest-hotel-prices-across-vendors-using-google-sheet\/\">Track Cheapest Hotel Prices Across Vendors Using Google Sheet<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/track-hotel-deals-under-budget-using-hotel-price-api\/\">Track Hotel Deals Under Budget Using Hotel Price API<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/extract-booking-com-data-with-python-and-makcorps-api\/\">Extract Booking.com Data with Python and Makcorps API<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.makcorps.com\/blog\/ota-insight-alternatives\/\" data-type=\"post\" data-id=\"2920\">Best Lighthouse Alternatives<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you need hotel price data, you already know how tricky it can get. Travel agencies rely on it to stay competitive, market researchers depend on it for accurate insights, and businesses in the tourism sector use it to make informed decisions. The problem is, getting that data usually means hiring a developer, writing complex&#8230;<\/p>\n","protected":false},"author":3,"featured_media":3176,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-3164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/posts\/3164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/comments?post=3164"}],"version-history":[{"count":5,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/posts\/3164\/revisions"}],"predecessor-version":[{"id":3253,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/posts\/3164\/revisions\/3253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/media\/3176"}],"wp:attachment":[{"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/media?parent=3164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/categories?post=3164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.makcorps.com\/blog\/wp-json\/wp\/v2\/tags?post=3164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}