Generate hardware PDF catalogs from Google Sheets with PDFShift, Gmail, and Google Drive
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 9 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Google Sheets, Google Drive, Gmail and Google Gemini.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Fetch Google Sheet Data (Google Sheets): uses Google Sheets
- Keyword Parsing (Code): runs custom JavaScript code
- Message a model (Google Gemini): uses Google Gemini
- General HTML (Code): runs custom JavaScript code
- Code: runs custom JavaScript code
- Send a message (Gmail): uses Gmail
- Upload file (Google Drive): uses Google Drive
- Respond to Webhook: sends the response back to the webhook caller
Services it uses
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 (7)
- Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Drive
n8n-nodes-base.googleDrive - Gmail
n8n-nodes-base.gmail - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Code
n8n-nodes-base.code
From the author
Quick overview This workflow exposes a webhook that searches a Google Sheets hardware catalog by keyword and maximum price, renders the matching results into an HTML catalog, converts it to a PDF via PDFShift, returns the HTML to the requester, emails the PDF…