Introduction

Imagine effortlessly generating a steady stream of trivia, "guess the word," or "true or false" quizzes, each tailored to different topics or languages, without spending hours on manual video editing. This tutorial will show you how to automate the creation of dynamic quiz videos using Make.com, OpenAI, Airtable, and JSON2Video, transforming your content production workflow.

Examples

Input variables Resulting video
  • Topic: "Cinema"
  • Language: "English"
  • Voice: "en-US-AmandaMultilingualNeural"
  • Voice Model: "azure"
  • Difficulty: "Expert"
  • Font: "Noto Sans"
  • Topic: "World geography"
  • Language: "Korean"
  • Voice: "ko-KR-SunHiNeural"
  • Voice Model: "azure"
  • Difficulty: "Expert"
  • Font: "Noto Sans KR"
  • Topic: "Middle East History"
  • Difficulty: "Average"
  • Language: "Arabic"
  • Voice: "ar-SA-ZariyahNeural"
  • Voice Model: "azure"
  • Font: "Noto Sans Arabic"

Overview of the automation

This automation workflow leverages Airtable as the central content hub, where you'll input quiz topics, desired difficulty, and language settings. Make.com then takes over, triggering a sequence of events: first, it fetches the quiz details from Airtable. Next, it sends this information to OpenAI, which generates the quiz questions, answer options, and intro/outro voiceovers in the specified language and format. The generated content is then passed to JSON2Video, which uses a pre-designed template to render a high-quality quiz video. Finally, the automation updates the Airtable base with the URL of the newly created video, making it ready for sharing.

Airtable base for quiz videos

Prerequisites

To follow this tutorial and build your quiz video automation, you'll need accounts for the following services:

Build the automation

Now, let's dive into setting up each component of our automation to create your first quiz video.

Setting the Airtable base

Clone the Airtable base

To get started, you'll need a structured Airtable base to store your quiz data. Follow these steps to clone our pre-built template:

  1. Open the Airtable quiz template.
  2. In the top-left corner, click on the "Copy base" button (next to the base name). A new window will appear.
  3. Select the destination workspace in your Airtable account where you'd like to copy the base.

Once cloned, your base will contain a table named "Quizzes" with the following fields:

Field name Description
ID An auto-numbered unique identifier for each quiz record.
Topic The subject matter of the quiz (e.g., "Everyday science", "World Capitals").
Difficulty The desired difficulty level for the quiz (e.g., "Easy", "Average", "Expert").
Language The target language for the quiz questions and voiceovers (e.g., "English", "Spanish", "Japanese").
Voice Name The name of the AI voice to be used for the voiceovers (e.g., "en-US-JennyMultilingualNeural").
Voice Model The AI model provider for the voice (e.g., "azure", "elevenlabs").
Font The name of the font to be used in the video (e.g., "Oswald", "Noto Sans JP").
Status The current status of the video generation ("Todo", "In progress", "Done").
Result The URL of the generated quiz video once it's complete.

Get your Airtable personal access token

To allow Make.com to connect with your Airtable base, you'll need a Personal Access Token (PAT). Follow these steps to obtain it:

Getting your API keys

Get your OpenAI API key

You'll need an API key from OpenAI to allow Make.com to generate quiz content. If you don't have one, navigate to your OpenAI API keys page, click on "Create new secret key," give it a memorable name, and copy the key. Store it securely, as it will only be shown once.

Get your JSON2Video API key

To connect Make.com to JSON2Video, you'll need an API key. While you can use your Primary API key, it's recommended to create a Secondary API key with "Render" permissions for enhanced security. This allows you to manage and revoke Make.com's access independently if needed.

Follow these steps to obtain your JSON2Video API key:

  1. Go to the JSON2Video API key page.
  2. If you don't have an account, sign up. If you do, log in to your dashboard.
  3. Navigate to the API Keys section.
  4. Click "Create new API Key."
  5. Give your new key a descriptive name (e.g., "Make.com Quiz Videos").
  6. Select the "Render" role for the key.
  7. Click "Create."
  8. Copy the generated API key. Keep it safe, as you won't be able to retrieve it later.

Create the workflow

Import the workflow

To streamline the setup, you can import our pre-built Make.com workflow:

  1. Log in to your Make.com account.
  2. In the left sidebar, click on "Scenarios."
  3. Click the "Create a new scenario" button in the top right.
  4. In the new scenario window, click on the "More" (three dots) icon in the bottom center.
  5. Select "Import from File..."
  6. Download the workflow definition file and upload it to Make.com.
  7. A new scenario will be created with all the necessary modules.
Make.com workflow for quiz videos

Update the module settings

Once the workflow is imported, you'll need to configure the connections for Airtable, OpenAI, and JSON2Video:

Update the Airtable modules

