{"meta":{"instanceId":"workflow-679d078b","versionId":"1.0.0","createdAt":"2025-09-29T07:07:51.311875","updatedAt":"2025-09-29T07:07:51.312322","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"nodes":[{"id":"97b052c3-2a98-4dee-973a-f170a5e575c8","name":"Google Drive Trigger","type":"n8n-nodes-base.googleDriveTrigger","position":[960,140],"parameters":{"event":"fileCreated","options":{},"pollTimes":{"item":[{"mode":"everyMinute"}]},"triggerOn":"specificFolder","folderToWatch":"1uQ0YnGnQNzIaWGdTt2UBT58tTy8xDlpW"},"credentials":{"googleDriveOAuth2Api":{"id":"{{ $credentials.googleDriveOAuth2Api.id }}","name":"Hilary's Google Drive account"}},"typeVersion":1,"notes":"This googleDriveTrigger node performs automated tasks as part of the workflow."},{"id":"1e82f8f8-175d-4493-a3a9-35380431d91c","name":"Google Drive","type":"n8n-nodes-base.googleDrive","position":[1180,140],"parameters":{"fileId":"={{ $json[\"id\"] }}","options":{},"operation":"download"},"credentials":{"googleDriveOAuth2Api":{"id":"{{ $credentials.googleDriveOAuth2Api.id }}","name":"Hilary's Google Drive account"}},"typeVersion":2,"notes":"This googleDrive node performs automated tasks as part of the workflow."},{"id":"fb36224d-4acb-4aba-9543-dd534e76477f","name":"Spreadsheet File","type":"n8n-nodes-base.spreadsheetFile","position":[1400,140],"parameters":{"options":{}},"typeVersion":1,"notes":"This spreadsheetFile node performs automated tasks as part of the workflow."},{"id":"323b2a18-fc98-4b73-9c7f-421780f04e94","name":"Pipedrive","type":"n8n-nodes-base.pipedrive","position":[1540,400],"parameters":{"filters":{},"resource":"lead","operation":"getAll","returnAll":true},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"executeOnce":true,"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"80d9733e-ccfb-4140-981f-8b818c4b9e70","name":"Pipedrive1","type":"n8n-nodes-base.pipedrive","position":[1920,380],"parameters":{"personId":"={{ $json[\"person_id\"] }}","resource":"person","operation":"get"},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"57197318-b0a9-4f15-9e10-f3750a60936c","name":"If Node","type":"n8n-nodes-base.if","position":[1720,400],"parameters":{"conditions":{"number":[{"value1":"={{ $json[\"person_id\"] }}","operation":"larger"}]}},"typeVersion":1,"notes":"This if node performs automated tasks as part of the workflow."},{"id":"e5592e1d-da1f-4536-b816-3a6df764cd0a","name":"Merge","type":"n8n-nodes-base.merge","position":[2140,100],"parameters":{"mode":"removeKeyMatches","propertyName1":"Email address","propertyName2":"email[0].value"},"typeVersion":1,"notes":"This merge node performs automated tasks as part of the workflow."},{"id":"29918402-d224-411d-b563-44d68c5b1c10","name":"Set","type":"n8n-nodes-base.set","position":[2360,100],"parameters":{"values":{"string":[{"name":"company","value":"={{ $json[\"Company name\"] }}"},{"name":"name","value":"={{ $json[\"First name\"] }} {{ $json[\"Last name\"] }}"},{"name":"email","value":"={{ $json[\"Email address\"] }}"},{"name":"employees","value":"={{ $json[\"Company size\"] }}"}]},"options":{},"keepOnlySet":true},"typeVersion":1,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"a3c83915-3b87-41ec-ba3b-5db1134b1763","name":"Create Organization","type":"n8n-nodes-base.pipedrive","position":[2840,100],"parameters":{"name":"={{ $json[\"company\"] }}","resource":"organization","additionalFields":{}},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"e8f0a561-cc7a-4302-83dc-8c4a407b9b53","name":"Create Person","type":"n8n-nodes-base.pipedrive","position":[3180,100],"parameters":{"name":"={{ $node[\"Set\"].json[\"name\"] }}","resource":"person","additionalFields":{"email":["={{ $node[\"Set\"].json[\"email\"] }}"],"org_id":"={{ $json[\"id\"] }}","customProperties":{"property":[{"name":"0bf0c49725830779ff146f5a087853d959dee064","value":"LinkedIn_Ad"}]}}},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"7c038ae1-030e-4047-b4af-d13333ed14af","name":"Create Lead","type":"n8n-nodes-base.pipedrive","position":[3380,100],"parameters":{"title":"={{$node[\"Set\"].json[\"company\"]}} lead","resource":"lead","organization_id":"={{$node[\"Create Organization\"].json.id}}","additionalFields":{"owner_id":12672788,"person_id":"={{$json.id}}"}},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"46a433d1-0248-4208-89d2-747644e1face","name":"Create Note","type":"n8n-nodes-base.pipedrive","position":[3580,100],"parameters":{"content":"=\nCompany Size:\n{{$node[\"Set\"].json[\"employees\"]}}","resource":"note","additionalFields":{"lead_id":"={{$json.id}}"}},"credentials":{"pipedriveApi":{"id":"{{ $credentials.pipedriveApi.id }}","name":"n8n Production"}},"typeVersion":1,"notes":"This pipedrive node performs automated tasks as part of the workflow."},{"id":"error-087ff515","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"connections":{"Google Drive Trigger":{"main":[[]]},"Google Drive":{"main":[[]]},"Spreadsheet File":{"main":[[]]}},"name":"Googledrivetrigger Workflow","description":"Automated workflow: Googledrivetrigger Workflow. This workflow processes data and performs automated tasks.","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"notes":"Excellent quality workflow: Googledrivetrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}