n8n

How to Automate Airtable Video Content Creation?

Turn blog posts into short form video assets with brand safe visuals in one run. Teams use it to scale content for social channels while keeping style and tone consistent. Ideal for marketers and agencies that repurpose articles at speed.

On start, it pulls brand guidelines, SEO keywords, and blog content from Airtable. It removes duplicate keywords and filters topics you want to cover. Content is split into scenes and a cap keeps batch size under control. A Wikipedia step adds quick facts for context. OpenAI then shapes a clean script, a scene list, and a thumbnail prompt. Each scene goes through a prompt builder, then Leonardo AI renders images. A wait and poll sequence collects finished image links. All asset data is saved back into Airtable for tracking and reuse.

You need an Airtable base for guidelines, keywords, content, and assets, plus API keys for OpenAI and Leonardo AI. Expect large time savings in storyboarding and image creation, and stronger brand consistency. Great for social teams, YouTube Shorts editors, and agencies that need steady output from existing blogs.

What are the key features?

  • Manual trigger for safe test runs before scaling.
  • Airtable search nodes pull Brand Guidelines, SEO Keywords, and Content records.
  • Remove Duplicates and Keyword Filter ensure a clean and focused topic list.
  • Limit node controls how many posts run in each batch.
  • Wikipedia node adds context so scripts include quick facts.
  • OpenAI Script Prep creates a scene list, a script, and a thumbnail prompt.
  • Split Out and Loop Over Items process each scene one by one.
  • HTTP Request calls to Leonardo AI refine prompts and render images.
  • Wait and poll steps fetch final image IDs when rendering finishes.
  • Airtable writeback nodes save asset links and details for tracking.

What are the benefits?

  • Reduce manual storyboarding and image prep from 4 hours to 20 minutes per post
  • Automate about 80 percent of repeat creative tasks for each video
  • Improve brand consistency by using stored guidelines and cut off brand errors by 90 percent
  • Handle up to 10 times more content with scene by scene looping
  • Connect Airtable, OpenAI, Wikipedia, and Leonardo AI in one flow
  • Keep every asset stored and searchable in Airtable for reuse

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Airtable, OpenAI, Leonardo AI and Wikipedia. See the Tools Required section above for links to create accounts with these services.
  3. Prepare Airtable: create or open a base with tables for Brand Guidelines, SEO Keywords, Content, and Assets. Add fields for title, text, keywords, and asset links or attachments as needed.
  4. In n8n, open the Credentials menu and create an Airtable Personal Access Token. Give it read and write access to the base you will use. Name the credential clearly, for example Airtable Content Manager.
  5. Open each Airtable node in the workflow and select your Airtable credential. Choose the correct Base and Table for Brand Guidelines, SEO Keywords, Content, and Assets fields.
  6. Create an OpenAI API key in your OpenAI account. In n8n, open the Script Prep node, click Credential to connect with, choose Create new credential, and paste the API key. Select your model and set temperature if needed.
  7. Create a Leonardo AI API key in your Leonardo AI account. In n8n, open one of the Leonardo HTTP Request nodes, choose Create new credential, and follow the on screen steps to add the API key as header auth. Reuse the same credential for all Leonardo calls.
  8. Check Prompt Settings nodes and adjust image size, style, and negative prompts to match your brand. Update any default values for thumbnail and scene prompts.
  9. Set the Keyword Filter node rules to include or exclude the topics you want. Adjust the Limit node to control how many posts run per test.
  10. Wikipedia usually needs no credential. Confirm the query input is coming from your content or keywords so it returns helpful context.
  11. Click Test workflow to run a small batch. Watch the Wait steps and confirm image IDs are returned. If rendering takes longer, increase the wait time in the Wait nodes.
  12. Open your Airtable Assets table and verify new records, image URLs or attachments, and related content links are written correctly. Fix field names if any record fails to save.
  13. Troubleshooting: invalid API keys cause 401 errors in HTTP Request or OpenAI nodes. Rate limits may require longer waits. If image status stays pending, increase wait or add another poll. If Airtable writes fail, check table names, field names, and permissions.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Leonardo AI

Sign up

API: $49 / mo, 25,000 API credits / mo

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Wikipedia

Sign up

Free: $0 (public Wikimedia APIs). Enterprise Free: $0 with 5,000 on‑demand requests / mo and twice‑monthly snapshots

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.