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

Chain a Make scenario from a Google Sheet of topics to an AI module to a draft saved back in the sheet, no code required.

9 minIntermediate

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.

Make — Scenario canvas

[ Sheets: Search Rows ] -> [ OpenAI: Message ] -> [ Sheets: Update Row ]

filter: Status = pending

prompt uses {{1.Topic}}

Script = {{2.result}}

Three modules wired left to right form the whole pipeline.

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.

system prompt (paste into the AI module)

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.

Google Sheets — content pipeline

Topic | Status | Script

------------------------------+----------+--------------

How tipping works in the US | drafted | HOOK You have...

Why coffee prices keep rising | pending |

The scenario fills the Script column and flips Status.

Schedule it

Set the scenario to run on a schedule (say every morning) so any topic you add overnight has a draft waiting when you sit down.

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.