Skip to content

Instantly share code, notes, and snippets.

@anoochit
Created May 11, 2025 05:06
Show Gist options
  • Save anoochit/d833ccfdc2d94f85b2e8eff6e351d7b3 to your computer and use it in GitHub Desktop.
Save anoochit/d833ccfdc2d94f85b2e8eff6e351d7b3 to your computer and use it in GitHub Desktop.
n8n signin form
{
"name": "signin",
"nodes": [
{
"parameters": {
"formTitle": "SignIn",
"formDescription": "SignIn with your email.",
"formFields": {
"values": [
{
"fieldLabel": "email",
"placeholder": "email",
"requiredField": true
},
{
"fieldLabel": "password",
"fieldType": "password",
"placeholder": "password",
"requiredField": true
}
]
},
"responseMode": "lastNode",
"options": {}
},
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.2,
"position": [
0,
0
],
"id": "28415a2d-53aa-42f3-9193-ce9714b0de52",
"name": "SignIn Form",
"webhookId": "5e67194f-bd00-4643-8cd2-92f348014c10"
},
{
"parameters": {
"operation": "update",
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"table": {
"__rl": true,
"value": "sessions",
"mode": "list",
"cachedResultName": "sessions"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"id": "={{ $json.id }}",
"updatedAt": "={{ $('encrypt password').item.json.submittedAt }}"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "updatedAt",
"displayName": "updatedAt",
"required": false,
"defaultMatch": false,
"display": true,
"type": "dateTime",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.6,
"position": [
660,
0
],
"id": "102552e6-98d8-4a8a-a97c-c34cc00ecf6c",
"name": "update session",
"credentials": {
"postgres": {
"id": "O0OegfK1zycT9UkY",
"name": "Postgres account"
}
}
},
{
"parameters": {
"operation": "select",
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"table": {
"__rl": true,
"value": "users",
"mode": "list",
"cachedResultName": "users"
},
"limit": 1,
"options": {}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.6,
"position": [
440,
0
],
"id": "ef7c40f1-ceec-4708-8c26-e795bd9f185d",
"name": "auth",
"credentials": {
"postgres": {
"id": "O0OegfK1zycT9UkY",
"name": "Postgres account"
}
}
},
{
"parameters": {
"type": "SHA256",
"value": "={{ $json.password }}",
"dataPropertyName": "password"
},
"type": "n8n-nodes-base.crypto",
"typeVersion": 1,
"position": [
220,
0
],
"id": "dfd344cb-cd9d-406b-b35f-84ebb06eec65",
"name": "encrypt password"
}
],
"pinData": {},
"connections": {
"SignIn Form": {
"main": [
[
{
"node": "encrypt password",
"type": "main",
"index": 0
}
]
]
},
"auth": {
"main": [
[
{
"node": "update session",
"type": "main",
"index": 0
}
]
]
},
"encrypt password": {
"main": [
[
{
"node": "auth",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "bdb0d3c4-4df8-4809-87ed-757f2863c5ea",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "8c8eb350f67a3e20013b8b1f94901b9f05a22220551a5bf5b60e1e108f4978c6"
},
"id": "hruo45Da9wS6KSEq",
"tags": []
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment