Audit workflow credential usage to Google Sheets using Google Drive and SQLite3
Ready for 3.0What this workflow does
This workflow has 28 nodes and runs on a schedule (every week at 14:00) (plus 1 other trigger). Along the way it connects Google Sheets and Google Drive.
How it runs
Trigger: On a schedule (every week at 14:00) (plus 1 other trigger).
- Create folder (Google Drive): work with folder
- Create credMap (Google Sheets): work with spreadsheet
- Create credInventory (Google Sheets): work with spreadsheet
- credsList (HTTP Request): calls an HTTP API
- flowsList (HTTP Request): calls an HTTP API
- splitCreds (Split Out): splits a list into separate items
- splitFlows (Split Out): splits a list into separate items
- Sort: sorts the items
- version_labels (Code): runs custom JavaScript code
- flow_names (Code): runs custom JavaScript code
…plus 16 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - Summarize
n8n-nodes-base.summarize - Track Time Saved
n8n-nodes-base.timeSaved - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Sort
n8n-nodes-base.sort - Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Workflow Introduction This workflow is specifically for Self-Hosted N8N Docker users. The purpose of this workflow is to: 1. Take an inventory of all workflows with credentials (Workflow -> Credential 1, Credential 2, etc.), connecting credential names to…