The workflow contains two Airtable modules: "Search Records" (at the beginning) and "Update Records" (at the end). Both need to be connected to your Airtable account using the Personal Access Token (PAT) you generated earlier.

  1. Double-click on the "Search Records" Airtable module.
  2. Under the "Connection" field, click "+ Create a connection."
  3. In the "Create a connection" dialog, paste your Airtable Personal Access Token into the "Access Token" field. Give your connection a name (e.g., "My Airtable Connection").
  4. Click "Save."
  5. Ensure the "Base" is set to "Entertainment" and "Table" is set to "Quizzes".
  6. Repeat these steps for the "Update Records" Airtable module.
Update the OpenAI modules

The workflow includes one OpenAI module: "Create a Chat Completion." This module uses OpenAI's API to generate the quiz content.

  1. Double-click on the "Create a Chat Completion" OpenAI module.
  2. Under the "Connection" field, click "+ Create a connection."
  3. Paste your OpenAI API Key into the "API Key" field. Give your connection a name (e.g., "My OpenAI Connection").
  4. Click "Save."
Update the JSON2Video modules

The workflow uses two JSON2Video modules: "Create a Movie from a Template ID" and "Wait for a Movie to Render." Both need to be authenticated with your JSON2Video API key.

  1. Double-click on the "Create a Movie from a Template ID" JSON2Video module.
  2. Under the "Connection" field, click "+ Create a connection."
  3. Paste your JSON2Video API key into the "API Key" field. Give your connection a name (e.g., "My JSON2Video Connection").
  4. Click "Save."
  5. Ensure the "Template ID" is set to cSTYFRZhXeBZotbwcjuM. This is the ID for the quiz video template.
  6. Repeat these steps for the "Wait for a Movie to Render" JSON2Video module.

The JSON payload passed to JSON2Video API for the "Create a Movie from a Template ID" module sets a pre-designed JSON2Video template with ID cSTYFRZhXeBZotbwcjuM. It passes dynamic content as variables, including the voice name, voice model, topic, intro, outro, questions, and font from your Airtable data and OpenAI's output. The background video and color scheme are set statically in this template for a consistent quiz aesthetic.

JSON2Video settings for quiz videos

Run your first automated video creation

Once all your connections and modules are configured, you're ready to create your first automated quiz video:

  1. In your Airtable "Quizzes" base, enter values for the following columns for a new row:
    • Topic: e.g., "World Capitals"
    • Difficulty: e.g., "Average"
    • Language: e.g., "English"
    • Voice Name: e.g., "en-US-JennyMultilingualNeural" (a common Azure voice)
    • Voice Model: "azure"
    • Font: e.g., "Oswald"
    • Status: Set this to "Todo" (this is crucial for the Make.com scenario to pick it up).
  2. In your Make.com scenario editor, click on the "Run once" button in the bottom-center.
  3. The workflow will execute:
    • It will search Airtable for records with "Todo" status.
    • It will send the quiz details to OpenAI to generate questions.
    • It will then send the generated content to JSON2Video to render the video.
    • Finally, it will wait for the video to complete and update the Airtable record.
  4. Go back to your Airtable base. After a few minutes (depending on the video length and API queues), the "Status" column for your quiz entry should change to "Done," and the "Result" column will be populated with the URL to your new video. Click the URL to watch your AI-generated quiz!

Localizing your videos into other languages

A significant advantage of this automated workflow is its ability to localize your quiz videos into multiple languages with minimal effort. This is primarily handled by the OpenAI and JSON2Video integrations, which support a wide range of languages for both text generation and voiceovers. To localize a video, you primarily need to adjust three fields in your Airtable base:

  1. Set the target language in Airtable: Change the Language field to your desired language (e.g., "Japanese", "Spanish", "Arabic"). OpenAI will then generate the quiz questions, answers, and voiceover text in that language.
  2. Choose a compatible font: Ensure the Font you select supports the characters of your target language. For example, for Japanese or Chinese, a font like "Noto Sans JP" or "Simplified Chinese" will be necessary, as "Oswald" would not display correctly. You can refer to the JSON2Video documentation on available fonts.
  3. Select a matching voice: The Voice Name and Voice Model fields must correspond to an AI voice that supports your chosen language. For Azure, you can browse the full list of supported Azure voices by language to find an appropriate voice (e.g., "ja-JP-NanamiNeural" for Japanese).

Example: creating a video in 日本語 (Japanese)

Let's create a quiz video in Japanese:

  1. In your Airtable "Quizzes" table, add a new row or modify an existing one.
  2. Set the following values:
    • Topic: Cinema
    • Difficulty: Easy
    • Language: "Japanese"
    • Voice Name: "ja-JP-NanamiNeural" (a standard Japanese voice from Azure)
    • Voice Model: "azure"
    • Font: "Noto Sans JP" (a font that supports Japanese characters)
    • Status: "Todo"
  3. Run the Make.com scenario (by clicking "Run once").
  4. Observe how OpenAI generates the quiz content in Japanese, and JSON2Video renders the video using the specified Japanese font and voice. The "Result" column in Airtable will contain the link to your Japanese quiz video.
