Track flight prices with Apify Google Flights, Google Sheets, and Telegram
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on a schedule (cron 0 7 * * *). Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: On a schedule (cron 0 7 * * *).
- Set Search Parameters (Edit Fields (Set)): sets 12 fields: origin, destination, outboundDate…
- Post to Google Flights API (HTTP Request): calls an HTTP API (POST)
- Parse Flight Results (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Read Price Log from Sheets (Google Sheets): uses Google Sheets
- Log Result to Sheets (Google Sheets): append or update
- Prepare Alert Decision (Edit Fields (Set)): sets 4 fields: lowestPrice, bookingLink, routeKey…
- If: checks a condition and branches into true / false
- Encode Flight URL (Code): runs custom JavaScript code
- Send Telegram Notification (Telegram): uses Telegram
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code
From the author
Quick Overview This workflow runs daily to search flight prices via the Apify Google Flights actor, logs each check to Google Sheets, and sends a Telegram alert when the lowest price drops below your threshold and is meaningfully lower than the last notified…