{ "edges": [ { "to": "n-config", "from": "n-trigger", "toPort": "0", "fromPort": "0" }, { "to": "n-getcreds", "from": "n-config", "toPort": "0", "fromPort": "0" }, { "to": "n-email", "from": "n-format", "toPort": "0", "fromPort": "0" }, { "to": "n-research", "from": "n-claude-model", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "n-extract", "from": "n-getcreds", "toPort": "0", "fromPort": "0" }, { "to": "n-research", "from": "n-extract", "toPort": "0", "fromPort": "0" }, { "to": "n-format", "from": "n-research", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "n-trigger", "name": "Run Audit", "type": "manualTrigger", "params": {}, "position": [ 0, 304 ] }, { "id": "n-config", "name": "Configuration", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "c1", "name": "n8nInstanceUrl", "type": "string", "value": "https://YOUR-INSTANCE.app.n8n.cloud" }, { "id": "c2", "name": "notificationEmail", "type": "string", "value": "your@email.com" } ] } }, "position": [ 240, 304 ] }, { "id": "n-getcreds", "name": "Get n8n Credentials", "type": "http", "params": { "url": "={{ $('Configuration').first().json.n8nInstanceUrl + '/api/v1/credentials?limit=250' }}", "options": {}, "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth" }, "position": [ 480, 304 ] }, { "id": "n-extract", "name": "Extract Service Names", "type": "code", "params": { "jsCode": "const body = $input.first().json;\nconst creds = body.data || (Array.isArray(body) ? body : []);\n\nconst typeToService = {\n openAiApi: 'OpenAI', anthropicApi: 'Anthropic (Claude AI)',\n googleDriveOAuth2Api: 'Google Drive', gmailOAuth2: 'Gmail',\n googleSheetsOAuth2Api: 'Google Sheets', googleCalendarOAuth2Api: 'Google Calendar',\n googleDocsOAuth2Api: 'Google Docs', youtubeOAuth2Api: 'YouTube Data API',\n slackApi: 'Slack', slackOAuth2Api: 'Slack', telegramApi: 'Telegram Bot API',\n notionApi: 'Notion', airtableTokenApi: 'Airtable', airtableApi: 'Airtable',\n githubApi: 'GitHub', gitlabApi: 'GitLab', hubspotApi: 'HubSpot',\n salesforceOAuth2Api: 'Salesforce', stripeApi: 'Stripe', twilioApi: 'Twilio',\n sendGridApi: 'SendGrid', mailchimpApi: 'Mailchimp', shopifyApi: 'Shopify',\n dropboxApi: 'Dropbox', oneDriveApi: 'Microsoft OneDrive',\n microsoftTeamsOAuth2Api: 'Microsoft Teams', outlookOAuth2Api: 'Microsoft Outlook',\n linkedInOAuth2Api: 'LinkedIn', twitterOAuth2Api: 'Twitter / X',\n facebookGraphApi: 'Facebook Graph API', wordpressApi: 'WordPress REST API',\n asanaApi: 'Asana', trelloApi: 'Trello', jiraApi: 'Jira (Atlassian)',\n linearApi: 'Linear', clickupApi: 'ClickUp', mondayApi: 'Monday.com',\n pipedriveApi: 'Pipedrive', zendeskApi: 'Zendesk', discordApi: 'Discord',\n discordBotApi: 'Discord Bot', postgresDb: 'PostgreSQL', mysqlDb: 'MySQL',\n mongoDb: 'MongoDB', supabaseApi: 'Supabase', pineconeApi: 'Pinecone',\n httpHeaderAuth: null, httpBasicAuth: null, httpQueryAuth: null,\n httpDigestAuth: null, oAuth2Api: null, oAuth1Api: null,\n sshPrivateKey: null, noAuth: null,\n};\n\nconst seen = new Set();\nconst services = [];\nfor (const cred of creds) {\n const mapped = typeToService[cred.type];\n if (mapped === null) continue;\n const name = mapped || cred.type.replace(/([A-Z])/g, ' $1').replace('Api', ' API').trim();\n if (!seen.has(name)) { seen.add(name); services.push({ name, type: cred.type }); }\n}\n\nreturn [{ json: { services, serviceList: services.map(s => s.name).join(', '), totalCreds: creds.length, uniqueServices: services.length } }];" }, "position": [ 720, 304 ] }, { "id": "n-research", "name": "Research Pricing with Claude", "type": "llm", "params": { "text": "=Analyze these {{ $json.uniqueServices }} services and return their API pricing, free tiers, and rate limits.\n\nServices: {{ $json.serviceList }}\n\nReturn ONLY a valid JSON array, no markdown, no explanation:\n[\n {\n \"service\": \"service name\",\n \"category\": \"AI | Storage | Communication | CRM | Productivity | Social | Database | Payment | Other\",\n \"tier\": \"free | freemium | paid\",\n \"hasFree\": true or false,\n \"freeLimits\": \"specific quota e.g. 10K chars/month\",\n \"paidFrom\": \"lowest price e.g. $10/month\",\n \"rateLimit\": \"e.g. 60 RPM or No published limit\",\n \"notes\": \"1-2 sentences on key restrictions\"\n }\n]", "prompt": "=Analyze these {{ $json.uniqueServices }} services and return their API pricing, free tiers, and rate limits.\n\nServices: {{ $json.serviceList }}\n\nReturn ONLY a valid JSON array, no markdown, no explanation:\n[\n {\n \"service\": \"service name\",\n \"category\": \"AI | Storage | Communication | CRM | Productivity | Social | Database | Payment | Other\",\n \"tier\": \"free | freemium | paid\",\n \"hasFree\": true or false,\n \"freeLimits\": \"specific quota e.g. 10K chars/month\",\n \"paidFrom\": \"lowest price e.g. $10/month\",\n \"rateLimit\": \"e.g. 60 RPM or No published limit\",\n \"notes\": \"1-2 sentences on key restrictions\"\n }\n]", "batching": {}, "messages": { "messageValues": [ { "message": "You are an API pricing expert. Return accurate, specific pricing and rate limit data. Return only the JSON array." } ] }, "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 960, 304 ] }, { "id": "n-claude-model", "name": "Claude Sonnet 4.5", "type": "llm", "params": { "model": "claude-sonnet-4-5-20250929", "options": {}, "provider": "anthropic" }, "position": [ 960, 528 ] }, { "id": "n-format", "name": "Build HTML Report", "type": "code", "params": { "jsCode": "const rawText = $input.first().json.text || '';\nconst meta = $('Extract Service Names').first().json;\n\nlet integrations = [];\ntry {\n const cleaned = rawText.replace(/```json\\n?/g,'').replace(/```\\n?/g,'').trim();\n integrations = JSON.parse(cleaned);\n} catch(e) {\n integrations = [{ service:'Parse Error', category:'Error', tier:'freemium', hasFree:false, freeLimits:'Could not parse response', paidFrom:'N/A', rateLimit:'N/A', notes: rawText.substring(0,300) }];\n}\n\nconst tierOrder = { free:0, freemium:1, paid:2 };\nintegrations.sort((a,b) => {\n const ta = tierOrder[a.tier]??1, tb = tierOrder[b.tier]??1;\n return ta!==tb ? ta-tb : a.service.localeCompare(b.service);\n});\n\nconst tierColor={free:'#16a34a',freemium:'#b45309',paid:'#dc2626'};\nconst tierBg={free:'#dcfce7',freemium:'#fef3c7',paid:'#fee2e2'};\nconst tierIcon={free:'🟢',freemium:'🟡',paid:'🔴'};\n\nconst rows = integrations.map((item,i) => {\n const t = item.tier||'freemium';\n const bg = i%2===0?'#ffffff':'#f9fafb';\n return `\n ${item.service}\n ${item.category||''}\n ${tierIcon[t]} ${t.charAt(0).toUpperCase()+t.slice(1)}\n ${item.freeLimits||(item.hasFree?'Yes':'❌ None')}\n ${item.paidFrom||'N/A'}\n ${item.rateLimit||'N/A'}\n ${item.notes||''}\n `;\n}).join('');\n\nconst date = new Date().toLocaleDateString('en-US',{year:'numeric',month:'long',day:'numeric'});\nconst freeCount=integrations.filter(i=>i.tier==='free').length;\nconst freemiumCount=integrations.filter(i=>i.tier==='freemium').length;\nconst paidCount=integrations.filter(i=>i.tier==='paid').length;\n\nconst html=`

🔌 n8n Integration Audit Report

Generated: ${date} · ${meta.totalCreds} credentials · ${integrations.length} services analysed

🟢 Free: ${freeCount}

🟡 Freemium: ${freemiumCount}

🔴 Paid only: ${paidCount}

\n \n \n \n \n \n \n \n ${rows}\n

Service	Category	Tier	Free Limits	Paid From	Rate Limits	Notes

⚠️ Pricing researched by Claude AI — verify with official docs.

`;\n\nreturn [{ json:{ html, totalCount:integrations.length, freeCount, freemiumCount, paidCount, date } }];" }, "position": [ 1200, 304 ] }, { "id": "n-email", "name": "Email Audit Report", "type": "integration", "params": { "sendTo": "={{ $('Configuration').first().json.notificationEmail }}", "message": "={{ $json.html }}", "options": { "appendAttribution": false }, "service": "gmail", "subject": "={{ '🔌 Integration Audit: ' + $json.totalCount + ' services | 🟢 ' + $json.freeCount + ' Free | 🟡 ' + $json.freemiumCount + ' Freemium | 🔴 ' + $json.paidCount + ' Paid' }}", "operation": "read" }, "position": [ 1440, 304 ] } ] }

Audit connected integrations and email pricing & limits report with n8n API, Claude and Gmail