n8n Webhook: Generate Hardware PDF Catalogs from Google Sheets

Generate branded hardware PDF catalogs from Google Sheets—instantly via an n8n webhook

This n8n workflow exposes a webhook that lets you search your hardware catalog in Google Sheets by keyword and maxPrice, renders matching results into a styled HTML catalog, converts it to a PDF using PDFShift, emails the PDF with Gmail, archives it in Google Drive, and returns the HTML to the caller.

What this workflow does

• Receives a webhook request with query parameters: search, maxPrice, and optional email.
• Reads your full hardware product list from a specified Google Sheets spreadsheet/tab.
• Filters products by keyword/category match and the provided price threshold, then computes summary metrics for the catalog.
• Generates a styled HTML catalog (sanitizing the email input and using a default recipient when missing).
• Converts HTML to PDF through the PDFShift API.
• Uploads the PDF to Google Drive into a target folder as a dated backup.
• Emails the PDF attachment using Gmail, including the search summary in the email message.
• Responds to the webhook with the generated HTML as text/html.

Use cases

• Provide a “request a catalog” API for SaaS or internal sales teams based on budget and product keyword.
• Automate PDF generation for hardware promotions and quotes without manual document formatting.
• Archive every generated catalog in Google Drive for traceability and follow-up.

Technical details

• Webhook trigger with query parameters (search, maxPrice, optional email).
• Google Sheets OAuth2 access to retrieve the hardware catalog list.
• Code node for filtering, summary metrics, and HTML generation.
• HTTP Request to PDFShift for HTML → PDF conversion (requires API key in Authorization).
• Gmail node to email the PDF attachment.
• Google Drive node to upload the PDF to a selected folder.

Ideal for n8n automation engineers and operations teams that need reliable, repeatable hardware catalog PDFs driven by Google Sheets data.