Input variables Resulting video
  • Topic: "Cinema"
  • Language: "Japanese"
  • Voice: "ja-JP-NanamiNeural"
  • Voice Model: "azure"
  • Difficulty: "Easy"
  • Font: "Noto Sans JP"

This demonstrates how easily you can scale your video content to reach a global audience by simply adjusting a few parameters in your Airtable base.

Using alternative AI models

The workflow is configured to use Microsoft Azure for voiceovers and does not use an AI image model by default. Azure voices are included in all JSON2Video plans without consuming additional credits. However, JSON2Video also supports other powerful AI models like ElevenLabs for voices, which offer different voice characteristics and qualities but consume extra credits. For images, if you were to add an AI-generated image, the default is often a free model like Freepik Classic, but a premium model like Flux Pro could also be used.

You can find more details on credit consumption for various AI models in the JSON2Video documentation.

Using ElevenLabs

If you wish to use ElevenLabs for your voiceovers, you need to change the Voice Model column in your Airtable row to 'elevenlabs' and choose a supported voice in the Voice Name column. For example, you might use "Rachel" or "Adam".

You can find a list of supported ElevenLabs voices in the JSON2Video ElevenLabs voices documentation.

Note: Using ElevenLabs will consume extra credits as detailed in the JSON2Video pricing documentation.

Customizing your videos

The power of JSON2Video lies in its flexibility. Beyond simply generating videos, you can deeply customize their appearance, content, and even underlying AI logic. This section explores three key ways to tailor your quiz videos.

Using template variables

The JSON2Video movie template (ID cSTYFRZhXeBZotbwcjuM) defines several variables that allow for easy customization without altering the core template structure. These variables are populated directly from your Airtable inputs or OpenAI's output in the Make.com scenario.

Refining the AI-Generated content

The quiz content (questions, answers, intro/outro voiceovers) is dynamically generated by OpenAI based on a "system prompt" and your Airtable inputs. You can modify this prompt in the Make.com scenario to influence the style, complexity, or specific nature of the generated content.

To view and modify the prompt, double-click on the "Create a Chat Completion" OpenAI module in your Make.com scenario. The "System" message contains the core instructions given to the AI:

You are an entertainment expert.

Create a quiz video script on the given topic and difficulty.

* Include a list of short, challenging multiple-choice questions.
* DO NOT create more than 5 questions.
* Each question must have 4 short answer options (preferably one word each).
* Only one answer is correct.
* Keep the questions direct and concise (no more than 7 words per question).
* The quiz should be engaging for a broad audience.
* Topic, questions, answers and voiceovers must be in given language.
* If necessary, translate and improve the provided "intro_voiceover" and "like_and_subscribe_voiceover".

Return the output in this exact JSON format:

```json
{
    "topic": "Everyday science",
    "intro_voiceover": "",
    "like_and_subscribe_voiceover": "",
    "questions": [
        {
            "question": "What planet is known as the Red Planet?",
            "answer1": "Earth",
            "answer2": "Mars",
            "answer3": "Jupiter",
            "answer4": "Venus",
            "correct_answer": 2
        }
    ]
}
```

Only return the JSON. Do not add explanations or introductions.

By adjusting this prompt, you can fine-tune the AI's output, for example, by adding more specific instructions about the tone of the quiz, the length of answers, or even specific trivia categories to focus on.

Editing the movie template

For more profound changes to the video's layout, animations, or overall structure, you can duplicate and modify the underlying JSON2Video template. This requires a deeper understanding of the JSON2Video API documentation and its JSON syntax.

Follow these steps to customize the template:

  1. Open the provided quiz video movie template in the JSON2Video Visual Editor.
  2. From the top bar "Template" menu, click "Save template as..." This creates a editable copy in your account.
  3. Make your desired edits to the template. For instance, you could change element positions (x and y properties), adjust scene durations (duration property), or modify the layering of elements (z-index property).
  4. Once you've made your changes, get the new template ID by going to the "Template" menu and clicking "Show Template ID."
  5. In your Make.com scenario, double-click the "Create a Movie from a Template ID" JSON2Video module. Replace the original template ID (cSTYFRZhXeBZotbwcjuM) with your new custom template ID in the "Template ID" field.

Now, every time your Make.com scenario runs, it will use your customized video template.

Conclusion and next steps

Congratulations! You've successfully built an automated system to generate engaging quiz videos using Make.com, OpenAI, Airtable, and JSON2Video. You've learned how to:

This tutorial provides a solid foundation for your automated video creation journey. The possibilities are vast: you can expand this workflow to include more complex quiz types, integrate with other social media platforms for automated publishing, or even create entirely different video formats. Explore other tutorials and the JSON2Video documentation to continue enhancing your video automation skills!

Published on July 7th, 2025

Author
Joaquim Cardona
Joaquim Cardona Senior Internet business executive with more than 20 years of broad experience in Internet business, media sector, digital marketing, online video and mobile technologies.