Daily Import Yesterday's Forex Factory Calendar to Google Sheets with Telegram Alerts

Overview

This n8n workflow automatically fetches the Forex Factory calendar for yesterday using Rapid API , then saves the data to a connected Google Sheet and sends Telegram alerts for high and medium impact events.

It runs daily on schedule , collecting key fields such as currency, time, impact, and market indicators , and organizes them for easy tracking and analysis. Perfect for forex traders and analysts who need quick access to reliable market data from the previous day’s events.

✅ Tasks

• ⏰ Runs automatically every day
• 🌐 Fetches yesterday’s Forex Factory calendar via Rapid API
• 🧾 Collects key data fields: year, date, time, currency, impact, actual, forecast, previous
• 📊 Saves all records to Google Sheets for tracking and analysis
• 🚨 Sends Telegram alerts for high and medium impact events
• ⚙️ Keeps your market data updated and organized with no manual work required

🛠 How to Use

• 📄 Create a Google Spreadsheet
  Create a new spreadsheet in Google Sheets and add two sheets: High Impact and Low Impact.
  Connect it to your Google Sheets nodes in n8n.

• 🌐 Find the API on Rapid API
  Go to Rapid API and search for Forex Factory Scraper.
  Subscribe to the API to get your access key.

• 🔑 Connect Rapid API to n8n
  In your HTTP Request node, add the header below to authenticate your request:

• 💬 Add Your Telegram Chat ID
  In the Telegram node, paste your Chat ID to receive daily alerts for high-impact news.

• 🕒 Activate the Workflow
  Enable the Schedule Trigger to run daily.
  The workflow will automatically fetch yesterday’s Forex Factory calendar ,
  save it to Google Sheets , and send Telegram notifications.