Answer procurement policy questions with Google Drive, Gemini, and webhooks
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 35 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Gemini and Google Sheets. It also calls hooks.slack.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Set Workflow Configuration (Edit Fields (Set)): sets 7 fields: POLICY_PDF_URL, CONFIDENCE_THRESHOLD, HELPDESK_TICKET_URL…
- Format Error Incident (Code): runs custom JavaScript code
- Normalize & Validate Request (Code): runs custom JavaScript code
- Alert on Workflow Failure (HTTP Request): calls hooks.slack.com (POST)
- Is Request Valid? (If): checks a condition and branches into true / false
- Fetch Policy PDF (HTTP Request): calls an HTTP API
- Return Validation Error (Respond to Webhook): sends the response back to the webhook caller
- Extract PDF Text (Extract from File): extracts data from a file (pdf)
- Is Policy Content Available? (If): checks a condition and branches into true / false
- Analyse Policy Document (Code): runs custom JavaScript code
…plus 22 more steps. See the full node list below.
Services it uses
HTTP calls to: hooks.slack.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Webhook
n8n-nodes-base.webhook - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Extract from File
n8n-nodes-base.extractFromFile - Switch
n8n-nodes-base.switch - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Google Sheets
n8n-nodes-base.googleSheets - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow exposes a webhook-based helpbot that answers employee questions using a policy PDF from Google Drive, generates a structured response with Google Gemini, and escalates low-confidence answers by creating a support ticket via an…