{"product_id":"nextcloud-user-onboarding-workflow-with-gmail-approvals","title":"Nextcloud User Onboarding Workflow with Gmail Approvals","description":"\u003ch3\u003eAutomatically onboard users to Nextcloud—using Gmail admin approvals\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures new Nextcloud account requests, checks PostgreSQL for duplicates, routes new users to \u003cstrong\u003eGmail-based admin approvals\u003c\/strong\u003e, and—once approved—provisions the account in \u003cstrong\u003eNextcloud\u003c\/strong\u003e while syncing status to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and storing records in \u003cstrong\u003ePostgreSQL\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects requests via an n8n form\u003c\/strong\u003e with the user’s full name and email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs “Pending Approval” in Google Sheets\u003c\/strong\u003e and checks the email against the \u003cstrong\u003ePostgreSQL\u003c\/strong\u003e database.\u003c\/li\u003e\n  \u003cli\u003eIf the email already exists, \u003cstrong\u003eemails the requester an “account already exists” notification\u003c\/strong\u003e via Gmail.\u003c\/li\u003e\n  \u003cli\u003eIf the user is new, sends an \u003cstrong\u003eapproval email to an admin\u003c\/strong\u003e using Gmail (send-and-wait), then branches based on the admin’s decision.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIf rejected:\u003c\/strong\u003e writes the rejection to the PostgreSQL \u003cstrong\u003eusers_rejected\u003c\/strong\u003e table and emails the requester a rejection notice via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIf approved:\u003c\/strong\u003e creates a storage directory via \u003cstrong\u003eSSH\u003c\/strong\u003e, generates a temporary password, saves the approved user to PostgreSQL, and updates the user’s status in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProvisions Nextcloud\u003c\/strong\u003e via the Nextcloud \u003cstrong\u003eOCS API\u003c\/strong\u003e, generates a \u003cstrong\u003eQR code\u003c\/strong\u003e for the Nextcloud mobile login deep link, and \u003cstrong\u003eemails credentials with the QR image attached\u003c\/strong\u003e via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating internal onboarding for SaaS operators who manage user access to Nextcloud.\u003c\/li\u003e\n  \u003cli\u003eHandling account requests with an auditable “Pending Approval” trail in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eReducing manual admin work by using Gmail approval\/rejection decisions to control Nextcloud provisioning.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e if, ssh, code, gmail, postgres, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData sync:\u003c\/strong\u003e Google Sheets for request\/status logging; PostgreSQL for approved\/rejected user records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProvisioning:\u003c\/strong\u003e Nextcloud via OCS API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e Gmail OAuth2 with send-and-wait approval flow and credential delivery (QR attachment).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Configure PostgreSQL, Google Sheets OAuth2, Gmail OAuth2, Nextcloud API, and password-based SSH, then provide your spreadsheet ID.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872834838707,"sku":"N8N-18457","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MP4L3gFMmrLzrxygeyKge_bmphXkAn.png?v=1787217487","url":"https:\/\/buyflowscripts.com\/products\/nextcloud-user-onboarding-workflow-with-gmail-approvals","provider":"N8N Commerce","version":"1.0","type":"link"}