Workflows / Reporting

Weekly Performance Report

Someone spends Monday morning copying numbers between tools.

Every MondayGemini API keyGmailGoogle AnalyticsGoogle Search ConsoleGoogle Sheets

How It Runs

TRIGGEREvery Monday At 8LOGICConfigAPIGA4 This WeekAPIGA4 Last WeekAPIGA4 SourcesAPISearch ConsoleSHEETRead SubscribersSHEETRead EnquiriesLOGICAssemble FactsGEMINIGemini NotesLOGICBuild ReportGMAILEmail The Report

Steps

  1. Every Monday At 8Trigger
  2. ConfigLogic
  3. GA4 This WeekAPI
  4. GA4 Last WeekAPI
  5. GA4 SourcesAPI
  6. Search ConsoleAPI
  7. Read SubscribersSheet
  8. Read EnquiriesSheet
  9. Assemble FactsLogic
  10. Gemini NotesGemini
  11. Build ReportLogic
  12. Email The ReportGmail

Control Sheet Tabs

EnquiriesSubscribers

Accounts To Connect

Gemini API keyGmailGoogle AnalyticsGoogle Search ConsoleGoogle 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/16-weekly-performance-report.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: Monday at 8:00
  3. To run it now, open the Run tab and tick Run now next to No. 16

Real Output

Output from Weekly Performance Report, page 1