{ "edges": [ { "to": "16b86a27-7d21-4d54-a52d-1acd6c47f4db", "from": "90a70a3a-1cb8-4702-93f5-3d8a2de2156b", "toPort": "0", "fromPort": "0" }, { "to": "e1a2792b-605c-405e-aafb-c71dfc52899f", "from": "6538979f-e905-49bd-af1e-165ebb147bb8", "toPort": "0", "fromPort": "0" }, { "to": "fdaf7f91-d267-4085-a7bb-1ed407e635ec", "from": "e996412b-6ce3-4b41-8c1a-f9ad7866e47e", "toPort": "0", "fromPort": "0" }, { "to": "07187c79-3949-4e67-8f2b-8bda3e3d7c1d", "from": "16b86a27-7d21-4d54-a52d-1acd6c47f4db", "toPort": "0", "fromPort": "0" }, { "to": "c06c73f3-5549-4c6b-ba56-e2127c551510", "from": "d718ec60-c0f1-47d5-a0b5-82f7b40a6c83", "toPort": "0", "fromPort": "0" }, { "to": "d718ec60-c0f1-47d5-a0b5-82f7b40a6c83", "from": "23df6a06-2606-48f0-a92f-78280936dd94", "toPort": "0", "fromPort": "0" }, { "to": "83ca2b33-1514-4ba4-8ecc-f3b21a7099a0", "from": "e1a2792b-605c-405e-aafb-c71dfc52899f", "toPort": "0", "fromPort": "0" }, { "to": "16d65e2b-bdc5-400b-91ae-7c06b9fd62d3", "from": "c06c73f3-5549-4c6b-ba56-e2127c551510", "toPort": "0", "fromPort": "0" }, { "to": "90a70a3a-1cb8-4702-93f5-3d8a2de2156b", "from": "16d65e2b-bdc5-400b-91ae-7c06b9fd62d3", "toPort": "0", "fromPort": "0" }, { "to": "6538979f-e905-49bd-af1e-165ebb147bb8", "from": "07187c79-3949-4e67-8f2b-8bda3e3d7c1d", "toPort": "0", "fromPort": "0" }, { "to": "23df6a06-2606-48f0-a92f-78280936dd94", "from": "fdaf7f91-d267-4085-a7bb-1ed407e635ec", "toPort": "0", "fromPort": "0" }, { "to": "7c705944-8857-4575-be1c-c46ab918a420", "from": "83ca2b33-1514-4ba4-8ecc-f3b21a7099a0", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "e996412b-6ce3-4b41-8c1a-f9ad7866e47e", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 9 } ] } }, "position": [ 5104, 4640 ] }, { "id": "fdaf7f91-d267-4085-a7bb-1ed407e635ec", "name": "Google Sheets Fetch Review", "type": "integration", "params": { "service": "googleSheets", "operation": "readRows", "documentId": { "__rl": true, "mode": "id", "value": "={{ $env.GSHEET_DOCUMENT_ID }}" } }, "position": [ 5328, 4640 ] }, { "id": "23df6a06-2606-48f0-a92f-78280936dd94", "name": "IF Has Valid Review", "type": "if", "params": { "options": {}, "conditions": { "options": { "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "cond-has-row", "operator": { "type": "string", "operation": "notEmpty" }, "leftValue": "={{ $json['Reviewer Name'] }}", "rightValue": "" } ] } }, "position": [ 5552, 4640 ] }, { "id": "d718ec60-c0f1-47d5-a0b5-82f7b40a6c83", "name": "Code Prepare Fields", "type": "code", "params": { "jsCode": "const item = $input.first().json;\nconst fields = item.fields || item;\n\nconst reviewerName = (fields['Reviewer Name'] || fields.reviewer_name || 'Happy Customer').trim();\nconst reviewText = (fields['Review Text'] || fields.review_text || '').trim();\nconst rating = Number(fields['Rating'] || fields.rating || 5);\nconst source = (fields['Source'] || fields.source || 'Verified Review').trim();\nconst recordId = item.id || item.record_id || '';\n\nif (!reviewText) throw new Error('Review text is empty. Check your Google Sheet column names.');\n\nconst cardText = reviewText.length > 200 ? reviewText.substring(0, 197) + '...' : reviewText;\nconst captionText = reviewText.length > 280 ? reviewText.substring(0, 277) + '...' : reviewText;\nconst starCount = Math.min(Math.max(rating, 1), 5);\nconst starsText = Array(starCount + 1).join('5star ');\nconst hashtags = '#customerreview #5stars #testimonial #socialproof #happycustomer #review';\n\nconst finalCaption = [\n '(' + starCount + '/5) Real words from a real customer.',\n '',\n '\"' + captionText + '\"',\n '-- ' + reviewerName + ' via ' + source,\n '',\n 'See why our customers keep coming back.',\n 'Link in bio.',\n '',\n hashtags,\n].join('\\n').trim().substring(0, 2200);\n\nconsole.log('[Prep] Reviewer:', reviewerName, 'Rating:', rating);\n\nreturn [{\n json: {\n record_id: recordId,\n reviewer_name: reviewerName,\n review_text: reviewText,\n card_text: cardText,\n rating: rating,\n star_count: starCount,\n source: source,\n final_caption: finalCaption,\n ig_user_id: $env.IG_USER_ID,\n }\n}];" }, "position": [ 5760, 4640 ] }, { "id": "c06c73f3-5549-4c6b-ba56-e2127c551510", "name": "Set Assemble HTML Card", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "html-field", "name": "html", "type": "string", "value": "={{ '

' + '★'.repeat($json.star_count) + '

' + $json.card_text + '

-- ' + $json.reviewer_name + '

' + $json.source + '

' + ($env.BRAND_NAME || 'Our Brand') + '

' }}" }, { "id": "pass-fields", "name": "passFields", "type": "object", "value": "={{ $json }}" } ] } }, "position": [ 5984, 4640 ] }, { "id": "16d65e2b-bdc5-400b-91ae-7c06b9fd62d3", "name": "HTTP Render HTML to Image", "type": "http", "params": { "url": "https://hcti.io/v1/image", "method": "POST", "options": {}, "sendBody": true, "authentication": "genericCredentialType", "bodyParameters": { "parameters": [ { "name": "html", "value": "={{ $json.html }}" } ] }, "genericAuthType": "httpBasicAuth" }, "position": [ 6208, 4640 ] }, { "id": "90a70a3a-1cb8-4702-93f5-3d8a2de2156b", "name": "Upload to URL", "type": "integration", "params": { "service": "uploadtourl", "operation": "run", "__originalType": "n8n-nodes-uploadtourl.uploadToUrl" }, "position": [ 6432, 4640 ] }, { "id": "16b86a27-7d21-4d54-a52d-1acd6c47f4db", "name": "Code Merge Fields", "type": "code", "params": { "jsCode": "const uploadResult = $input.first().json;\nconst prepData = $('Code Prepare Fields').first().json;\n\nconst publicImageUrl =\n uploadResult.public_url ||\n uploadResult.url ||\n uploadResult.file_url ||\n uploadResult.cdn_url ||\n uploadResult.imageUrl ||\n '';\n\nif (!publicImageUrl) {\n throw new Error('Upload to URL returned no public URL. Keys: ' + JSON.stringify(Object.keys(uploadResult)));\n}\n\nreturn [{\n json: {\n public_image_url: publicImageUrl,\n final_caption: prepData.final_caption,\n ig_user_id: prepData.ig_user_id,\n record_id: prepData.record_id,\n reviewer_name: prepData.reviewer_name,\n review_text: prepData.review_text,\n source: prepData.source,\n }\n}];" }, "position": [ 6640, 4640 ] }, { "id": "07187c79-3949-4e67-8f2b-8bda3e3d7c1d", "name": "IG Create Media Container", "type": "http", "params": { "url": "=https://graph.facebook.com/v19.0/{{ $json.ig_user_id }}/media", "method": "POST", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "image_url", "value": "={{ $json.public_image_url }}" }, { "name": "caption", "value": "={{ $json.final_caption }}" }, { "name": "access_token", "value": "={{ $env.IG_ACCESS_TOKEN }}" } ] } }, "position": [ 6864, 4640 ] }, { "id": "6538979f-e905-49bd-af1e-165ebb147bb8", "name": "Wait IG Buffer", "type": "passthrough", "params": { "mode": "noOp", "unit": "seconds", "amount": 6 }, "position": [ 7088, 4640 ] }, { "id": "e1a2792b-605c-405e-aafb-c71dfc52899f", "name": "IG Publish Container", "type": "http", "params": { "url": "=https://graph.facebook.com/v19.0/{{ $(\"Code Merge Fields\").first().json.ig_user_id }}/media_publish", "method": "POST", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "creation_id", "value": "={{ $(\"IG Create Media Container\").first().json.id }}" }, { "name": "access_token", "value": "={{ $env.IG_ACCESS_TOKEN }}" } ] } }, "position": [ 7312, 4640 ] }, { "id": "83ca2b33-1514-4ba4-8ecc-f3b21a7099a0", "name": "Google Sheets Mark as Posted", "type": "integration", "params": { "service": "googleSheets", "operation": "updateRow", "documentId": { "__rl": true, "mode": "id", "value": "={{ $env.GSHEET_DOCUMENT_ID }}" } }, "position": [ 7520, 4640 ] }, { "id": "7c705944-8857-4575-be1c-c46ab918a420", "name": "Slack Notify Team", "type": "integration", "params": { "text": "Social Proof Post Published!\n\nReviewer: {{ $(\"Code Merge Fields\").first().json.reviewer_name }}\nSource: {{ $(\"Code Merge Fields\").first().json.source }}\nPost ID: {{ $(\"IG Publish Container\").first().json.id }}\n\nReview: {{ $(\"Code Merge Fields\").first().json.review_text.substring(0, 100) }}\n\nCard URL: {{ $(\"Code Merge Fields\").first().json.public_image_url }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "id", "value": "={{ $env.SLACK_CHANNEL_ID }}" }, "operation": "read", "otherOptions": {}, "authentication": "oAuth2" }, "position": [ 7744, 4640 ] } ] }

Auto-generate Instagram posts from Google Sheets reviews using UploadtoUrl