{ "edges": [ { "to": "5fdf887b-e1aa-4122-8ede-1ef586072a06", "from": "6f77780d-a9e7-44a3-834b-89f41fa40219", "toPort": "0", "fromPort": "0" }, { "to": "e028a171-81b8-4120-b443-414fbd77dc46", "from": "94929251-c783-4ede-9710-6aff9fc59ea1", "toPort": "0", "fromPort": "0" }, { "to": "6f77780d-a9e7-44a3-834b-89f41fa40219", "from": "e2b98cfd-f458-491f-adf9-951daae6c164", "toPort": "0", "fromPort": "0" }, { "to": "f5180c82-5bc1-4676-9e57-08e65ff741ae", "from": "93107afd-1e32-4f86-928a-baf2e9c5a24c", "toPort": "0", "fromPort": "0" }, { "to": "e2b98cfd-f458-491f-adf9-951daae6c164", "from": "0edf9e7e-bd71-42da-b028-2ea8b7c8439b", "toPort": "0", "fromPort": "0" }, { "to": "94929251-c783-4ede-9710-6aff9fc59ea1", "from": "abad8276-3b3e-4414-ad1d-7c4105e86d03", "toPort": "0", "fromPort": "0" }, { "to": "f516c987-5dac-4580-abf1-a29c111e5b5e", "from": "f5180c82-5bc1-4676-9e57-08e65ff741ae", "toPort": "0", "fromPort": "0" }, { "to": "2f0c7201-a5e4-4b3a-be91-0f200f8f249f", "from": "5fdf887b-e1aa-4122-8ede-1ef586072a06", "toPort": "0", "fromPort": "0" }, { "to": "b57bee88-1bc0-4bd2-b6cc-73ff96b56797", "from": "2f0c7201-a5e4-4b3a-be91-0f200f8f249f", "toPort": "0", "fromPort": "0" }, { "to": "1baf7d5d-478f-4d8c-9fe1-4b0a1947109e", "from": "7990f760-83ad-483c-adea-2f9eac6020d7", "toPort": "0", "fromPort": "0" }, { "to": "6b7e87eb-7958-4bab-bde9-db1df08c3148", "from": "9284d544-2cf9-4d67-830e-ef3de1990efb", "toPort": "0", "fromPort": "0" }, { "to": "abad8276-3b3e-4414-ad1d-7c4105e86d03", "from": "b57bee88-1bc0-4bd2-b6cc-73ff96b56797", "toPort": "0", "fromPort": "0" }, { "to": "7990f760-83ad-483c-adea-2f9eac6020d7", "from": "e028a171-81b8-4120-b443-414fbd77dc46", "toPort": "0", "fromPort": "0" }, { "to": "9284d544-2cf9-4d67-830e-ef3de1990efb", "from": "f516c987-5dac-4580-abf1-a29c111e5b5e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "0edf9e7e-bd71-42da-b028-2ea8b7c8439b", "name": "Webhook Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "testimonial-webhook", "options": {}, "httpMethod": "POST", "responseMode": "lastNode" }, "position": [ -304, 192 ] }, { "id": "e2b98cfd-f458-491f-adf9-951daae6c164", "name": "Data Validation", "type": "code", "params": { "jsCode": "// Data Validation Code for n8n\n// This code cleans and validates testimonial data from the webhook\n\nconst items = $input.all();\nconst cleanedItems = [];\n\nfor (const item of items) {\n // Access the body data from webhook\n const data = item.json.body || item.json;\n \n // Extract and clean fields\n let name = (data.name || data.Name || '').trim();\n let designation = (data.designation || data.Designation || data.role || '').trim();\n let testimonial = (data.testimonial_text || data.testimonial || data.Testimonial || '').trim();\n let photoUrl = (data.photo_url || data.Photo || data.photo || '').trim();\n let email = (data.email || data.Email || '').trim();\n \n // Validation: Check required fields\n if (!name || name.length < 2) {\n name = 'Anonymous User';\n }\n \n if (!testimonial || testimonial.length < 10) {\n // Skip invalid testimonials\n console.log('Skipping invalid testimonial - too short or empty');\n continue;\n }\n \n // Set defaults for optional fields\n if (!designation) {\n designation = 'Valued Customer';\n }\n \n // Generate fallback avatar if no photo provided\n if (!photoUrl || !photoUrl.startsWith('http')) {\n photoUrl = 'https://ui-avatars.com/api/?name=' + encodeURIComponent(name) + '&size=400&background=4F46E5&color=fff&bold=true';\n }\n \n // Clean testimonial text - remove extra spaces and HTML tags\n testimonial = testimonial\n .replace(/\\s+/g, ' ') // Replace multiple spaces with single space\n .replace(/[<>]/g, '') // Remove < and > to prevent XSS\n .trim();\n \n // Create clean object with all data\n cleanedItems.push({\n json: {\n name: name,\n designation: designation,\n testimonial: testimonial,\n photoUrl: photoUrl,\n email: email,\n timestamp: new Date().toISOString(),\n originalLength: testimonial.length,\n source: 'webhook'\n }\n });\n}\n\n// If no valid testimonials found, throw error\nif (cleanedItems.length === 0) {\n throw new Error('No valid testimonials found after validation');\n}\n\nreturn cleanedItems;" }, "position": [ 64, 192 ] }, { "id": "6f77780d-a9e7-44a3-834b-89f41fa40219", "name": "Set AI Prompt", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "prompt-assignment", "name": "prompt", "type": "string", "value": "=You are a professional editor. Polish the following testimonial to be grammatically perfect while maintaining the original tone, enthusiasm, and authenticity. Keep it natural and conversational. Do not add fake details or change the meaning. Keep the length similar to the original.\n\nOriginal testimonial:\n{{ $json.testimonial }}\n\nReturn ONLY the improved testimonial text, nothing else. No quotes, no preamble." } ] } }, "position": [ 368, 192 ] }, { "id": "5fdf887b-e1aa-4122-8ede-1ef586072a06", "name": "OpenAI Enhancement", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "gpt-4-turbo-preview", "cachedResultName": "GPT-4-TURBO-PREVIEW" }, "options": { "maxTokens": 300, "temperature": 0.3 }, "messages": { "values": [ { "content": "={{ $json.prompt }}" } ] }, "provider": "openai", "maxTokens": 300, "temperature": 0.3 }, "position": [ 640, 192 ] }, { "id": "2f0c7201-a5e4-4b3a-be91-0f200f8f249f", "name": "Extract AI Response", "type": "code", "params": { "jsCode": "// Extract AI Response Code (Updated for OpenAI format)\n// This extracts the enhanced testimonial from OpenAI and merges with previous data\n\nconst items = $input.all();\n\nreturn items.map((item) => {\n // Get the original data from Data Validation node\n const previousData = $('Data Validation').item.json;\n \n // Extract AI response from OpenAI's response format\n // OpenAI returns: [{ message: { content: \"text\" } }]\n let aiResponse;\n \n if (Array.isArray(item.json) && item.json[0]?.message?.content) {\n // Handle array format from OpenAI\n aiResponse = item.json[0].message.content;\n } else if (item.json.message?.content) {\n // Handle object format\n aiResponse = item.json.message.content;\n } else if (item.json.choices?.[0]?.message?.content) {\n // Handle choices format\n aiResponse = item.json.choices[0].message.content;\n } else if (item.json.text) {\n // Handle simple text format\n aiResponse = item.json.text;\n } else {\n // Fallback to original testimonial if extraction fails\n aiResponse = previousData.testimonial;\n }\n \n // Return merged data with both original and enhanced testimonial\n return {\n json: {\n ...previousData, // Keep all original data\n originalTestimonial: previousData.testimonial, // Save original\n testimonial: aiResponse.trim(), // Use enhanced version\n enhanced: true, // Mark as enhanced\n aiModel: 'gpt-4-turbo' // Track which model used\n }\n };\n});" }, "position": [ 1040, 192 ] }, { "id": "b57bee88-1bc0-4bd2-b6cc-73ff96b56797", "name": "Generate HTML Template", "type": "code", "params": { "jsCode": "// Generate HTML Template Code - FIXED VERSION\n// Creates a beautiful branded testimonial card with proper image handling\n\nconst items = $input.all();\n\nreturn items.map(item => {\n const data = item.json;\n \n // Function to escape HTML special characters (prevent XSS)\n const escapeHtml = (text) => {\n return text\n .replace(/&/g, '&')\n .replace(//g, '>')\n .replace(/\"/g, '"')\n .replace(/'/g, ''');\n };\n \n // Get initials for fallback\n const getInitials = (name) => {\n return name\n .split(' ')\n .map(n => n[0])\n .join('')\n .toUpperCase()\n .substring(0, 2);\n };\n \n const initials = getInitials(data.name);\n \n // Generate the HTML testimonial card\n const html = `\n\n\n \n \n \n \n \n\n\n

\n \n

\n ★★★★★\n

\n \n

\n \"${escapeHtml(data.testimonial)}\"\n

\n \n

\n $\"${escapeHtml(data.name)}\"$ \n

${initials}

${escapeHtml(data.name)}

${escapeHtml(data.designation)}

\n \n

\n YOUR BRAND\n

\n\n`;\n \n // Generate a unique filename\n const fileName = `${data.name.replace(/\\s+/g, '_')}_Testimonial_${new Date().getTime()}.png`;\n \n // Return the HTML and filename\n return {\n json: {\n ...data, // Keep all previous data\n html: html, // Add HTML template\n fileName: fileName // Add filename for later use\n }\n };\n});" }, "position": [ 1344, 192 ] }, { "id": "abad8276-3b3e-4414-ad1d-7c4105e86d03", "name": "HTML/CSS to Image", "type": "integration", "params": { "service": "htmlcsstoimage", "operation": "run", "html_content": "={{ $json.html }}", "__originalType": "n8n-nodes-htmlcsstoimage.htmlCssToImage" }, "position": [ 1632, 192 ] }, { "id": "94929251-c783-4ede-9710-6aff9fc59ea1", "name": "Download Image", "type": "http", "params": { "url": "={{ $json.image_url }}", "options": { "response": { "response": { "responseFormat": "file" } } } }, "position": [ 1920, 192 ] }, { "id": "e028a171-81b8-4120-b443-414fbd77dc46", "name": "Upload to Google Drive", "type": "integration", "params": { "name": "={{ $('Generate HTML Template').item.json.fileName }}", "driveId": { "__rl": true, "mode": "list", "value": "My Drive", "cachedResultUrl": "https://drive.google.com/drive/my-drive", "cachedResultName": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_DRIVE_FOLDER_ID", "cachedResultUrl": "https://drive.google.com/drive/folders/YOUR_GOOGLE_DRIVE_FOLDER_ID", "cachedResultName": "testimonial data" }, "operation": "read" }, "position": [ 2208, 192 ] }, { "id": "7990f760-83ad-483c-adea-2f9eac6020d7", "name": "Update Google Sheet", "type": "integration", "params": { "columns": { "value": { "Name": "={{ $('Generate HTML Template').item.json.name }}", "Email": "={{ $('Generate HTML Template').item.json.email }}", "Source": "={{ $('Generate HTML Template').item.json.source }}", "Status": "Pending Approval", "Drive ID": "={{ $json.id }}", "Enhanced": "={{ $('Generate HTML Template').item.json.enhanced ? 'Yes' : 'No' }}", "Timestamp": "={{ $('Generate HTML Template').item.json.timestamp }}", "Image Link": "={{ $json.webViewLink }}", "Designation": "={{ $('Generate HTML Template').item.json.designation }}", "Testimonial": "={{ $('Generate HTML Template').item.json.testimonial }}", "Original Length": "={{ $('Generate HTML Template').item.json.originalLength }}", "Original Testimonial": "={{ $('Generate HTML Template').item.json.originalTestimonial }}" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Designation", "type": "string", "display": true, "required": false, "displayName": "Designation", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Testimonial", "type": "string", "display": true, "required": false, "displayName": "Testimonial", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Testimonial", "type": "string", "display": true, "required": false, "displayName": "Original Testimonial", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Image Link", "type": "string", "display": true, "required": false, "displayName": "Image Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Drive ID", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Drive ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Length", "type": "string", "display": true, "required": false, "displayName": "Original Length", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Enhanced", "type": "string", "display": true, "required": false, "displayName": "Enhanced", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Source", "type": "string", "display": true, "required": false, "displayName": "Source", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Posted to Social", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Posted to Social", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Posted At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Posted At", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Drive ID" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": 1358321955, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_ID_HERE/edit#gid=1358321955", "cachedResultName": "Testimonial Database" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_ID_HERE", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_ID_HERE/edit?usp=drivesdk", "cachedResultName": "Feedback Log" } }, "position": [ 2544, 192 ] }, { "id": "1baf7d5d-478f-4d8c-9fe1-4b0a1947109e", "name": "Send Slack Notification", "type": "integration", "params": { "text": "=🎉 *New Testimonial Received!*\n\n*Customer Details:*\n- Name: {{ $('Generate HTML Template').item.json.name }}\n- Role: {{ $('Generate HTML Template').item.json.designation }}\n- Email: {{ $('Generate HTML Template').item.json.email }}\n\n*Testimonial:*\n_\"{{ $('Generate HTML Template').item.json.testimonial }}\"_\n\n*Original:*\n_\"{{ $('Generate HTML Template').item.json.originalTestimonial }}\"_\n\n*Image Preview:*\n{{ $('Upload to Google Drive').item.json.webViewLink }}\n\n*Database:*\nStatus: {{ $json.Status }}\nSheet: [View Testimonial Database](https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit)\n\n*Actions Required:*\n1. Review the testimonial and image\n2. Update status in Google Sheet to \"Approved\" or \"Rejected\"\n3. Approved testimonials will auto-post to social media\n\n---\n_Submitted via webhook at {{ $('Generate HTML Template').item.json.timestamp }}_", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "SLACK_CHANNEL_ID", "cachedResultName": "SLACK_CHANNEL_NAME" }, "operation": "read", "otherOptions": {} }, "position": [ 2832, 192 ] }, { "id": "93107afd-1e32-4f86-928a-baf2e9c5a24c", "name": "Every 5 Minutes", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "minutes" } ] } }, "position": [ 1280, 784 ] }, { "id": "f5180c82-5bc1-4676-9e57-08e65ff741ae", "name": "Read Google Sheet", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": 1358321955, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1358321955", "cachedResultName": "Testimonial Database" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEET_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk", "cachedResultName": "Feedback Log" } }, "position": [ 1616, 784 ] }, { "id": "f516c987-5dac-4580-abf1-a29c111e5b5e", "name": "IF Approved & Not Posted", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "status-check", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.Status }}", "rightValue": "Approved" }, { "id": "not-posted", "operator": { "type": "string", "operation": "empty", "singleValue": true }, "leftValue": "={{ $json['Posted to Social'] }}", "rightValue": "Yes" } ] } }, "position": [ 1984, 784 ] }, { "id": "9284d544-2cf9-4d67-830e-ef3de1990efb", "name": "Notify Ready to Post", "type": "integration", "params": { "text": "=✅ *Testimonial Ready for Social Media!*\n\n*Customer Details:*\n- Name: {{ $json.Name }}\n- Role: {{ $json.Designation }}\n- Email: {{ $json.Email }}\n\n*Testimonial:*\n_\"{{ $json.Testimonial }}\"_\n\n*Original:*\n_\"{{ $json['Original Testimonial'] }}\"_\n\n*View Image:*\n{{ $json['Image Link'] }}\n\n---\n\n*📱 Ready-to-Post Social Media Text:*\n\n🌟 Hear what our clients say!\n\n\"{{ $json.Testimonial }}\"\n\n— {{ $json.Name }}, {{ $json.Designation }}\n\n#ClientSuccess #Testimonial #CustomerReview\n\n---\n\n*Actions Required:*\n1. Copy the text above\n2. Post to Twitter & LinkedIn manually\n3. This testimonial will be marked as processed\n\n_Automated by n8n • {{ $now.format('MMM DD, YYYY @ HH:mm') }}_", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "SLACK_CHANNEL_ID", "cachedResultName": "SLACK_CHANNEL_NAME" }, "operation": "read", "otherOptions": {} }, "position": [ 2304, 672 ] }, { "id": "6b7e87eb-7958-4bab-bde9-db1df08c3148", "name": "Mark as Posted", "type": "integration", "params": { "columns": { "value": { "Drive ID": "={{ $('IF Approved & Not Posted').item.json[\"Drive ID\"] }}", "Posted At": "={{ $now.toISO() }}", "Posted to Social": "Ready - Manual Post Required" }, "schema": [ { "id": "Timestamp", "type": "string", "display": true, "required": false, "displayName": "Timestamp", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Designation", "type": "string", "display": true, "required": false, "displayName": "Designation", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Testimonial", "type": "string", "display": true, "required": false, "displayName": "Testimonial", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Testimonial", "type": "string", "display": true, "required": false, "displayName": "Original Testimonial", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Image Link", "type": "string", "display": true, "required": false, "displayName": "Image Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Drive ID", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Drive ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Length", "type": "string", "display": true, "required": false, "displayName": "Original Length", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Enhanced", "type": "string", "display": true, "required": false, "displayName": "Enhanced", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Source", "type": "string", "display": true, "required": false, "displayName": "Source", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Posted to Social", "type": "string", "display": true, "required": false, "displayName": "Posted to Social", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Posted At", "type": "string", "display": true, "required": false, "displayName": "Posted At", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": true, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Drive ID" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": 1358321955, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_ID_HERE/edit#gid=1358321955", "cachedResultName": "Testimonial Database" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_ID_HERE", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_ID_HERE/edit?usp=drivesdk", "cachedResultName": "Feedback Log" } }, "position": [ 2656, 672 ] } ] }

Process testimonials with GPT-4 & auto-generate social media cards with Google Sheets