{"product_id":"n8n-google-sheets-to-shotstack-video-ads-automation","title":"n8n Google Sheets to Shotstack Video Ads Automation","description":"\u003ch3\u003eTurn your Google Sheets product list into Shotstack video ads—automatically\u003c\/h3\u003e\n\u003cp\u003eWith this \u003cstrong\u003en8n Google Sheets to Shotstack Video Ads Automation\u003c\/strong\u003e workflow, you can take a spreadsheet of products, merge each row’s \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eprice\u003c\/strong\u003e, and \u003cstrong\u003eimage URL\u003c\/strong\u003e into a saved \u003cstrong\u003eShotstack\u003c\/strong\u003e template, render a video ad per product, and write the finished \u003cstrong\u003evideo URL\u003c\/strong\u003e back into your sheet—so you design once and produce hundreds.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e to keep your product ads up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads product rows from Google Sheets\u003c\/strong\u003e and processes them \u003cstrong\u003eone at a time\u003c\/strong\u003e, creating a dedicated render per product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips rows that already contain a video URL\u003c\/strong\u003e, preventing duplicate renders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges row data into a Shotstack template\u003c\/strong\u003e using placeholders: \u003ccode\u003e{{ HEADLINE }}\u003c\/code\u003e (title), \u003ccode\u003e{{ PRICE }}\u003c\/code\u003e (price), and \u003ccode\u003e{{ PRODUCT_IMAGE }}\u003c\/code\u003e (image_url).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests render status every 10 seconds\u003c\/strong\u003e until the Shotstack render is complete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites the resulting video URL back to Google Sheets\u003c\/strong\u003e beside the corresponding product row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops and reports failures\u003c\/strong\u003e with \u003cstrong\u003eShotstack’s own reason\u003c\/strong\u003e if a render fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically generate product promo videos from an existing \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e catalog.\u003c\/li\u003e\n  \u003cli\u003eRefresh ad assets weekly as prices and images change—without rebuilding video designs.\u003c\/li\u003e\n  \u003cli\u003eKeep a \u003cstrong\u003eSKU-based\u003c\/strong\u003e workflow where rows are matched on \u003cstrong\u003esku\u003c\/strong\u003e and only missing video URLs are rendered.\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\/logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e (10-second polling), \u003ccode\u003esplit in batches\u003c\/code\u003e, and error handling via \u003ccode\u003estop and error\u003c\/code\u003e (with status reporting).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eShotstack\u003c\/strong\u003e (Sandbox key supported for testing; Sandbox renders include a watermark).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired columns:\u003c\/strong\u003e \u003ccode\u003esku\u003c\/code\u003e, \u003ccode\u003etitle\u003c\/code\u003e, \u003ccode\u003eprice\u003c\/code\u003e, \u003ccode\u003eimage_url\u003c\/code\u003e, and an empty \u003ccode\u003evideo_url\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086668189875,"sku":"N8N-19897","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sDiixnlLmPKT4MasouiNj_MJ8NA7aW.png?v=1790327639","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-to-shotstack-video-ads-automation","provider":"N8N Commerce","version":"1.0","type":"link"}