Simple Email Analyzer – Count Unique Senders from Gmail and Log to Google Sheets

Hi everyone,

I’m sharing a simple yet powerful workflow that automatically analyzes incoming emails in your Gmail inbox and logs how many times each unique sender has contacted you.

Workflow Description:

  • Trigger: Runs every hour (or as you define)
  • Gmail Node: Retrieves all received messages
  • Code Node: Extracts sender email and counts occurrences
  • Google Sheets Node: Appends the results to your selected sheet

Output Example:

Use Cases:

  • Monitor customer or vendor email frequency
  • Detect spam or high-volume senders
  • Analyze your email workload by sender

Download & Setup:
I’ve attached the cleaned JSON file and full README (in English & Arabic) in the ZIP file below.

Important: You’ll need to replace the credentials and Google Sheet ID before use.

Hope this helps someone!
Feedback welcome.