{"product_id":"n8n-workflow-ai-promo-posters-to-vips-via-gmail-google-sheets","title":"n8n Workflow: AI Promo Posters to VIPs via Gmail + Google Sheets","description":"\u003ch3\u003eAutomate VIP promotion emails with an AI-generated poster—driven by your Google Sheets campaign\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e watches a Google Sheets campaign sheet for status changes, generates a \u003cstrong\u003etext-free AI promo poster\u003c\/strong\u003e with OpenAI, uploads it to \u003cstrong\u003eUploadToURL\u003c\/strong\u003e to get a public embed link, then sends \u003cstrong\u003epersonalized HTML Gmail promo emails\u003c\/strong\u003e to \u003cstrong\u003eVIP members\u003c\/strong\u003e from another Google Sheets mailing list.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors campaign status changes\u003c\/strong\u003e: runs every minute and triggers when the \u003cem\u003eStatus\u003c\/em\u003e column changes in your campaign Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a promotional image\u003c\/strong\u003e: uses \u003cstrong\u003eOpenAI image generation\u003c\/strong\u003e to create a text-free poster background based on your \u003cem\u003eOffer Details\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes the poster for embedding\u003c\/strong\u003e: uploads the generated image via \u003cstrong\u003eUploadToURL\u003c\/strong\u003e and retrieves a public URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets only VIP contacts\u003c\/strong\u003e: reads your customer mailing list from Google Sheets and filters rows where \u003cem\u003eVIP Member\u003c\/em\u003e is set to \u003cstrong\u003eYes\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends personalized Gmail messages\u003c\/strong\u003e: for each VIP, it sends an HTML email via Gmail including the \u003cem\u003ecampaign name\u003c\/em\u003e, \u003cem\u003eoffer details\u003c\/em\u003e, \u003cem\u003epromo code\u003c\/em\u003e, recipient name (First Name), and the \u003cstrong\u003eembedded poster image URL\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLaunch new offers: update Status in the campaign sheet and automatically notify VIPs with a fresh AI poster.\u003c\/li\u003e\n  \u003cli\u003eEvent-based promos: switch a campaign’s status to trigger targeted VIP email blasts.\u003c\/li\u003e\n  \u003cli\u003eOngoing retention campaigns: keep messaging consistent by managing everything from Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets Trigger\u003c\/strong\u003e: detects \u003cem\u003eStatus\u003c\/em\u003e changes in the campaign sheet (runs every minute).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (image generation)\u003c\/strong\u003e: creates a \u003cstrong\u003etext-free\u003c\/strong\u003e promotional background from Offer Details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploadToURL\u003c\/strong\u003e: uploads the image and returns a public, embeddable link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets (mailing list)\u003c\/strong\u003e: retrieves customers and filters for \u003cem\u003eVIP Member = Yes\u003c\/em\u003e (uses Email Address and First Name).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends personalized HTML promo emails to each VIP contact.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet up requires OAuth for Google Sheets and Gmail, OpenAI credentials (with image model availability), and an UploadToURL credential.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223957360819,"sku":"N8N-20889","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uzG5kVc27OlloFIJJsRip_gTLekaij.png?v=1791969830","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-ai-promo-posters-to-vips-via-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}