@jan @RicardoE105 I can transfer data to my mautic site like I want. I only have small problem with process with Google Sheet, I’ve extract process with Google Sheet below.
I’ve read thread @jan share above but still don’t know how to apply to Google Sheet, I’ve think about use SET to set a column value to 1 when update value with key is mobile.
Example Sheet here: https://docs.google.com/spreadsheets/d/1xk6QMx30xq9gKbnPOaa3uYQatve3sBPo405dQRmWvkM/edit#gid=319478530
And use this code
{ "name": "18. Google Sheet marks updated 1 ver 4", "nodes": [ { "parameters": {}, "name": "Start", "type": "n8n-nodes-base.start", "typeVersion": 1, "position": [ 140, 290 ] }, { "parameters": { "sheetId": "1xk6QMx30xq9gKbnPOaa3uYQatve3sBPo405dQRmWvkM", "range": "HNExtract!A:G", "options": {} }, "name": "GS Read Data", "type": "n8n-nodes-base.googleSheets", "typeVersion": 1, "position": [ 390, 290 ], "credentials": { "googleApi": "n8n API" } }, { "parameters": { "conditions": { "number": [], "string": [ { "value1": "={{$node[\"GS Read Data\"].json[\"updated\"]}}", "operation": "notEqual", "value2": "1" } ] } }, "name": "IF Updated not equal 1", "type": "n8n-nodes-base.if", "typeVersion": 1, "position": [ 650, 290 ] }, { "parameters": { "values": { "boolean": [], "string": [ { "name": "updated", "value": "1" } ], "number": [] }, "options": {} }, "name": "Set Updated 1", "type": "n8n-nodes-base.set", "typeVersion": 1, "position": [ 980, 270 ] }, { "parameters": { "operation": "update", "sheetId": "1xk6QMx30xq9gKbnPOaa3uYQatve3sBPo405dQRmWvkM", "range": "HNExtract!A:G", "key": "mobile", "options": {} }, "name": "GS Updated 1", "type": "n8n-nodes-base.googleSheets", "typeVersion": 1, "position": [ 1140, 210 ], "credentials": { "googleApi": "n8n API" } }, { "parameters": { "operation": "delete", "sheetId": "1xk6QMx30xq9gKbnPOaa3uYQatve3sBPo405dQRmWvkM", "toDelete": { "rows": [] } }, "name": "GS Delete", "type": "n8n-nodes-base.googleSheets", "typeVersion": 1, "position": [ 1140, 420 ], "credentials": { "googleApi": "n8n API" } } ], "connections": { "Start": { "main": [ [ { "node": "GS Read Data", "type": "main", "index": 0 } ] ] }, "GS Read Data": { "main": [ [ { "node": "IF Updated not equal 1", "type": "main", "index": 0 } ] ] }, "IF Updated not equal 1": { "main": [ [ { "node": "Set Updated 1", "type": "main", "index": 0 } ] ] }, "Set Updated 1": { "main": [ [ { "node": "GS Updated 1", "type": "main", "index": 0 }, { "node": "GS Delete", "type": "main", "index": 0 } ] ] } }, "active": false, "settings": {}, "id": "18" }
And my problem with duplicated data, Google Sheet update operation only update 1 for first data, second data is not. So I think about improve Delete operation here Improve Google Sheets node operation delete. Can you check this or has another solution for this? Thank you!