{"name":"Moving metrics from Google Sheets to Orbit","nodes":[{"id":"trigger-c3ff08d0","name":"Manual Trigger","type":"n8n-nodes-base.manualTrigger","typeVersion":1,"position":[100,100],"parameters":{}},{"name":"Merge","type":"n8n-nodes-base.merge","position":[1473,426],"parameters":{"mode":"mergeByKey","propertyName1":"GitHub Username","propertyName2":"attributes.slug"},"typeVersion":1,"id":"0198f23f-9a98-4c46-9497-887c7beeb55a","notes":"This merge node performs automated tasks as part of the workflow."},{"name":"Add Members","type":"n8n-nodes-base.orbit","position":[1073,326],"parameters":{"operation":"upsert","identityUi":{"identityValue":{"source":"github","searchBy":"username","username":"={{$json[\"GitHub\"]}}"}},"workspaceId":"543","additionalFields":{"name":"={{$json[\"Name\"]}}","tShirt":"={{$json[\"T-Shirt Size\"]}}","location":"={{$json[\"Location\"]}}","tagsToAdd":"={{$json[\"Tags\"]}}"}},"credentials":{"orbitApi":"Orbit Credentials"},"typeVersion":1,"id":"3a494ce0-bc49-4d29-9300-bbb754f7809b","notes":"This orbit node performs automated tasks as part of the workflow."},{"name":"Get all members","type":"n8n-nodes-base.orbit","position":[1273,526],"parameters":{"options":{},"operation":"getAll","returnAll":true,"workspaceId":"543"},"credentials":{"orbitApi":"Orbit Credentials"},"typeVersion":1,"id":"468fc5a0-3886-411f-8299-9bcaab8d0ee2","notes":"This orbit node performs automated tasks as part of the workflow."},{"name":"Get Members","type":"n8n-nodes-base.googleSheets","position":[873,326],"parameters":{"range":"Members!A:F","options":{},"sheetId":"1GiR5glinWBUJ-pw3w8LpcuwyOXst2z5nnFSak8DQrMQ","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"Google Sheets Credentials"},"typeVersion":1,"id":"939e3d97-fbb8-42ed-9737-7b7a7b740fb5","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Get Activities","type":"n8n-nodes-base.googleSheets","position":[1273,326],"parameters":{"range":"Activities!A:D","options":{"returnAllMatches":true},"sheetId":"={{$node[\"Get Members\"].parameter[\"sheetId\"]}}","operation":"lookup","lookupValue":"={{$node[\"Get Members\"].json[\"GitHub\"]}}","lookupColumn":"GitHub Username","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"Google Sheets Credentials"},"typeVersion":1,"id":"c36b6168-5d3a-40d5-963a-0009e6e37b96","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Add Activities","type":"n8n-nodes-base.orbit","position":[1673,426],"parameters":{"title":"={{$json[\"Title\"]}}","memberId":"={{$json[\"id\"]}}","resource":"activity","workspaceId":"543","additionalFields":{"link":"={{$json[\"Activity Link\"]}}","description":"={{$node[\"Merge\"].json[\"Description\"]}}"}},"credentials":{"orbitApi":"Orbit Credentials"},"typeVersion":1,"id":"9bca0a06-a20a-486d-8d03-1f727aede037","notes":"This orbit node performs automated tasks as part of the workflow."},{"id":"error-6f751cca","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"connections":{},"description":"Automated workflow: Moving metrics from Google Sheets to Orbit. This workflow processes data and performs automated tasks.","meta":{"instanceId":"workflow-5b9120e5","versionId":"1.0.0","createdAt":"2025-09-29T07:07:45.509402","updatedAt":"2025-09-29T07:07:45.509407","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Moving metrics from Google Sheets to Orbit. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}