{"product_id":"n8n-workflow-revoke-public-google-drive-links-w-gmail-approval","title":"n8n Workflow: Revoke Public Google Drive Links w\/ Gmail Approval","description":"\u003ch3\u003eAutomatically revoke public Google Drive links—only after you approve via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Drive for files you own that are publicly accessible (“anyone with the link” \/ “anyone can find”), sends you a single Gmail approval request with an exposure report, and—if you approve—removes the public permission and logs every change to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns weekly\u003c\/b\u003e on a scheduled trigger every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFinds at-risk files in Google Drive\u003c\/b\u003e by querying the Google Drive API for non-trashed files you own that are visible to public access.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds a ranked exposure report\u003c\/b\u003e while reading an \u003cb\u003eAllowlist\u003c\/b\u003e from Google Sheets to exclude approved items from being considered for revocation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends one Gmail approval email\u003c\/b\u003e containing the report and then \u003cb\u003ewaits\u003c\/b\u003e for your approve\/reject response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRevokes public access on approval\u003c\/b\u003e by deleting each public \u003cb\u003e“anyone”\u003c\/b\u003e permission through the Google Drive API (if rejected, it makes no changes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAudits every attempted revocation\u003c\/b\u003e by appending a row per file to a Google Sheets \u003cb\u003eRevocations\u003c\/b\u003e tab, including timestamp, file details, and success\/failure result.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce unintended data exposure by systematically removing public links from Google Drive files.\u003c\/li\u003e\n  \u003cli\u003eMaintain governance for SaaS operations where shared documents should be permissioned—not public.\u003c\/li\u003e\n  \u003cli\u003eGive yourself a controlled “human-in-the-loop” approval step before permissions are changed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Drive API\u003c\/b\u003e (list files, identify public “anyone” access, delete public permissions)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (read \u003ccode\u003eAllowlist\u003c\/code\u003e, write audit rows to \u003ccode\u003eRevocations\u003c\/code\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e (send the approval request to your inbox and capture approve\/reject)\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/workflow components: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003esticky note\u003c\/b\u003e, \u003cb\u003ehttp request\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cp\u003eConnect OAuth2 credentials for Google Drive and Gmail, set your Gmail recipient address, and configure the Google Sheets document ID and the correct tab names (\u003ccode\u003eAllowlist\u003c\/code\u003e and \u003ccode\u003eRevocations\u003c\/code\u003e).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146301067443,"sku":"N8N-20255","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DfcWHQaH2mOwonjHdBx3R_3UUZTLRR.png?v=1790845833","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-revoke-public-google-drive-links-w-gmail-approval","provider":"N8N Commerce","version":"1.0","type":"link"}