How to Build a Make Scenario That Turns Topics into Draft Scripts

Make (formerly Integromat) is a visual automation builder. This guide wires a scenario that reads pending topics from a Google Sheet, sends each to an AI module for a draft script, and writes the result back into the same row, so you manage your content pipeline from a spreadsheet.

What you need

• A Make account
• A Google Sheet with columns: Topic, Status, Script
• An OpenAI or Anthropic key connected in Make

Step 1: Add the Sheets search module

Create a scenario and add Google Sheets, Search Rows. Point it at your sheet and filter where Status equals pending. This pulls only the topics that still need a draft.

Step 2: Add the AI module

Add an OpenAI (or Anthropic) module set to create a chat completion. In the user message, reference the Topic field from the previous module using the mapping pill, and put your script structure instructions in the system message.

Write a 6 minute YouTube script for the given topic.
Sections in order: HOOK (2 lines), BODY (4 beats), CTA (1 line).
Spoken language, no camera directions. Return plain text only.

Step 3: Write the draft back

Add Google Sheets, Update a Row. Map the Script column to the AI module output and set Status to drafted. Now each processed topic is marked done and holds its script.

Result

Add a row, set Status to pending, and Make drafts a structured script into the Script column on its next run. Your whole script queue lives in one sheet.