Workflows / Content Operations

Claims Register And Annual Versioning

Dated facts get rechecked only when someone remembers, and a 2026 guide slides into 2027 unchanged.

Weekly, plus 1 JanuaryGemini API keyGmailGoogle Sheets

How It Runs

TRIGGEREvery MondayLOGICConfigSHEETRead ClaimsLOGICFind Due ClaimsGEMINIDraft AnnualBriefsLOGICBuild EmailGMAILEmail The List

Steps

  1. Every MondayTrigger
  2. ConfigLogic
  3. Read ClaimsSheet
  4. Find Due ClaimsLogic
  5. Draft Annual BriefsGemini
  6. Build EmailLogic
  7. Email The ListGmail

Control Sheet Tabs

Claims

Accounts To Connect

Gemini API keyGmailGoogle 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/02-claims-register-annual-versioning.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: Weekly, plus 1 January
  3. To run it now, open the Run tab and tick Run now next to No. 2