{"product_id":"n8n-workflow-consent-aware-birthday-videos-from-google-sheets-zvid","title":"n8n Workflow: Consent-Aware Birthday Videos from Google Sheets + Zvid","description":"\u003ch3\u003eCreate consent-aware birthday and anniversary videos from Google Sheets using n8n + Zvid\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow turns approved, consented Google Sheets birthday\/anniversary records into private branded videos via the Zvid node—using annual render keys, a recovery log, and job resumption so interrupted runs don’t create duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually or on a schedule:\u003c\/strong\u003e reads celebration records once and loads a separate \u003cem\u003eCelebration Runs\u003c\/em\u003e recovery log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects one due occasion with approval and greeting consent:\u003c\/strong\u003e respects \u003cem\u003eDoNotContact\u003c\/em\u003e, timezone handling, and special \u003cem\u003eFebruary 29\u003c\/em\u003e rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate renders:\u003c\/strong\u003e uses separate annual keys for \u003cstrong\u003ebirthday\u003c\/strong\u003e and \u003cstrong\u003eanniversary\u003c\/strong\u003e so each occasion renders once per year.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResumes accepted jobs before selecting new paid work:\u003c\/strong\u003e checks the recovery log and continues accepted jobs instead of starting fresh.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates and validates a two-scene branded greeting:\u003c\/strong\u003e builds the greeting, validates the design, then checks \u003cstrong\u003eCreditsQuoted\u003c\/strong\u003e against your configured credit ceiling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSubmits to Zvid safely:\u003c\/strong\u003e with \u003cstrong\u003edryRun=false\u003c\/strong\u003e, it records the submission and renders through \u003cstrong\u003ezvidn8n-nodes-zvid\u003c\/strong\u003e. Capacity rejections allow up to \u003cstrong\u003ethree submission attempts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks completion:\u003c\/strong\u003e waits for the accepted job, then saves final status and \u003cstrong\u003eVideoUrl\u003c\/strong\u003e in \u003cem\u003eCelebration Runs\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExports outputs:\u003c\/strong\u003e provides \u003cem\u003eWatch video\u003c\/em\u003e and a \u003cstrong\u003ereview CSV\u003c\/strong\u003e. Email delivery is \u003cstrong\u003edisabled by default\u003c\/strong\u003e and requires separate approval of the recipient.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomation engineers creating a consent-aware video campaign pipeline for users stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need resumable, non-duplicating renders with annual keys and a recovery log.\u003c\/li\u003e\n  \u003cli\u003eTeams managing privacy controls (DoNotContact) while still generating personalized birthday\/anniversary videos.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n setup:\u003c\/strong\u003e self-hosted n8n recommended.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Zvid node:\u003c\/strong\u003e install \u003ccode\u003e@zvid\/n8n-nodes-zvid\u003c\/code\u003e via Settings → Community nodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eZvid credentials:\u003c\/strong\u003e create an API credential at \u003ccode\u003ehttps:\/\/app.zvid.io\/api-keys\u003c\/code\u003e with Base URL \u003ccode\u003ehttps:\/\/api.zvid.io\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e configure a source tab plus a \u003cem\u003eCelebration Runs\u003c\/em\u003e tab with columns: \u003ccode\u003eRenderKey\u003c\/code\u003e, \u003ccode\u003eStatus\u003c\/code\u003e, \u003ccode\u003eJobId\u003c\/code\u003e, \u003ccode\u003eCreditsQuoted\u003c\/code\u003e, \u003ccode\u003ePlanJson\u003c\/code\u003e, \u003ccode\u003eVideoUrl\u003c\/code\u003e, \u003ccode\u003eCompletedAt\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e if, set, code, wait, email send, and zvidn8n-nodes-zvid.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192832938163,"sku":"N8N-20675","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bwjiellw9UkJ-FlrNg_DU_TVgIEalv.png?v=1791536928","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-consent-aware-birthday-videos-from-google-sheets-zvid","provider":"N8N Commerce","version":"1.0","type":"link"}