{"product_id":"send-personalized-campaign-pdfs-google-sheets-pdf-co-gmail","title":"Send Personalized Campaign PDFs: Google Sheets + PDF.co + Gmail","description":"\u003ch3\u003eAutomatically generate personalized campaign PDFs from Google Sheets and email them via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Google Sheets for new rows, generates a customized PDF using a saved HTML template in PDF.co (including optional logo stamping), downloads the finished file, and sends it to the recipient by Gmail—fully automated and ready for production use.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Google Sheets\u003c\/strong\u003e: Triggers every minute when a new row is added to a selected worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a PDF from your template\u003c\/strong\u003e: Sends the row fields to \u003cstrong\u003ePDF.co\u003c\/strong\u003e to render a personalized PDF from a saved \u003cstrong\u003eHTML template\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStamps your logo onto the PDF\u003c\/strong\u003e: Uses \u003cstrong\u003ePDF.co logo stamping\u003c\/strong\u003e with configured coordinates to place a logo image onto the generated document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the finalized PDF\u003c\/strong\u003e: Retrieves the completed file from the returned \u003cstrong\u003ePDF.co URL\u003c\/strong\u003e as a binary attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery through Gmail\u003c\/strong\u003e: Sends the PDF as an attachment via \u003cstrong\u003eGmail\u003c\/strong\u003e, using the row values (e.g., \u003cem\u003ecustomer_email\u003c\/em\u003e) to determine the recipient and compose the email subject\/message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend \u003cstrong\u003epersonalized marketing or campaign collateral\u003c\/strong\u003e (mailers, one-pagers, announcements) to leads added in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomate \u003cstrong\u003eevent follow-ups\u003c\/strong\u003e where each attendee receives a tailored PDF with unique text, images, and CTA details.\u003c\/li\u003e\n  \u003cli\u003eOperational teams generating \u003cstrong\u003ebrand-consistent PDF documents\u003c\/strong\u003e with a stamped logo and row-specific content.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger\u003c\/strong\u003e: \u003ccode\u003egoogle sheets trigger\u003c\/code\u003e (runs every minute on new rows)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF generation + logo stamping\u003c\/strong\u003e: \u003ccode\u003en8n-nodes-pdfco PDF.co API\u003c\/code\u003e (HTML template + stamping)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFile download\u003c\/strong\u003e: \u003ccode\u003eHTTP Request\u003c\/code\u003e to download the PDF from the PDF.co result URL\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail sending\u003c\/strong\u003e: \u003ccode\u003egmail\u003c\/code\u003e node (attachment delivery to \u003cem\u003ecustomer_email\u003c\/em\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional workflow documentation\u003c\/strong\u003e: \u003ccode\u003eSticky Note\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd required header columns in your sheet (e.g., \u003cem\u003ecustomer_name\u003c\/em\u003e, \u003cem\u003ecustomer_email\u003c\/em\u003e, \u003cem\u003ecampaign_title\u003c\/em\u003e, \u003cem\u003ehero_image\u003c\/em\u003e, \u003cem\u003ecta_link\u003c\/em\u003e, \u003cem\u003ecta_text\u003c\/em\u003e, \u003cem\u003ecompany_name\u003c\/em\u003e, and others as needed by your template).\u003c\/li\u003e\n  \u003cli\u003eCreate the HTML template in \u003cstrong\u003ePDF.co\u003c\/strong\u003e, then paste the \u003cstrong\u003etemplate ID\u003c\/strong\u003e into the PDF generation step.\u003c\/li\u003e\n  \u003cli\u003eConfigure PDF.co logo stamping with a public \u003cstrong\u003eHTTPS logo URL\u003c\/strong\u003e (or \u003cstrong\u003efiletoken:\/\/\u003c\/strong\u003e) and align \u003cstrong\u003estamp coordinates\u003c\/strong\u003e to your layout.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGmail\u003c\/strong\u003e credentials and map \u003cem\u003ecustomer_email\u003c\/em\u003e to the recipient.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244549001395,"sku":"N8N-21131","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BxNikmIi0vc3MQU4Q4u9G_UiHPu1Gc.png?v=1792401399","url":"https:\/\/buyflowscripts.com\/products\/send-personalized-campaign-pdfs-google-sheets-pdf-co-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}