Google Flights Weekly Fare Snapshots to Google Sheets (n8n + Apify)

Weekly Google Flights fare snapshots in Google Sheets—automatically

This n8n workflow runs every Monday morning to search the Google Flights routes you define and append all returned fare options into Google Sheets, with the cheapest fare marked first and every other offer showing the extra cost vs. the cheapest. No fare alert service, no airline account—just repeatable weekly tracking.

What this workflow does

• Schedules weekly: the workflow runs every Monday morning.
• Loads your route plan: origin, destination, outbound/return dates, currency, and passenger count.
• Searches fares via Apify: uses the Apify Google Flights Data Scraper actor (flight and price search) to retrieve fare results for each route.
• Normalizes results to rows: expands results so each fare becomes a consistent Google Sheets row (price, airline, stops, duration, times, and flight numbers).
• Sorts and compares: 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.
• Builds a dated price history: appends all formatted fare rows to your chosen Google Sheets worksheet for ongoing tracking over time.

Use cases

• Track weekly price movement for fixed travel dates and compare “cheapest so far” across time.
• Maintain an internal dataset for SaaS or operations teams to monitor route pricing without manual checking.
• Use the sheet as a reporting source to spot which routes consistently show better value.

Technical details

• n8n schedule: Monday morning execution.
• Apify integration: requires an Apify API token and runs the actor “johnvc~Google-Flights-Data-Scraper-Flight-and-Price-Search”.
• Google Sheets: connected in n8n; workflow appends rows to a selected spreadsheet/worksheet.
• Workflow logic: uses nodes like set, code, sort, split out, filter, and (optional) Slack for notifications.

Swap example routes, dates, currency, and passenger count with your own to start generating weekly Google Flights snapshots in Google Sheets.