{"product_id":"audit-saas-seats-in-google-sheets-openai-slack-approval","title":"Audit SaaS Seats in Google Sheets: OpenAI + Slack Approval","description":"\u003ch3\u003eAutomatically audit SaaS seats in Google Sheets—and use OpenAI + Slack approval to cancel unused users\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs weekly to check SaaS seat usage listed in your Google Sheets. It pulls recent activity from Google Workspace, Slack, Zoom, or a custom usage API, then uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to decide whether each seat is unused. Low-cost seats get cancelled automatically; high-cost seats go through \u003cstrong\u003eSlack approval\u003c\/strong\u003e—with every outcome logged back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e to keep seat audits consistent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your seat inventory\u003c\/strong\u003e from a Google Sheets spreadsheet’s \u003cstrong\u003e“Subscriptions”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses seats one by one\u003c\/strong\u003e and retrieves last-activity details from the appropriate usage endpoint (Google Workspace Admin API, Slack API, Zoom API, or a custom SaaS usage API).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes usage data\u003c\/strong\u003e into a consistent format for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI (gpt-4o-mini)\u003c\/strong\u003e to classify each seat as “unused” or “active,” including a recommended action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCancels unused low-cost seats immediately\u003c\/strong\u003e, while \u003cstrong\u003eunused high-cost seats are posted to Slack\u003c\/strong\u003e for approval before proceeding.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs decisions\u003c\/strong\u003e (kept, cancelled, rejected) to the Google Sheets \u003cstrong\u003e“Audit Log”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a completion summary to Slack\u003c\/strong\u003e and sends a Slack alert if the workflow errors.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eControl SaaS spend by identifying inactive seats across Google Workspace, Slack, and Zoom.\u003c\/li\u003e\n  \u003cli\u003eReduce compliance risk by maintaining an auditable record in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eIntroduce a human-in-the-loop approval step for high-cost seat cancellations via Slack.\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\/tools:\u003c\/strong\u003e if, code, wait, slack, switch, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, OpenAI (gpt-4o-mini), Slack, Google Workspace Admin API, Slack API, Zoom API, and a custom SaaS usage API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e Google Sheets OAuth2 credentials, OpenAI API credential, Slack OAuth2 credentials, and a spreadsheet with \u003cstrong\u003e“Subscriptions”\u003c\/strong\u003e and \u003cstrong\u003e“Audit Log”\u003c\/strong\u003e tabs\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938304778419,"sku":"N8N-18937","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xOXLNA9gHVA6xSYvY_qh6_HdFh3Rgi.png?v=1788341481","url":"https:\/\/buyflowscripts.com\/products\/audit-saas-seats-in-google-sheets-openai-slack-approval","provider":"N8N Commerce","version":"1.0","type":"link"}