Send IREPS railway tender alerts with GPT-4o-mini, Google Sheets, Slack and Telegram

Quick overview

This workflow runs daily to fetch Indian Railways tenders from IREPS, scores them against your keywords and target zones, uses OpenAI (gpt-4o-mini) to summarize and rate fit, logs results to Google Sheets, and sends alerts plus reminders and a weekly digest to Slack and Telegram.

How it works

1. Runs every day at 9:00 AM (and every Monday at 9:00 AM for the weekly digest).
2. Queries the IREPS tender search for tenders with today’s opening date, then normalizes the response into structured tender records with closing-time and value/EMD flags.
3. Loads the existing “Tenders Log” from Google Sheets and drops tenders that have already been logged to prevent duplicate alerts.
4. Scores and classifies each new tender based on keyword matches, excluded terms, watched railway zones, urgency, and tender type, then appends all new tenders (relevant or not) to the Google Sheets log.
5. If any tenders are relevant, OpenAI generates a short summary plus a 1–5 fit rating and bid/watch/skip recommendation, then the workflow ranks and sends a consolidated alert to Slack and Telegram and saves the AI fields back to Google Sheets.
6. Reads the Google Sheets log to find relevant tenders closing within the configured reminder window, sends a closing-soon reminder to Slack and Telegram, and marks each reminded tender in the log so it is not reminded again.
7. Every Monday, reads the Google Sheets log to compile a weekly digest of logged tenders, top zones/categories, best fits, and items closing soon, then posts it to Slack.

Setup

1. Add an IREPS session Cookie as an HTTP Header Auth credential and attach it to the IREPS HTTP request so the search results load consistently.
2. Create a Google Sheet with a “Tenders Log” tab and columns for tender details plus fit/action/summary and reminded status, then set the Sheet ID in all Google Sheets nodes.
3. Connect Google Sheets OAuth credentials, a Slack OAuth connection (and set the target channel ID), and a Telegram bot credential (and set the chat ID) if you want Telegram notifications.
4. Add an OpenAI API credential for the gpt-4o-mini chat model used to generate summaries and fit scoring.
5. Update the Config values (keywords, excluded keywords, minimum score, watched zones, reminder window, and business profile) to match your tender focus.