← AIAP Tool GuidesAll programsHomeSearch
AIAP Tool Guides·AI for Marketing·24:39

An n8n Content-Repurposing Workflow: Google Sheet Paragraph to Tweet, LinkedIn Post and Shorts Script

Karan Rana Brand/marketing manager, YouTuber, podcaster and course creator ("a non-tech guy"); presents the AI for Marketing, NotebookLM and Manus tool guides

The short version

  1. Five nodes: manual trigger -> Google Sheets get row -> OpenAI "message a model" -> Edit Fields -> Google Sheets append row (0:00-0:04).
  2. Node window anatomy (input, configuration, output; table or JSON), manual versus schedule triggers, credentials as passports (0:04-0:08).
  3. The prompt turns one paragraph into a 280-character tweet, a 300-character LinkedIn post and a 100-word Shorts script; the run takes about two seconds (0:14-0:22).

At a glance, three clicks deep

Skim here first: the closed row is the glance, open is the study card with the key points and timestamps, and the ↓ link drops to that concept's full write-up below.

01Building the five-node repurposing chainA trigger starts the run;›

A trigger starts the run; each node's output feeds the next; credentials connect Google and OpenAI.

Anatomy (0:02-0:08)

Sheets node (0:08-0:12)

OpenAI node and prompt (0:12-0:17)

Mapping and run (0:17-0:22)

↓ Full write-up of this concept

The concepts in full

01

Building the five-node repurposing chain

how-to

Paste a paragraph in A2, hit Execute workflow, and three formats appear in the sheet.

Sheet "repurpose social posts" has columns paragraph, tweet, linkedin, shots. Get row(s): resource sheet, operation get rows, document and tab from list, "return only first matching row". OpenAI: resource text, operation "message a model" (he used gpt-3.5-turbo), prompt "take the following paragraph and repurpose it into 1. a tweet, maximum 280 characters, 2. a LinkedIn post, max 300 characters in a friendly tone, and 3. a YouTube short script, maximum 100 words" plus an expression inserting the paragraph cell. Edit Fields: manual mapping of three string fields by expression (the split expression is never read out). Append row maps each field to its column.

Do it in this order
Why it matters

A template for any one-to-many content workflow.

Tools referenced

ToolCoverageMomentContext
n8ndemonstrated
Google Sheetsdemonstrated
OpenAI APIdemonstrated
X (Twitter)mentioned

Action items

    Resources mentioned

    Resources
    • docLesson page on the platform

    Extraction notes

    This page was built from an auto-generated transcript, which garbles product and people's names. Those were corrected silently in everything above and logged here for transparency. The warnings flag claims that were true on the recording day but change fast.

    Transcript corrections applied

    The transcript saysThe trainer actually means
    NA10 / any 10 / NATMn8n
    shots / shopsShorts
    set or a split nodeSet / Edit Fields node

    True on recording day — verify before relying