{"product_id":"google-flights-weekly-fare-snapshots-to-google-sheets-n8n-apify","title":"Google Flights Weekly Fare Snapshots to Google Sheets (n8n + Apify)","description":"\u003ch3\u003eWeekly Google Flights fare snapshots in Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday morning to search the Google Flights routes you define and append \u003cstrong\u003eall returned fare options\u003c\/strong\u003e into Google Sheets, with the cheapest fare marked first and every other offer showing the \u003cstrong\u003eextra cost vs. the cheapest\u003c\/strong\u003e. No fare alert service, no airline account—just repeatable weekly tracking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly:\u003c\/strong\u003e the workflow runs every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your route plan:\u003c\/strong\u003e origin, destination, outbound\/return dates, currency, and passenger count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches fares via Apify:\u003c\/strong\u003e uses the \u003cstrong\u003eApify Google Flights Data Scraper\u003c\/strong\u003e actor (flight and price search) to retrieve fare results for each route.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes results to rows:\u003c\/strong\u003e expands results so each fare becomes a consistent Google Sheets row (price, airline, stops, duration, times, and flight numbers).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSorts and compares:\u003c\/strong\u003e sorts fares by route and price, marks the cheapest fare on each route, and calculates how much more every other fare costs vs. that cheapest option.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a dated price history:\u003c\/strong\u003e appends all formatted fare rows to your chosen Google Sheets worksheet for ongoing tracking over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack weekly price movement for fixed travel dates and compare “cheapest so far” across time.\u003c\/li\u003e\n  \u003cli\u003eMaintain an internal dataset for SaaS or operations teams to monitor route pricing without manual checking.\u003c\/li\u003e\n  \u003cli\u003eUse the sheet as a reporting source to spot which routes consistently show better value.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedule:\u003c\/strong\u003e Monday morning execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e requires an Apify API token and runs the actor \u003cem\u003e“johnvc~Google-Flights-Data-Scraper-Flight-and-Price-Search”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e connected in n8n; workflow appends rows to a selected spreadsheet\/worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e uses nodes like \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003esort\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, and (optional) \u003cem\u003eSlack\u003c\/em\u003e for notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSwap example routes, dates, currency, and passenger count with your own to start generating weekly Google Flights snapshots in Google Sheets.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830421741747,"sku":"N8N-18222","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/g-kx_ibPm0WEhZOfmj2KI_aHU7Rx7d.png?v=1786698744","url":"https:\/\/buyflowscripts.com\/products\/google-flights-weekly-fare-snapshots-to-google-sheets-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}