Workflows / Reporting

Course Post-Mortem

Lessons from one cohort never shape the next.

When a cohort finishesGemini API keyGmailGoogle Sheets

How It Runs

TRIGGEREvery Monday At 9LOGICConfigSHEETRead SubscribersSHEETRead EventsLOGICCohort FactsGEMINIGeminiPost-MortemLOGICBuild EmailGMAILEmail ThePost-Mortem

Steps

  1. Every Monday At 9Trigger
  2. ConfigLogic
  3. Read SubscribersSheet
  4. Read EventsSheet
  5. Cohort FactsLogic
  6. Gemini Post-MortemGemini
  7. Build EmailLogic
  8. Email The Post-MortemGmail

Control Sheet Tabs

EventsSubscribers

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/19-course-post-mortem.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, when a cohort finishes
  3. To run it now, open the Run tab and tick Run now next to No. 19

Real Output

Output from Course Post-Mortem, page 1