Workflow: Googledrivetrigger Workflow
Integrations: googleDrive, googleDriveTrigger, if, merge, pipedrive, set, spreadsheetFile, stopAndError

{"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": {"97b052c3-2a98-4dee-973a-f170a5e575c8": {"main": [[{"node": "error-handler-97b052c3-2a98-4dee-973a-f170a5e575c8-c501de23", "type": "main", "index": 0}]]}, "1e82f8f8-175d-4493-a3a9-35380431d91c": {"main": [[{"node": "error-handler-1e82f8f8-175d-4493-a3a9-35380431d91c-794ba4d7", "type": "main", "index": 0}]]}, "fb36224d-4acb-4aba-9543-dd534e76477f": {"main": [[{"node": "error-handler-fb36224d-4acb-4aba-9543-dd534e76477f-386f5319", "type": "main", "index": 0}]]}}, "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}, "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Googledrivetrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}