See llms.txt for all machine-readable content.

Back to Templates

Send state tender digests with GPT-4o-mini, Google Sheets, Slack and Telegram

Created by

Created by: Rahul Joshi || rahul08
Rahul Joshi

Last update

Last update 8 hours ago

Categories

Quick overview

This workflow runs daily to fetch tender listings from central eProcure plus the Madhya Pradesh and Uttar Pradesh portals, dedupes and tracks deadline changes in Google Sheets, uses OpenAI to summarize and score fit, and sends per-state digests and closing reminders to Telegram and Slack.

How it works

  1. Runs every day at 9 AM (cron schedule) and loads a configuration that defines portal URLs, watched states, routing targets, keywords, and reminder rules.
  2. Fetches tender pages from the central eProcure portal and the MP and UP tender portals, then parses and limits each source to the most recent listings.
  3. Classifies central eProcure tenders to watched states based on the tender title, merges all sources, deduplicates the combined list, and posts a Slack warning if any portal fails or its layout appears to have changed.
  4. Reads the existing State Tenders Log from Google Sheets, filters out already-alerted or closed tenders, detects and re-alerts deadline changes, and scores remaining tenders by keyword matches and time-to-close.
  5. Sends each tender to OpenAI (gpt-4o-mini) to generate a short summary, category, fit score, and a bid/watch/skip recommendation, then ranks items using both the rule-based score and AI fit.
  6. Builds one digest per state and sends it to the configured Telegram chat and Slack channel (with fallbacks), then appends or updates the processed tenders in the Google Sheets log.
  7. Separately scans the Google Sheets log for tenders closing within the configured reminder window that have not been reminded, sends per-state reminder messages to Telegram and Slack, and marks those tenders as reminded in Google Sheets.

Setup

  1. Add credentials for Google Sheets, Slack, Telegram, and OpenAI (ChatGPT), or remove the Telegram steps if you only want Slack notifications.
  2. Update the Config values with your three portal listing URLs, watched states, keywords/business profile, and the default Slack channel ID and Telegram chat ID.
  3. Create a Google Sheet with a tab named “State Tenders Log” using the expected columns (including a unique key column), and replace REPLACE_WITH_GOOGLE_SHEET_ID in all Google Sheets steps.
  4. In Slack, ensure the bot has access to the target channels and set valid channel IDs for each state (or rely on the default channel).
  5. In Telegram, obtain the chat IDs for each state and the default chat, and ensure the bot is added to those chats with permission to post.