This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "wf14b11b8faaa9",
"name": "Clockify to Syncro",
"nodes": [
{
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
280,
350
],
"parameters": {
"path": "your-webhook-path",
"options": {},
"httpMethod": "POST",
"responseData": "allEntries",
"responseMode": "lastNode"
},
"typeVersion": 1
},
{
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1830,
350
],
"parameters": {
"range": "A:B",
"options": {
"valueInputMode": "USER_ENTERED"
},
"sheetId": "xxx",
"operation": "append"
},
"credentials": {
"googleApi": "<your credential>"
},
"typeVersion": 1
},
{
"name": "ForGoogle",
"type": "n8n-nodes-base.set",
"position": [
1650,
350
],
"parameters": {
"values": {
"string": [
{
"name": "Syncro",
"value": "={{$json[\"id\"]}}"
},
{
"name": "Clockify",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"id\"]}}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"name": "ForSyncro",
"type": "n8n-nodes-base.set",
"position": [
730,
350
],
"parameters": {
"values": {
"string": [
{
"name": "id",
"value": "={{ $json[\"body\"][\"project\"][\"name\"].match(/\\[(\\d+)]/)[1] }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"name": "FindMatch",
"type": "n8n-nodes-base.googleSheets",
"position": [
1130,
350
],
"parameters": {
"range": "A:B",
"options": {
"valueRenderMode": "UNFORMATTED_VALUE",
"returnAllMatches": true
},
"sheetId": "xxx",
"operation": "lookup",
"lookupValue": "={{$(\"Webhook\").item.json[\"body\"][\"id\"]}}",
"lookupColumn": "=Clockify"
},
"credentials": {
"googleApi": "<your credential>"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"name": "IF",
"type": "n8n-nodes-base.if",
"position": [
1300,
350
],
"parameters": {
"conditions": {
"string": [],
"boolean": [
{
"value1": "={{!!Object.keys($(\"FindMatch\").item.json.data).length}}",
"value2": true
}
]
}
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"name": "NewSyncroTimer",
"type": "n8n-nodes-base.httpRequest",
"position": [
1490,
350
],
"parameters": {
"url": "={{$(\"EnvVariables\").item.json[\"syncro_baseurl\"]}}/api/v1/tickets/{{$(\"ForSyncro\").item.json[\"id\"]}}/timer_entry",
"options": {},
"requestMethod": "POST",
"authentication": "headerAuth",
"bodyParametersUi": {
"parameter": [
{
"name": "start_at",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"timeInterval\"][\"start\"]}}"
},
{
"name": "end_at",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"timeInterval\"][\"end\"]}}"
},
{
"name": "notes",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"description\"]}}"
},
{
"name": "user_id",
"value": "={{$(\"MatchTechnician\").item.json[\"id\"]}}"
}
]
}
},
"credentials": {
"httpHeaderAuth": "<your credential>"
},
"typeVersion": 1
},
{
"name": "UpdateSyncroTimer",
"type": "n8n-nodes-base.httpRequest",
"position": [
1490,
580
],
"parameters": {
"url": "={{$(\"EnvVariables\").item.json[\"syncro_baseurl\"]}}/api/v1/tickets/{{$(\"ForSyncro\").item.json[\"id\"]}}/update_timer_entry",
"options": {
"followRedirect": true
},
"requestMethod": "PUT",
"authentication": "headerAuth",
"bodyParametersUi": {
"parameter": [
{
"name": "timer_entry_id",
"value": "={{$(\"IF\").item.json[\"Syncro\"]}}"
},
{
"name": "start_time",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"timeInterval\"][\"start\"]}}"
},
{
"name": "end_time",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"timeInterval\"][\"end\"]}}"
},
{
"name": "notes",
"value": "={{$(\"Webhook\").item.json[\"body\"][\"description\"]}}"
},
{
"name": "user_id",
"value": "={{$(\"MatchTechnician\").item.json[\"id\"]}}"
}
]
}
},
"credentials": {
"httpHeaderAuth": "<your credential>"
},
"typeVersion": 1
},
{
"name": "EnvVariables",
"type": "n8n-nodes-base.set",
"position": [
580,
350
],
"parameters": {
"values": {
"string": [
{
"name": "syncro_baseurl",
"value": "https://subdomain.syncromsp.com"
}
]
},
"options": {}
},
"typeVersion": 1
},
{
"name": "SetTechnicians",
"type": "n8n-nodes-base.set",
"position": [
870,
350
],
"parameters": {
"values": {
"string": [
{
"name": "Tech 1",
"value": "1234"
},
{
"name": "Tech 2",
"value": "5678"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"name": "MatchTechnician",
"type": "n8n-nodes-base.code",
"position": [
1000,
350
],
"parameters": {
"jsCode": "\nconst results = [];\n\nconst user = $(\"Webhook\").item.json[\"body\"][\"user\"];\n\nconst persons = items[0].json\n\nfor (key of Object.keys(persons)) {\n if (key === user.name) {\n results.push({ json: { id: persons[key], name: key } })\n }\n}\n\nreturn results;"
},
"typeVersion": 2
},
{
"name": "IF1",
"type": "n8n-nodes-base.if",
"position": [
420,
350
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json[\"body\"][\"project\"][\"name\"]}}",
"value2": "Ticket",
"operation": "contains"
}
]
}
},
"typeVersion": 1
},
{
"name": "NoOp",
"type": "n8n-nodes-base.noOp",
"position": [
480,
520
],
"parameters": {},
"typeVersion": 1
}
],
"settings": {
"executionOrder": "v1"
},
"connections": {
"IF": {
"main": [
[
{
"node": "UpdateSyncroTimer",
"type": "main",
"index": 0
}
],
[
{
"node": "NewSyncroTimer",
"type": "main",
"index": 0
}
]
]
},
"IF1": {
"main": [
[
{
"node": "EnvVariables",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "IF1",
"type": "main",
"index": 0
}
]
]
},
"FindMatch": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
]
]
},
"ForGoogle": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"ForSyncro": {
"main": [
[
{
"node": "SetTechnicians",
"type": "main",
"index": 0
}
]
]
},
"EnvVariables": {
"main": [
[
{
"node": "ForSyncro",
"type": "main",
"index": 0
}
]
]
},
"NewSyncroTimer": {
"main": [
[
{
"node": "ForGoogle",
"type": "main",
"index": 0
}
]
]
},
"SetTechnicians": {
"main": [
[
{
"node": "MatchTechnician",
"type": "main",
"index": 0
}
]
]
},
"MatchTechnician": {
"main": [
[
{
"node": "FindMatch",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApihttpHeaderAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Clockify to Syncro. Uses googleSheets, httpRequest, stopAndError. Webhook trigger; 14 nodes.
Source: https://github.com/basictechorg/n8n-devops-security/blob/main/workflows/data-sync-backup/0935_HTTP_GoogleSheets_Sync_Webhook.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Dialpad to Syncro. Uses httpRequest, googleSheets, stopAndError. Webhook trigger; 23 nodes.
HTTP Request, Google Sheets, Stop And Error
BP_check. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 99 nodes.
Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
BP_check2. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 95 nodes.
Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
This solution enables you to manage all your Notion and Todoist tasks from different workspaces as well as your calendar events in a single place. This is 2 way sync with partial support for recurring
Redis, Notion, Todoist +6
Notion to Clockify Sync Template. Uses scheduleTrigger, clockify, compareDatasets, stopAndError. Webhook trigger; 68 nodes.
Clockify, Stop And Error, Notion +1