{"product_id":"n8n-workflow-weekly-google-sheets-seller-report-via-gmail","title":"n8n Workflow: Weekly Google Sheets Seller Report via Gmail","description":"\u003ch3\u003eGet a Weekly Google Sheets Seller Report Automatically—Sent via Gmail Every Monday\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e generates a personalized weekly activity summary for each seller from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and emails it automatically using \u003cstrong\u003eGmail\u003c\/strong\u003e—running every Monday at \u003cstrong\u003e8:00am\u003c\/strong\u003e. It also updates your sheet with the latest report timestamp for each reported listing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every Monday at 8am using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads seller activity from Google Sheets:\u003c\/strong\u003e Pulls data from the \u003cstrong\u003eListings\u003c\/strong\u003e, \u003cstrong\u003eLeads\u003c\/strong\u003e, and \u003cstrong\u003eViewings\u003c\/strong\u003e tabs within a single Google Sheets document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups by seller email:\u003c\/strong\u003e Active listings are grouped using \u003cstrong\u003eSeller Email\u003c\/strong\u003e and analyzed per seller for the selected reporting window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates weekly + total performance:\u003c\/strong\u003e Computes weekly and total enquiries, viewings, upcoming viewings, average feedback rating, days on market, and recent viewer comments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates one HTML email per seller:\u003c\/strong\u003e Builds a tailored HTML report and prepares a subject line for the chosen reporting period.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e Sends each seller their report via Gmail, \u003cstrong\u003eBCC’ing the agent email\u003c\/strong\u003e and using the \u003cstrong\u003eagency name\u003c\/strong\u003e as the sender name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates “Last Report Sent At”:\u003c\/strong\u003e Writes the current timestamp back to Google Sheets for each listing in the \u003cstrong\u003eLast Report Sent At\u003c\/strong\u003e column.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate weekly seller updates for property teams without manual reporting.\u003c\/li\u003e\n  \u003cli\u003eProvide consistent performance summaries (enquiries, viewings, feedback) per seller.\u003c\/li\u003e\n  \u003cli\u003eUse Gmail to deliver branded HTML reports while keeping your Google Sheets current.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, code, gmail, sticky note, google sheets, schedule trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (Listings\/Leads\/Viewings tabs) + Gmail (email delivery)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e Configure Google Sheet ID, agency\/agent details, timezone, currency symbol, reportDays, reportStatuses, and staleAfterDays; ensure required columns like \u003cem\u003eSeller Email\u003c\/em\u003e, \u003cem\u003eListing Ref\u003c\/em\u003e, \u003cem\u003eStatus\u003c\/em\u003e, \u003cem\u003eListed At\u003c\/em\u003e, and \u003cem\u003eLast Report Sent At\u003c\/em\u003e exist.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190248624307,"sku":"N8N-20542","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/R1KfxwYiKe_dd8sYgwMKh_R4moXOpi.png?v=1791451325","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-weekly-google-sheets-seller-report-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}