Daily pickup and pace email for revenue managers (n8n recipe)

Outcome: Every morning the revenue manager and GM get a five-line summary of overnight pickup for the next 90 days, with the dates that need a pricing look flagged.

What you need

• A scheduled on-the-books report from your PMS or RMS (CSV by email), by stay date: rooms sold and room revenue
• Google Sheets to store a daily snapshot
• n8n (cloud or self-hosted)
• An LLM node (e.g., OpenAI or Anthropic credentials)
• Email or Slack

Steps

1. Email Trigger (IMAP) node: catch the daily on-the-books report email from your PMS or RMS, sent at the same hour every day.
2. Extract From File node: parse the CSV attachment into rows (stay date, rooms sold, revenue).
3. Google Sheets node: read yesterday's snapshot; Code node: for each stay date in the next 90 days, calculate rooms picked up, revenue change and ADR change.
4. IF node: flag stay dates where pickup is above your threshold (e.g., 10+ rooms overnight) or where rooms sold fell (cancellations).
5. LLM node: write five bullet points: total pickup, the top flagged dates with numbers, cancellations, and one 'look at this' note. It summarizes only and never recommends a rate.
6. Email/Slack node: send by 7:00 AM; Google Sheets node: save today's snapshot for tomorrow's comparison.

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

Frequently asked questions