{"product_id":"n8n-jira-worklog-billing-utilization-reports-to-google-sheets","title":"n8n Jira Worklog Billing \u0026 Utilization Reports to Google Sheets","description":"\u003ch3\u003eTurn Jira worklogs into billing-ready Google Sheets reports—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls Jira worklogs for a selected project and date range, calculates per-person utilization and estimated billing totals, and writes both the detailed worklog list and a monthly summary into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. Perfect if you need clear capacity reporting without manual spreadsheet work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually starts\u003c\/strong\u003e from n8n when you run it.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eJira Project Tasks\u003c\/strong\u003e to fetch tasks from a specified \u003cstrong\u003eJira project\u003c\/strong\u003e within your configured \u003cstrong\u003estart and end dates\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGenerates a \u003cstrong\u003eworklog report\u003c\/strong\u003e from the returned issues and outputs individual \u003cstrong\u003eworklog entries\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates worklogs by person\u003c\/strong\u003e to calculate:\n    \u003cul\u003e\n      \u003cli\u003eTotal hours and issue counts\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eUtilization percentage\u003c\/strong\u003e using a standard monthly capacity\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eEstimated cost\u003c\/strong\u003e using per-person hourly billing rates (including a \u003cstrong\u003eDEFAULT\u003c\/strong\u003e rate)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends raw worklogs\u003c\/strong\u003e to the \u003cstrong\u003e“List”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates\u003c\/strong\u003e monthly per-person summary rows in the \u003cstrong\u003e“Summary”\u003c\/strong\u003e tab, matched by \u003cstrong\u003eMonth\u003c\/strong\u003e and \u003cstrong\u003ePerson\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperations and SaaS teams tracking \u003cstrong\u003eteam capacity utilization\u003c\/strong\u003e from Jira.\u003c\/li\u003e\n  \u003cli\u003eFinance\/PMs estimating \u003cstrong\u003ebilling totals\u003c\/strong\u003e based on worklog hours and hourly rates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a repeatable \u003cstrong\u003eJira → Google Sheets\u003c\/strong\u003e reporting workflow for monthly reviews.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual Trigger\u003c\/strong\u003e in n8n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eJira integration\u003c\/strong\u003e via \u003cem\u003en8n-nodes-jira-project-tasks\u003c\/em\u003e (Jira Project Tasks)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e using OAuth2 to write to “List” and “Summary” tabs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode step configuration\u003c\/strong\u003e to set standard monthly capacity hours and per-person hourly rates (including a DEFAULT rate) so names align with Jira worklog author\/assignee fields\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eGet accurate utilization and billing estimates\u003c\/strong\u003e in Google Sheets directly from Jira worklogs—run it on demand in n8n and keep your reporting consistent month after month.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761010204851,"sku":"N8N-17819","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dtv2TFB731LgedeexySXS_pAie6hlt.png?v=1785921233","url":"https:\/\/buyflowscripts.com\/products\/n8n-jira-worklog-billing-utilization-reports-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}