{"product_id":"n8n-workflow-google-sheets-to-shippdf-datasheets-drive","title":"n8n Workflow: Google Sheets to ShipPDF Datasheets + Drive","description":"\u003ch3\u003eGenerate PDF datasheets from Google Sheets automatically—then archive them in Google Drive\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Google Sheets product catalog, sends each new row to \u003cstrong\u003eShipPDF\u003c\/strong\u003e to render a PDF datasheet from a template, waits for generation to complete, downloads the finished PDF, and uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new products:\u003c\/strong\u003e When a new product row is added to a specified \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet, the workflow starts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends product data to ShipPDF:\u003c\/strong\u003e It maps fields from the row—\u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003emodel\u003c\/strong\u003e, \u003cstrong\u003eSKU\u003c\/strong\u003e, \u003cstrong\u003edescription\u003c\/strong\u003e, \u003cstrong\u003especifications\u003c\/strong\u003e, and an \u003cstrong\u003eoptional image URL\u003c\/strong\u003e—to the \u003cstrong\u003eShipPDF Documents API\u003c\/strong\u003e to generate a datasheet using your \u003cstrong\u003etemplate_id\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls until the PDF is ready:\u003c\/strong\u003e The workflow waits \u003cstrong\u003e3 seconds\u003c\/strong\u003e, then repeatedly checks ShipPDF document status until it becomes \u003cem\u003ecompleted\u003c\/em\u003e or \u003cem\u003efailed\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the generated PDF:\u003c\/strong\u003e If ShipPDF reports completion, the workflow downloads the PDF from the returned URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads to Google Drive:\u003c\/strong\u003e The PDF is uploaded to your chosen Drive folder with a filename based on the \u003cstrong\u003eproduct name\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures:\u003c\/strong\u003e If ShipPDF returns a \u003cem\u003efailed\u003c\/em\u003e status, the item is routed to an alert placeholder so you can add your preferred notification step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically generate sell sheets for newly added SKUs in your catalog.\u003c\/li\u003e\n  \u003cli\u003eKeep a centralized “datasheets” library in Google Drive for sales and support teams.\u003c\/li\u003e\n  \u003cli\u003eSpeed up product launches by producing updated datasheets without manual PDF creation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ components:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (new row trigger), \u003cstrong\u003eShipPDF\u003c\/strong\u003e (HTTP Bearer Auth for documents:create and documents:read), \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (PDF upload)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup essentials:\u003c\/strong\u003e Configure spreadsheet ID + sheet name, add ShipPDF API credentials, match mapped fields to your ShipPDF datasheet template schema, and select the target Drive and folder.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244549329075,"sku":"N8N-21129","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MQMhhYr_iQUrp2GCrjCvj_SQ1q7rPm.png?v=1792401460","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-to-shippdf-datasheets-drive","provider":"N8N Commerce","version":"1.0","type":"link"}