GM Monday morning brief (n8n recipe)

Outcome: One email with last week's key numbers, what changed, and the one thing to act on.

What you need

• Scheduled report emails from PMS/POS/labor systems (CSV or Excel)
• n8n
• LLM node
• Google Sheets for history

Steps

1. Email Trigger (IMAP): catch the scheduled report emails into a dedicated mailbox.
2. Extract From File node: parse the CSV/XLSX attachments.
3. Code node: compute week-over-week change for 5–8 KPIs (occupancy, ADR, RevPAR or covers, labor %, review score).
4. Google Sheets: append the week to a history tab.
5. LLM node: 'Write a 120-word brief: 3 biggest moves, likely causes based only on these numbers, one recommended action.'
6. Send Email node: to the GM at 7:00 AM Monday.

Check your company's data and AI policies before sending guest or vendor data to any third-party tool.