Quick overview
Quick overview This workflow runs daily at 9 AM to scrape active tenders from India’s eProcure portal, deduplicate them against a Google Sheets log, and use OpenAI to summarize the most urgent opportunities before sending alerts via Telegram, Slack, and Gmail. How it works Runs every day at 9 AM on a schedule trigger. Fetches the eProcure portal HTML, extracts the active tenders table, and normalizes the results into structured tender records. Filters out tenders already logged in Google Sheets and removes duplicates within the current run. Sorts the remaining tenders by closing date and keeps the top five soonest-closing opportunities. Uses OpenAI (gpt-4o-mini) to summarize each tender, flag urgency, and generate a single plain-text alert message for the batch. Appends the generated alert content to a Google Sheets log and sends the same alert to Telegram, Slack, and a formatted Gmail digest email. Setup Add OpenAI API credentials for the gpt-4o-mini model used to generate summaries and the combined alert message. Connect Google Sheets OAuth credentials, create a tender log sheet, and replace YOUR_GOOGLE_SHEET_ID and the target sheet/tab selection in the append step. Connect Telegram Bot credentials and set YOUR_TELEGRAM_CHAT_ID to the chat where daily alerts should be sent. Connect Slack OAuth2 credentials and set the target channel ID for the Slack alert. Connect Gmail OAuth2 credentials and replace procurement@yourcompany.com with the recipient address for the daily digest email. An n8n automation workflow template by Rahul Joshi.
Rahul Joshi
web
paid
Others in the same category, ranked by how often they are opened.
