n8n

How to Automate Gmail Daily Inbox Reporting?

Start your day with one clear email that sums up everything that reached your inbox in the last 24 hours. Great for managers and teams who want quick updates without digging through threads.

At 7 AM on a schedule, the flow pulls recent messages from Gmail with a dynamic date filter. Key details are organized into a simple list, including sender, recipients, cc, and a short preview. OpenAI reads that list and returns a clean JSON summary with highlights, issues to watch, and action items. A styled HTML report is then sent from Gmail, with a subject that shows yesterday’s date range so your team knows exactly what the report covers.

You only need a Gmail account and an OpenAI API key. Set the recipients, cc list, and adjust the Gmail search query to match your inbox rules. Most teams cut morning email review from about an hour to just a few minutes and miss fewer urgent threads. This is helpful for shared inboxes, support queues, project updates, and daily standups. Once active, it runs on its own every morning and keeps everyone aligned with the same view.

What are the key features?

  • Scheduled run at 7 AM to deliver a consistent daily digest
  • Gmail fetch uses a dynamic after date filter to grab the last 24 hours
  • Aggregate step extracts sender, recipients, cc, and a short snippet
  • OpenAI summarizes emails into JSON with summary, key issues, and action items
  • HTML email report is sent from Gmail with a clear date range in the subject
  • Configurable recipients and cc list for team wide delivery

What are the benefits?

  • Reduce daily email review from about 60 minutes to under 5 minutes
  • Automate up to 90 percent of morning inbox triage
  • Cut missed important emails by up to 80 percent through one daily summary
  • Connect Gmail and OpenAI so your team sees a single clear report
  • Create a repeatable record of issues and actions for audit and follow up

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n, click the three dots menu, select 'Import from File', then choose the downloaded JSON file
  2. You'll need accounts with Gmail and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. Open the Schedule Trigger and set the time to 7 AM in your preferred timezone. If your n8n is in a different timezone, adjust the hour to match your local morning time.
  4. Double click the Gmail node that fetches emails. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to connect your Google account with OAuth2.
  5. In the same Gmail fetch node, review the search query q. Keep the dynamic date code for after and update any hardcoded email or label to match your inbox. Optionally add is:unread or label filters.
  6. Open the Aggregate node and confirm the included fields are id, From, To, CC, and snippet. Leave the aggregate setting to gather all items.
  7. Double click the OpenAI node. In the Credential dropdown, click Create new credential, paste your OpenAI API key from your OpenAI account, and select a supported model such as gpt 4o mini.
  8. Review the OpenAI prompt text and adjust the tone or output keys if your team needs a different summary style.
  9. Open the Gmail send node. Set the To address and cc list, then review the subject and HTML body. Replace any placeholder addresses with your team emails.
  10. Click Execute Workflow to run a test. Confirm that messages are fetched, summarized, and that a test email arrives in your inbox with the correct date and content.
  11. If everything looks good, click Activate in n8n so the schedule runs every morning.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.