{"name":"Filtrat — Clean Email List","nodes":[{"parameters":{"rule":{"interval":[{"field":"cronExpression","expression":"0 6 * * 1"}]}},"id":"schedule-trigger","name":"Weekly Monday 6 AM","type":"n8n-nodes-base.scheduleTrigger","typeVersion":1.2,"position":[240,300]},{"parameters":{"operation":"read","documentId":{"__rl":true,"mode":"id","value":""},"sheetName":{"__rl":true,"mode":"id","value":""}},"id":"read-sheet","name":"Read Email List","type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[460,300],"credentials":{"googleSheetsOAuth2Api":{"id":"","name":"Google Sheets"}}},{"parameters":{"method":"GET","url":"https://api.filtrat.io/v1/billing/status","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth"},"id":"check-balance","name":"Check Balance","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[680,300],"credentials":{"httpHeaderAuth":{"id":"","name":"Filtrat API"}}},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":""},"conditions":[{"leftValue":"={{ $json.total_balance }}","rightValue":"={{ $('Read Email List').all().length * 0.5 }}","operator":{"type":"number","operation":"gt"}}]}},"id":"enough-credits","name":"Enough Credits?","type":"n8n-nodes-base.if","typeVersion":2,"position":[900,300]},{"parameters":{"errorMessage":"={{ 'Insufficient Filtrat credits. Need ' + ($('Read Email List').all().length * 0.5) + ' credits but balance is ' + $json.total_balance + '. Top up at app.filtrat.io.' }}"},"id":"error-low-credits","name":"Error: Low Credits","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1120,420]},{"parameters":{"method":"POST","url":"https://api.filtrat.io/v1/bulk/jobs/from-list","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth","sendBody":true,"specifyBody":"json","jsonBody":"={{ JSON.stringify({ emails: $('Read Email List').all().map(i => i.json.email), file_name: 'n8n-weekly-clean' }) }}"},"id":"create-bulk-job","name":"Create Bulk Job","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1120,200],"credentials":{"httpHeaderAuth":{"id":"","name":"Filtrat API"}}},{"parameters":{"amount":30,"unit":"seconds"},"id":"wait-processing","name":"Wait 30s","type":"n8n-nodes-base.wait","typeVersion":1.1,"position":[1340,200]},{"parameters":{"method":"GET","url":"=https://api.filtrat.io/v1/bulk/jobs/{{ $('Create Bulk Job').item.json.job_id }}","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth"},"id":"check-status","name":"Check Job Status","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1560,200],"credentials":{"httpHeaderAuth":{"id":"","name":"Filtrat API"}}},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":""},"conditions":[{"leftValue":"={{ $json.status }}","rightValue":"completed","operator":{"type":"string","operation":"notEquals"}}]}},"id":"still-running","name":"Still Running?","type":"n8n-nodes-base.if","typeVersion":2,"position":[1780,200]},{"parameters":{"method":"GET","url":"=https://api.filtrat.io/v1/bulk/jobs/{{ $('Create Bulk Job').item.json.job_id }}/rows?status=verified&limit=1000","authentication":"genericCredentialType","genericAuthType":"httpHeaderAuth"},"id":"get-verified","name":"Get Verified Emails","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[2000,300],"credentials":{"httpHeaderAuth":{"id":"","name":"Filtrat API"}}},{"parameters":{"operation":"append","documentId":{"__rl":true,"mode":"id","value":""},"sheetName":{"__rl":true,"mode":"id","value":""},"columns":{"mappingMode":"autoMapInputData"}},"id":"write-results","name":"Write Clean List","type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[2220,300],"credentials":{"googleSheetsOAuth2Api":{"id":"","name":"Google Sheets"}}}],"connections":{"Weekly Monday 6 AM":{"main":[[{"node":"Read Email List","type":"main","index":0}]]},"Read Email List":{"main":[[{"node":"Check Balance","type":"main","index":0}]]},"Check Balance":{"main":[[{"node":"Enough Credits?","type":"main","index":0}]]},"Enough Credits?":{"main":[[{"node":"Create Bulk Job","type":"main","index":0}],[{"node":"Error: Low Credits","type":"main","index":0}]]},"Create Bulk Job":{"main":[[{"node":"Wait 30s","type":"main","index":0}]]},"Wait 30s":{"main":[[{"node":"Check Job Status","type":"main","index":0}]]},"Check Job Status":{"main":[[{"node":"Still Running?","type":"main","index":0}]]},"Still Running?":{"main":[[{"node":"Wait 30s","type":"main","index":0}],[{"node":"Get Verified Emails","type":"main","index":0}]]},"Get Verified Emails":{"main":[[{"node":"Write Clean List","type":"main","index":0}]]}},"settings":{"executionOrder":"v1"},"meta":{"templateId":"filtrat-bulk-clean","instanceId":""},"tags":[{"name":"filtrat"},{"name":"email-verification"},{"name":"list-cleaning"}]}