{"product_id":"hotel-rate-position-tracking-bright-data-gpt-n8n-sheets-slack","title":"Hotel Rate Position Tracking: Bright Data + GPT + n8n, Sheets \u0026 Slack","description":"\u003ch3\u003eKnow where your hotel stands on Google Hotels—every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically tracks your hotel’s \u003cstrong\u003erate position on Google Hotels\u003c\/strong\u003e by scraping Bright Data, comparing you to a star-banded comp set, logging results in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sending a concise \u003cstrong\u003eGPT-5.6\u003c\/strong\u003e digest to \u003cstrong\u003eSlack\u003c\/strong\u003e—all on a weekly schedule.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned to run every Monday morning, it:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a four-date Google Hotels search grid\u003c\/strong\u003e from your settings (market term, stay length, guests, country\/currency, and date horizons).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers a single Bright Data dataset job\u003c\/strong\u003e using the grid inputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls until the Bright Data snapshot is ready\u003c\/strong\u003e (or until a maximum poll limit is reached), then downloads the full rate snapshot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and filters the results\u003c\/strong\u003e by removing sponsored booking options and excluding out-of-band properties by star rating.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates per-date performance\u003c\/strong\u003e: comp-set quartiles, your cheapest rate, your rank, and your channel spread.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses GPT-5.6\u003c\/strong\u003e to produce a short narrative note based on the computed stats (without inventing new numbers or recommending a new rate).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends one row per date\u003c\/strong\u003e to the Google Sheets “Rates” tab and posts \u003cstrong\u003ea single combined digest message\u003c\/strong\u003e to the configured Slack channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly competitive rate monitoring for SaaS operators managing multiple hotel properties.\u003c\/li\u003e\n  \u003cli\u003eRevenue managers validating how their \u003cem\u003erate position\u003c\/em\u003e shifts across specific future check-in dates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a repeatable Bright Data + Sheets + Slack reporting workflow in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBright Data\u003c\/strong\u003e: Web Scraper API credential (header-auth) for the Google Hotels dataset; snapshot polling and download.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (Chat)\u003c\/strong\u003e: GPT-5.6 to generate a brief summary from the computed metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth to append per-date rows to the “Rates” tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: OAuth to post the weekly combined digest.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/logic referenced in the workflow: \u003cstrong\u003eif, set, code, wait, slack, split out\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916307259571,"sku":"N8N-18774","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QC2A7PdLQxPTARnB-dimV_uLqtc61a.png?v=1788019739","url":"https:\/\/buyflowscripts.com\/products\/hotel-rate-position-tracking-bright-data-gpt-n8n-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}