Create AI Video Product Ads from Google Sheets (Shotstack)

Create vertical AI product video ads directly from your Google Sheets (Shotstack)

This n8n workflow automatically turns each product photo in your Google Sheets into a short 9:16 AI video product ad using Shotstack—then writes the finished ad link (or failure notes) back to the same row.

What this workflow does

• Reads new product rows from Google Sheets (a few per run) to keep generation efficient.
• Quotes Shotstack animation cost first and compares it to a credit limit you set—products above the limit are skipped.
• Generates an AI image-to-video animation from each product photo (your image_url must be a public link).
• Renders a 9:16 ad with an AI voiceover, plus the product name, price, and a configurable call to action.
• Saves results back to Google Sheets by writing the ad_url, or updating status and note if something fails.

Use cases

• For SaaS operators: batch-generate vertical product ads for social and mobile campaigns from a product catalog.
• For e-commerce teams: automatically produce new ad creatives when new SKUs are added to your sheet.
• For automation engineers: control spend by applying a per-product Shotstack credit limit and tracking outcomes in-sheet.

Technical details

• Google Sheets + Google Drive: select the spreadsheet/tab, store outputs to Drive, and write ad_url/status/note back to the sheet.
• Shotstack: uses your API key; generation is billed in credits on both Sandbox and Production keys.
• n8n nodes used: if, set, limit, filter, sticky note, google drive.

Setup checklist

Ensure your sheet includes: sku, name, price, image_url, voiceover, status, note, ad_url, and credits. Then connect Google credentials, Shotstack credentials, and configure ad settings (credit limit, products per run, and call to action).