{"product_id":"weekly-task-report-automation-n8n-with-google-sheets-openai-slack","title":"Weekly Task Report Automation (n8n) with Google Sheets + OpenAI + Slack","description":"\u003ch3\u003eWeekly Task Report Automation for n8n: Google Sheets + OpenAI + Slack\u003c\/h3\u003e\n\u003cp\u003eGet an automatic weekly digest every Friday at 5:00 PM—this n8n workflow pulls last week’s task logs from Google Sheets, calculates weekly metrics, uses OpenAI to generate a polished HTML email report plus a Slack summary, and creates a Google Tasks follow-up when logged hours fall below a set threshold.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e A weekly schedule trigger fires every Friday at 5:00 PM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls your task data:\u003c\/strong\u003e Fetches task records from your selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet\/tab (expects columns like \u003cem\u003eDate\u003c\/em\u003e, \u003cem\u003eTask\u003c\/em\u003e, \u003cem\u003eCategory\u003c\/em\u003e, \u003cem\u003eHours\u003c\/em\u003e, \u003cem\u003eStatus\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters last week \u0026amp; cleans duplicates:\u003c\/strong\u003e Restricts records to last week’s date range, removes duplicate tasks (keeping the latest entry), and sorts by \u003cem\u003eCategory\u003c\/em\u003e and \u003cem\u003eHours\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates weekly metrics:\u003c\/strong\u003e Computes \u003cem\u003etotal hours\u003c\/em\u003e, \u003cem\u003ecompletion rate\u003c\/em\u003e, and a \u003cem\u003ecategory-by-category\u003c\/em\u003e hours breakdown from the filtered tasks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates report content with OpenAI:\u003c\/strong\u003e Sends metrics and the task list to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to receive a JSON response containing an \u003cem\u003eHTML email report\u003c\/em\u003e and a \u003cem\u003eshort Slack summary\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelivers via Gmail + Slack:\u003c\/strong\u003e Emails the HTML report using \u003cstrong\u003eGmail\u003c\/strong\u003e and posts the summary to a selected \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a workload follow-up:\u003c\/strong\u003e If total logged hours are below the configured threshold (default: \u003cstrong\u003e50\u003c\/strong\u003e), it creates a \u003cstrong\u003eGoogle Tasks\u003c\/strong\u003e “workload review” task.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and teams who track weekly work in Google Sheets and want automated reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need a reliable Google Sheets → OpenAI → Slack weekly workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eManagers who review under-logged weeks via an automatic Google Tasks reminder.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/steps:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Tasks\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e HTML email report + Slack summary generated by OpenAI, plus conditional Google Tasks creation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822087233715,"sku":"N8N-18097","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xDFJi3PTu5kswSztTbf-f_iuh224VB.png?v=1786525286","url":"https:\/\/buyflowscripts.com\/products\/weekly-task-report-automation-n8n-with-google-sheets-openai-slack","provider":"N8N Commerce","version":"1.0","type":"link"}