{"product_id":"n8n-webhook-generate-hardware-pdf-catalogs-from-google-sheets","title":"n8n Webhook: Generate Hardware PDF Catalogs from Google Sheets","description":"\u003ch3\u003eGenerate branded hardware PDF catalogs from Google Sheets—instantly via an n8n webhook\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow exposes a webhook that lets you search your hardware catalog in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e by \u003cstrong\u003ekeyword\u003c\/strong\u003e and \u003cstrong\u003emaxPrice\u003c\/strong\u003e, renders matching results into a styled \u003cstrong\u003eHTML catalog\u003c\/strong\u003e, converts it to a \u003cstrong\u003ePDF\u003c\/strong\u003e using \u003cstrong\u003ePDFShift\u003c\/strong\u003e, emails the PDF with \u003cstrong\u003eGmail\u003c\/strong\u003e, archives it in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and returns the HTML to the caller.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a webhook request\u003c\/strong\u003e with query parameters: \u003ccode\u003esearch\u003c\/code\u003e, \u003ccode\u003emaxPrice\u003c\/code\u003e, and optional \u003ccode\u003eemail\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your full hardware product list\u003c\/strong\u003e from a specified Google Sheets spreadsheet\/tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters products\u003c\/strong\u003e by keyword\/category match and the provided price threshold, then computes summary metrics for the catalog.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a styled HTML catalog\u003c\/strong\u003e (sanitizing the email input and using a default recipient when missing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts HTML to PDF\u003c\/strong\u003e through the \u003cstrong\u003ePDFShift API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the PDF to Google Drive\u003c\/strong\u003e into a target folder as a dated backup.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the PDF attachment\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e, including the search summary in the email message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResponds to the webhook\u003c\/strong\u003e with the generated HTML as \u003ccode\u003etext\/html\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvide a “request a catalog” API for SaaS or internal sales teams based on budget and product keyword.\u003c\/li\u003e\n  \u003cli\u003eAutomate PDF generation for hardware promotions and quotes without manual document formatting.\u003c\/li\u003e\n  \u003cli\u003eArchive every generated catalog in Google Drive for traceability and follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e trigger with query parameters (\u003ccode\u003esearch\u003c\/code\u003e, \u003ccode\u003emaxPrice\u003c\/code\u003e, optional \u003ccode\u003eemail\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 access to retrieve the hardware catalog list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e node for filtering, summary metrics, and HTML generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to \u003cstrong\u003ePDFShift\u003c\/strong\u003e for HTML → PDF conversion (requires API key in Authorization).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node to email the PDF attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e node to upload the PDF to a selected folder.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eIdeal for n8n automation engineers\u003c\/strong\u003e and operations teams that need reliable, repeatable hardware catalog PDFs driven by Google Sheets data.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824220233907,"sku":"N8N-18140","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/IuKeL0X3EA4suFKc58MfV_EQXfYuvK.png?v=1786612970","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-generate-hardware-pdf-catalogs-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}