{ "edges": [ { "to": "c8467345-3c27-4e38-b587-34c138b83531", "from": "7f44215b-4353-48c3-9f42-69ae936bbd28", "toPort": "0", "fromPort": "0" }, { "to": "990ee665-d30d-4717-a36a-8787a54f10ca", "from": "1beea621-4227-42e8-beaf-8955a4d37c03", "toPort": "0", "fromPort": "0" }, { "to": "c6117291-f528-4e97-95a9-d30a11775055", "from": "990ee665-d30d-4717-a36a-8787a54f10ca", "toPort": "0", "fromPort": "0" }, { "to": "7f44215b-4353-48c3-9f42-69ae936bbd28", "from": "0e1da581-715a-4b2b-8437-9e3c7bd0872e", "toPort": "0", "fromPort": "0" }, { "to": "1beea621-4227-42e8-beaf-8955a4d37c03", "from": "06da9d06-b087-4cfd-a35f-ccaf59c9ca5b", "toPort": "0", "fromPort": "0" }, { "to": "06da9d06-b087-4cfd-a35f-ccaf59c9ca5b", "from": "a7a3a097-fd49-4d27-9bb3-8916c512e67d", "toPort": "0", "fromPort": "0" }, { "to": "df5352fc-1a8a-45a3-9aba-8376ac1a912e", "from": "c6117291-f528-4e97-95a9-d30a11775055", "toPort": "0", "fromPort": "0" }, { "to": "06da9d06-b087-4cfd-a35f-ccaf59c9ca5b", "from": "bb37a34e-3b27-408c-8237-2c1973bf77cb", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "06da9d06-b087-4cfd-a35f-ccaf59c9ca5b", "name": "Read Form Config", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k/edit#gid=0", "cachedResultName": "Form_Config" }, "documentId": { "__rl": true, "mode": "list", "value": "1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k/edit?usp=drivesdk", "cachedResultName": "Feedback Form" } }, "position": [ -208, 128 ] }, { "id": "1beea621-4227-42e8-beaf-8955a4d37c03", "name": "Format Config", "type": "code", "params": { "jsCode": "const items = $input.all();\nlet config = { title: '', subtitle: '', fields: [] };\nfor (const item of items) {\n const data = item.json;\n if (data.Setting_Type === 'Meta') {\n config[data.Key] = data.Value;\n }\n if (data.Setting_Type === 'Field') {\n config.fields.push({\n name: data.Key,\n type: data.Value,\n label: data.Label,\n options: data.Options ? data.Options.split(',').map(s => s.trim()) : [],\n required: data.Required === 'TRUE' || data.Required === 'true'\n });\n }\n}\nreturn [{ json: config }];" }, "position": [ 16, 128 ] }, { "id": "990ee665-d30d-4717-a36a-8787a54f10ca", "name": "Generate HTML", "type": "code", "params": { "jsCode": "const inputData = $input.all()[0].json;\n\n// Handle both array and object inputs\nconst config = Array.isArray(inputData) ? inputData[0] : inputData;\n\n// Escape closing script tags to avoid breaking HTML\nconst safeConfig = JSON.stringify(config).replace(/<\\/script>/gi, '<\\\\/script>');\n\n// 1. Get your n8n instance's base URL from its environment variables\nconst n8nBaseUrl = $env.WEBHOOK_URL || \"http:localhost:5678\";\n// 2. Check if you clicked 'Execute workflow' (manual/test) or if it's running live\nconst isTestMode = n8nBaseUrl === \"http:localhost:5678\";\nconst webhookPrefix = isTestMode ? \"webhook-test\" : \"webhook\";\n// 3. Dynamically build the final URL\nconst URL = `${n8nBaseUrl}/${webhookPrefix}/dynamic-form-submit`;\n\nconst html = `\n\n\n \n \n\n \n \n\n \n\n \n\n ${config.title || 'Dynamic Form Portal'}\n\n\n\n\n \n

\n\n \n

\n\n \n\n \n

\n\n

\n \n

\n\n

\n\n \n

\n\n \n\n

\n\n \n

\n\n

\n \n

\n\n

All done!

\n\n

Your response has been submitted successfully.

\n\n \n \n Submit another response\n \n\n

\n\n \n \n\n \n\n \n\n\n`;\n\nreturn [\n {\n json: {\n html\n }\n }\n];" }, "position": [ 288, 128 ] }, { "id": "bb37a34e-3b27-408c-8237-2c1973bf77cb", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ -480, 0 ] }, { "id": "c6117291-f528-4e97-95a9-d30a11775055", "name": "Upsert HTML Page", "type": "integration", "params": { "service": "pdftoolkit", "pageName": "={{ $('Format Config').item.json.title }}", "resource": "page", "operation": "upsert", "htmlContent": "={{ $json.html }}", "__originalType": "@custom-js/n8n-nodes-pdf-toolkit-v2.pdfToolkit" }, "position": [ 448, 128 ] }, { "id": "0e1da581-715a-4b2b-8437-9e3c7bd0872e", "name": "Webhook (POST)", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "dynamic-form-submit", "options": {}, "httpMethod": "POST", "responseMode": "lastNode" }, "position": [ -368, 480 ] }, { "id": "7f44215b-4353-48c3-9f42-69ae936bbd28", "name": "Add Timestamp", "type": "code", "params": { "jsCode": "const body = $input.all()[0].json.body;\nbody.timestamp = new Date().toISOString();\nreturn [{ json: body }];" }, "position": [ 96, 480 ] }, { "id": "c8467345-3c27-4e38-b587-34c138b83531", "name": "Save Response", "type": "integration", "params": { "columns": { "value": { "name": "={{ $json.name }}", "comments": "={{ $json.comments }}", "timestamp": "={{ $json.timestamp }}", "department": "={{ $json.department }}", "feedback_date": "={{ $json.feedback_date }}" }, "schema": [ { "id": "name", "type": "string", "display": true, "required": false, "displayName": "name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "department", "type": "string", "display": true, "required": false, "displayName": "department", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "feedback_date", "type": "string", "display": true, "required": false, "displayName": "feedback_date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "comments", "type": "string", "display": true, "required": false, "displayName": "comments", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "timestamp", "type": "string", "display": true, "required": false, "displayName": "timestamp", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": 479587747, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k/edit#gid=479587747", "cachedResultName": "Form_Responses" }, "documentId": { "__rl": true, "mode": "list", "value": "1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eAwCFWAICx3m9_ZCka0i0orrtMwcyRXbcunpgHFZc_k/edit?usp=drivesdk", "cachedResultName": "Feedback Form" } }, "position": [ 576, 480 ] }, { "id": "df5352fc-1a8a-45a3-9aba-8376ac1a912e", "name": "Convert HTML to PDF", "type": "integration", "params": { "html": "=\n\n\n\nKPI Dashbaord\n\n\n\n\n\n

\n\n\n\n\n ", "service": "pdftoolkit", "operation": "htmlToPdf", "pdfHeightMm": 120, "__originalType": "@custom-js/n8n-nodes-pdf-toolkit-v2.pdfToolkit" }, "position": [ 736, 128 ] }, { "id": "a7a3a097-fd49-4d27-9bb3-8916c512e67d", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -480, 160 ] } ] }

All done!

{{$('Format Config').item.json.title}}

Generate and host dynamic interactive forms from Google Sheets with CustomJS