{"product_id":"weekly-sales-summary-n8n-workflow-gmail-discord-airtable","title":"Weekly Sales Summary n8n Workflow: Gmail + Discord + Airtable","description":"\u003ch3\u003eGet a weekly sales digest automatically—built with Gmail, Discord, and Airtable\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eWeekly Sales Summary n8n Workflow\u003c\/strong\u003e pulls ERP-style order data via a webhook, merges it with \u003cstrong\u003eAirtable\u003c\/strong\u003e, calculates weekly booking totals, and then publishes reports through \u003cstrong\u003eDiscord\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e. It also supports manual runs for deeper regional reporting and Airtable enrichment—so you spend less time compiling numbers and more time acting on them.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled weekly run:\u003c\/strong\u003e Executes on a schedule and calls a custom \u003cstrong\u003eERP webhook\u003c\/strong\u003e using an HTTP header that includes your course unique ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrder filtering \u0026amp; aggregation:\u003c\/strong\u003e Filters returned orders by a specific status and employee name. Matching orders are prepared for \u003cstrong\u003eAirtable\u003c\/strong\u003e creation, while non-matching orders are aggregated into total \u003cem\u003ecount\u003c\/em\u003e and total \u003cem\u003evalue\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDiscord summary:\u003c\/strong\u003e Posts the aggregated weekly booking summary to a \u003cstrong\u003eDiscord channel\u003c\/strong\u003e using a Discord webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual reporting path:\u003c\/strong\u003e Pulls customer\/order records from Airtable, fetches additional ERP data, merges datasets, sorts by order price, and filters results to the \u003cstrong\u003eAmericas\u003c\/strong\u003e region.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail regional sales report:\u003c\/strong\u003e Converts each record into a JSON file and emails regional sales report files via \u003cstrong\u003eGmail\u003c\/strong\u003e, then confirms completion in \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNon-Americas handling:\u003c\/strong\u003e Loops through non-Americas records in batches, formats customer-since dates, generates group files, and posts file-creation notifications to \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCountry metadata enrichment:\u003c\/strong\u003e Fetches all countries from the \u003cstrong\u003eREST Countries API\u003c\/strong\u003e, matches country names to Airtable customer records, and upserts \u003cstrong\u003eregion\u003c\/strong\u003e and \u003cstrong\u003esubregion\u003c\/strong\u003e into Airtable.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly booking reporting for SaaS or internal sales teams with automated summaries in \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomated \u003cstrong\u003eGmail\u003c\/strong\u003e distribution of regional sales report attachments generated from merged ERP + Airtable data.\u003c\/li\u003e\n  \u003cli\u003eOngoing CRM data enrichment in \u003cstrong\u003eAirtable\u003c\/strong\u003e using \u003cstrong\u003eREST Countries\u003c\/strong\u003e region\/subregion fields.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e HTTP webhooks (ERP), \u003cstrong\u003eDiscord webhook\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eAirtable\u003c\/strong\u003e, \u003cstrong\u003eREST Countries API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes:\u003c\/strong\u003e if, set, code, sort, merge (and related control flow for filtering and batching).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Create an \u003cstrong\u003eHTTP Header Auth\u003c\/strong\u003e credential and set your course unique ID.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764325212339,"sku":"N8N-17852","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/l6OTddNOtT-d2jstSxkE6_NWE5fsAb.png?v=1786007381","url":"https:\/\/buyflowscripts.com\/products\/weekly-sales-summary-n8n-workflow-gmail-discord-airtable","provider":"N8N Commerce","version":"1.0","type":"link"}