⚡ Only 300 spots remaining • Closes in 2d 14h 32m
⚡ Only 300 spots remaining • Closes in 2d 14h 32m
Ensure developer data privacy. This workflow queries production databases, executes local Javascript code to strip and anonymize Personally Identifiable Information (PII) such as email, phone numbers, and names, and loads clean records into dev staging.
This workflow is pre-configured and ready for deployment. Simply import the JSON template into your n8n instance and configure your credentials.
This is an exclusive blueprint. Copy the JSON below to use it.
PRO TIP
Always test your workflow in a development environment before pushing to production.
{
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "days",
"value": 7
}
]
}
},
"name": "Weekly Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
100,
300
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT id, name, email, phone FROM users"
},
"name": "Prod DB Query",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
300,
300
]
},
{
"parameters": {
"jsCode": "return items.map(item => ({\n json: {\n id: item.json.id,\n name: 'Anonymized User ' + item.json.id,\n email: 'user' + item.json.id + '@dev.local',\n phone: '555-0000'\n }\n}));"
},
"name": "Mask PII Data",
"type": "n8n-nodes-base.code",
"typeVersion": 1,
"position": [
500,
300
]
},
{
"parameters": {
"operation": "upsert",
"table": "users"
},
"name": "Dev DB Insert",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
700,
300
]
}
],
"connections": {
"Weekly Trigger": {
"main": [
[
{
"node": "Prod DB Query",
"type": "main",
"index": 0
}
]
]
},
"Prod DB Query": {
"main": [
[
{
"node": "Mask PII Data",
"type": "main",
"index": 0
}
]
]
},
"Mask PII Data": {
"main": [
[
{
"node": "Dev DB Insert",
"type": "main",
"index": 0
}
]
]
}
}
}To use this, copy the JSON above and paste it directly onto your n8n canvas.
Join the elite marketers who have offloaded their entire backend to n8n. Get direct support and custom builds in our private forum.