Workflows / Email, From Sign-Up To Nurture

New Content Broadcast

New work never reaches the readers most likely to want it.

On new content, after approvalGemini API keyGoogle Sheets

How It Runs

TRIGGEREvery MorningLOGICConfigLOGICDetect NewRepositoryGEMINIDraft BroadcastLOGICQueue RowSHEETAdd To Queue

Steps

  1. Every MorningTrigger
  2. ConfigLogic
  3. Detect New RepositoryLogic
  4. Draft BroadcastGemini
  5. Queue RowLogic
  6. Add To QueueSheet

Control Sheet Tabs

Queue

Accounts To Connect

Gemini API keyGoogle Sheets

Run It Yourself

n8n

  1. In n8n, open Workflows, then Import from URL
  2. Paste https://raw.githubusercontent.com/archanacontent/content-marketing-automation-workflows/main/n8n/13-new-content-broadcast.json
  3. Fill in the Config node and connect the accounts listed above
  4. Activate the workflow

Google Apps Script

  1. Set up the control sheet with the steps on the main page
  2. Runs on its own: On new content
  3. To run it now, open the Run tab and tick Run now next to No. 13