n8n Workflow: Weekly Google Sheets Seller Report via Gmail

Get a Weekly Google Sheets Seller Report Automatically—Sent via Gmail Every Monday

This n8n workflow generates a personalized weekly activity summary for each seller from your Google Sheets and emails it automatically using Gmail—running every Monday at 8:00am. It also updates your sheet with the latest report timestamp for each reported listing.

What this workflow does

• Runs on a schedule: Executes every Monday at 8am using an n8n schedule trigger.
• Reads seller activity from Google Sheets: Pulls data from the Listings, Leads, and Viewings tabs within a single Google Sheets document.
• Groups by seller email: Active listings are grouped using Seller Email and analyzed per seller for the selected reporting window.
• Calculates weekly + total performance: Computes weekly and total enquiries, viewings, upcoming viewings, average feedback rating, days on market, and recent viewer comments.
• Creates one HTML email per seller: Builds a tailored HTML report and prepares a subject line for the chosen reporting period.
• Sends via Gmail: Sends each seller their report via Gmail, BCC’ing the agent email and using the agency name as the sender name.
• Updates “Last Report Sent At”: Writes the current timestamp back to Google Sheets for each listing in the Last Report Sent At column.

Use cases

• Automate weekly seller updates for property teams without manual reporting.
• Provide consistent performance summaries (enquiries, viewings, feedback) per seller.
• Use Gmail to deliver branded HTML reports while keeping your Google Sheets current.

Technical details

• n8n nodes: set, code, gmail, sticky note, google sheets, schedule trigger
• Integrations: Google Sheets (Listings/Leads/Viewings tabs) + Gmail (email delivery)
• Setup highlights: Configure Google Sheet ID, agency/agent details, timezone, currency symbol, reportDays, reportStatuses, and staleAfterDays; ensure required columns like Seller Email, Listing Ref, Status, Listed At, and Last Report Sent At exist.