Score GeM tender compliance and draft bid responses with OpenAI, Sheets, Telegram, Slack and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent - Compliance Analysis (v1.7), AI Agent - Draft Full GeM Response (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - No Operation, do nothing
n8n-nodes-base.noOp - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
What it does
Quick overview This workflow collects GeM tender details via an n8n Form, validates the submission deadline, checks Google Sheets for duplicates, and uses OpenAI (gpt-4o-mini) to score technical compliance and draft a GeM technical bid response, then delivers it via Telegram, Slack, and Gmail and logs it to Google Sheets. How it works 1. Receives a GeM tender response request from an n8n Form submission. 2. Parses the bid submission deadline to stop and alert via Telegram if it appears expired, or sends an urgent Telegram warning when the deadline is close. 3. Reads existing entries from Google Sheets and skips processing with a Telegram notice if the tender ID is already logged. 4. Builds a structured tender context and sends it to OpenAI (gpt-4o-mini) to generate a per-requirement compliance JSON and overall compliance percentage. 5. Flags low compliance (or unparseable AI output) and sends a Telegram “review needed” alert while continuing to draft the response. 6. Sends the tender context and the pre-computed compliance results to OpenAI (gpt-4o-mini) to draft a structured GeM technical bid response as plain text. 7. Logs the drafted response and metadata to Google Sheets, then sends the final package to Telegram, Slack, and Gmail. Setup 1. Add OpenAI credentials and ensure the model selection is available for both the compliance analysis and response drafting steps. 2. Connect Google Sheets OAuth2 credentials and replace YOURGEMRESPONSESSHEETID and YOURTENDERSLOGSHEETID with your spreadsheet IDs for the “GeM Tender Responses” and “Tenders Log” documents. 3. Connect a Telegram Bot API credential and replace YOURTELEGRAMCHATID anywhere Telegram messages are sent. 4. Connect Slack OAuth2 credentials and set the target Slack channel ID for both the final response message and the workflow error alert. 5. Connect Gmail OAuth2 credentials and update the recipient address (for example, [email protected]) in the email step. 6. Activate the form trigger and share the generated form URL with your procurement/bid team.