Respuesta Automática de Email con GPT y Control de Feedback

Envía respuestas de email automáticas con OpenAI GPT-3.5 a destinatarios específicos. Registra emails y respuestas en Google Sheets. Permite capturar feedback para mejorar el modelo GPT.

Repo Original 49 nodos 14 tipos conectado

Cargando workflow...

Nodos

OpenAi

GmailTrigger If Set StickyNote

Gmail

Crypto

Html Code

NoOp

GoogleSheets Webhook

RespondToWebhook

Switch

Herramientas

OpenAI

Gmail

Google Sheets

Detalles

ID: 2411
Nodos: 49
Conex.: Sí
Tipos: 14

Pertenece a:

Atención al Cliente openai gmail google-sheets

¿Qué hace este workflow?

Este workflow automatiza la gestión de tus respuestas de email utilizando inteligencia artificial. Al recibir un correo electrónico, el sistema analiza su contenido y genera una respuesta personalizada con OpenAI GPT-3.5, dirigida a destinatarios específicos. Todas las comunicaciones, tanto los emails entrantes como las respuestas generadas, se registran automáticamente en Google Sheets, creando un historial completo y organizado. Una funcionalidad clave es la capacidad de recolectar feedback sobre la calidad de las respuestas de la IA. Este mecanismo es fundamental para la mejora continua del modelo GPT, permitiendo que la IA se adapte y refine su precisión con el tiempo. Es ideal para negocios que enfrentan un alto volumen de correos y buscan optimizar sus tiempos de respuesta, reducir la carga de trabajo manual y asegurar una comunicación de alta calidad y coherencia. La implementación de este sistema libera a tu equipo de tareas repetitivas, fomenta la satisfacción del cliente con respuestas rápidas y permite al personal concentrarse en interacciones más complejas. Esto se traduce en un ahorro sustancial de horas de trabajo y una optimización de recursos, además de asegurar que tus comunicaciones automáticas estén siempre a la vanguardia gracias al aprendizaje continuo.

¿Cómo funciona?

Este workflow usa 49 nodos conectados con 14 tipos diferentes: OpenAi, GmailTrigger, If, Set, StickyNote y 9 más. La estructura está totalmente conectada — listo para importar.

¿Para quién es?

Diseñado para equipos de Atención al Cliente. Nivel avanzado — recomendado para usuarios experimentados. Alto valor de negocio: automatiza una tarea recurrente con impacto directo.

¿Lo quieres en tu empresa?

→

Lo implementamos por ti end-to-end: integración, deploy, mantenimiento y soporte. Consultoría B2B con Genai Sapiens.

Hablemos de tu proyecto

¿Quieres aprender a hacerlo?

→

Sprints de 30 días con companion IA + comunidad. Aprende n8n, automatización y agentes IA desde cero o nivel avanzado.

Ver formación Momentum

Workflows similares

Automatiza el Resumen de Feedback con Google Sheets y GPT-4

basico ★ Alto

Automatiza Respuestas de Email con IA y Centraliza Historial en Hojas de Cálculo

avanzado ★ Alto

"},"typeVersion":1},{"id":"6b0bfa33-84ca-4b9c-98ec-c1bc08a1230d","name":"Extract message content (advanced)","type":"n8n-nodes-base.code","position":[-920,2360],"parameters":{"jsCode":"// source: https://gist.github.com/ikbelkirasan/2462073f6c7c760faa6fad7c6a0c4dc3\nvar EmailParser=function(t){var r={};function n(e){if(r[e])return r[e].exports;var o=r[e]={i:e,l:!1,exports:{}};return t[e].call(o.exports,o,o.exports,n),o.l=!0,o.exports}return n.m=t,n.c=r,n.d=function(t,r,e){n.o(t,r)||Object.defineProperty(t,r,{enumerable:!0,get:e})},n.r=function(t){\"undefined\"!=typeof Symbol&&Symbol.toStringTag&&Object.defineProperty(t,Symbol.toStringTag,{value:\"Module\"}),Object.defineProperty(t,\"__esModule\",{value:!0})},n.t=function(t,r){if(1&r&&(t=n(t)),8&r)return t;if(4&r&&\"object\"==typeof t&&t&&t.__esModule)return t;var e=Object.create(null);if(n.r(e),Object.defineProperty(e,\"default\",{enumerable:!0,value:t}),2&r&&\"string\"!=typeof t)for(var o in t)n.d(e,o,function(r){return t[r]}.bind(null,o));return e},n.n=function(t){var r=t&&t.__esModule?function(){return t.default}:function(){return t};return n.d(r,\"a\",r),r},n.o=function(t,r){return Object.prototype.hasOwnProperty.call(t,r)},n.p=\"\",n(n.s=59)}([function(t,r){var n=Array.isArray;t.exports=n},function(t,r,n){var e=n(31),o=\"object\"==typeof self&&self&&self.Object===Object&&self,u=e||o||Function(\"return this\")();t.exports=u},function(t,r,n){var e=n(74),o=n(79);t.exports=function(t,r){var n=o(t,r);return e(n)?n:void 0}},function(t,r){t.exports=function(t){return null!=t&&\"object\"==typeof t}},function(t,r){t.exports=function(t){var r=typeof t;return null!=t&&(\"object\"==r||\"function\"==r)}},function(t,r,n){var e=n(6),o=n(75),u=n(76),i=e?e.toStringTag:void 0;t.exports=function(t){return null==t?void 0===t?\"[object Undefined]\":\"[object Null]\":i&&i in Object(t)?o(t):u(t)}},function(t,r,n){var e=n(1).Symbol;t.exports=e},function(t,r,n){var e=n(35),o=n(99),u=n(14);t.exports=function(t){return u(t)?e(t):o(t)}},function(t,r,n){var e=n(64),o=n(65),u=n(66),i=n(67),c=n(68);function a(t){var r=-1,n=null==t?0:t.length;for(this.clear();++r-1&&t%1==0&&t<=9007199254740991}},function(t,r){t.exports=function(t){return function(r){return t(r)}}},function(t,r,n){(function(t){var e=n(31),o=r&&!r.nodeType&&r,u=o&&\"object\"==typeof t&&t&&!t.nodeType&&t,i=u&&u.exports===o&&e.process,c=function(){try{var t=u&&u.require&&u.require(\"util\").types;return t||i&&i.binding&&i.binding(\"util\")}catch(t){}}();t.exports=c}).call(this,n(13)(t))},function(t,r){var n=Object.prototype;t.exports=function(t){var r=t&&t.constructor;return t===(\"function\"==typeof r&&r.prototype||n)}},function(t,r,n){var e=n(41),o=n(42),u=Object.prototype.propertyIsEnumerable,i=Object.getOwnPropertySymbols,c=i?function(t){return null==t?[]:(t=Object(t),e(i(t),(function(r){return u.call(t,r)})))}:o;t.exports=c},function(t,r,n){var e=n(48);t.exports=function(t){var r=new t.constructor(t.byteLength);return new e(r).set(new e(t)),r}},function(t,r,n){var e=n(0),o=n(29),u=/\\.|\\[(?:[^[\\]]*|([\"'])(?:(?!\\1)[^\\\\]|\\\\.)*?\\1)\\]/,i=/^\\w*$/;t.exports=function(t,r){if(e(t))return!1;var n=typeof t;return!(\"number\"!=n&&\"symbol\"!=n&&\"boolean\"!=n&&null!=t&&!o(t))||(i.test(t)||!u.test(t)||null!=r&&t in Object(r))}},function(t,r,n){var e=n(5),o=n(3);t.exports=function(t){return\"symbol\"==typeof t||o(t)&&\"[object Symbol]\"==e(t)}},function(t,r,n){var e=n(5),o=n(4);t.exports=function(t){if(!o(t))return!1;var r=e(t);return\"[object Function]\"==r||\"[object GeneratorFunction]\"==r||\"[object AsyncFunction]\"==r||\"[object Proxy]\"==r}},function(t,r){var n=\"object\"==typeof global&&global&&global.Object===Object&&global;t.exports=n},function(t,r){var n=Function.prototype.toString;t.exports=function(t){if(null!=t){try{return n.call(t)}catch(t){}try{return t+\"\"}catch(t){}}return\"\"}},function(t,r,n){var e=n(34),o=n(18),u=Object.prototype.hasOwnProperty;t.exports=function(t,r,n){var i=t[r];u.call(t,r)&&o(i,n)&&(void 0!==n||r in t)||e(t,r,n)}},function(t,r,n){var e=n(93);t.exports=function(t,r,n){\"__proto__\"==r&&e?e(t,r,{configurable:!0,enumerable:!0,value:n,writable:!0}):t[r]=n}},function(t,r,n){var e=n(95),o=n(36),u=n(0),i=n(21),c=n(37),a=n(38),s=Object.prototype.hasOwnProperty;t.exports=function(t,r){var n=u(t),f=!n&&o(t),p=!n&&!f&&i(t),l=!n&&!f&&!p&&a(t),v=n||f||p||l,b=v?e(t.length,String):[],h=b.length;for(var y in t)!r&&!s.call(t,y)||v&&(\"length\"==y||p&&(\"offset\"==y||\"parent\"==y)||l&&(\"buffer\"==y||\"byteLength\"==y||\"byteOffset\"==y)||c(y,h))||b.push(y);return b}},function(t,r,n){var e=n(96),o=n(3),u=Object.prototype,i=u.hasOwnProperty,c=u.propertyIsEnumerable,a=e(function(){return arguments}())?e:function(t){return o(t)&&i.call(t,\"callee\")&&!c.call(t,\"callee\")};t.exports=a},function(t,r){var n=/^(?:0|[1-9]\\d*)$/;t.exports=function(t,r){var e=typeof t;return!!(r=null==r?9007199254740991:r)&&(\"number\"==e||\"symbol\"!=e&&n.test(t))&&t>-1&&t%1==0&&tf))return!1;var l=a.get(t);if(l&&a.get(r))return l==r;var v=-1,b=!0,h=2&n?new e:void 0;for(a.set(t,r),a.set(r,t);++v+$/,f=[/^\\s*(On(?:(?!.*On\\b|\\bwrote:)[\\s\\S])+wrote:)$/m,/^\\s*(Le(?:(?!.*Le\\b|\\bécrit:)[\\s\\S])+écrit :)$/m,/^\\s*(El(?:(?!.*El\\b|\\bescribió:)[\\s\\S])+escribió:)$/m,/^\\s*(Il(?:(?!.*Il\\b|\\bscritto:)[\\s\\S])+scritto:)$/m,/^\\s*(Op\\s[\\S\\s]+?schreef[\\S\\s]+:)$/m,/^\\s*((W\\sdniu|Dnia)\\s[\\S\\s]+?(pisze|napisał(\$a\$)?):)$/mu,/^\\s*(Den\\s.+\\sskrev\\s.+:)$/m,/^\\s*(Am\\s.+\\sum\\s.+\\sschrieb\\s.+:)$/m,/^(在[\\S\\s]+写道：)$/m,/^(20[0-9]{2}\\..+\\s작성:)$/m,/^(20[0-9]{2}\\/.+のメッセージ:)$/m,/^(.+\\s<.+>\\sschrieb:)$/m,/^\\s*(From\\s?:.+\\s?(\\[|<).+(\\]|>))/mu,/^\\s*(De\\s?:.+\\s?(\\[|<).+(\\]|>))/mu,/^\\s*(Van\\s?:.+\\s?(\\[|<).+(\\]|>))/mu,/^\\s*(Da\\s?:.+\\s?(\\[|<).+(\\]|>))/mu,/^(20[0-9]{2}-(?:0?[1-9]|1[012])-(?:0?[0-9]|[1-2][0-9]|3[01]|[1-9])\\s[0-2]?[0-9]:\\d{2}\\s[\\S\\s]+?:)$/m,/^\\s*([a-z]{3,4}\\.[\\s\\S]+\\sskrev[\\s\\S]+:)$/m];\n/**\n * Represents a fragment that hasn't been constructed (yet)\n * @license MIT License\n */\nclass p{constructor(){this.lines=[],this.isHidden=!1,this.isSignature=!1,this.isQuoted=!1}toFragment(){var t=c.reverse(this.lines.join(\"\\n\")).replace(/^\\n/,\"\");return new o(t,this.isHidden,this.isSignature,this.isQuoted)}}t.exports=class{constructor(t,r,n){this._signatureRegex=t||a,this._quotedLineRegex=r||s,this._quoteHeadersRegex=n||f}parse(t){if(\"string\"!=typeof t)return new e([]);var r=[];for(var n of(t=t.replace(\"\\r\\n\",\"\\n\"),this._quoteHeadersRegex)){var o=t.match(n);o&&o.length>=2&&(t=t.replace(o[1],o[1].replace(/\\n/g,\" \")))}var i=null;for(var a of c.reverse(t).split(\"\\n\")){if(a=a.replace(/\\n+$/,\"\"),this._isSignature(a)||(a=a.replace(/^\\s+/,\"\")),i){var s=i.lines[i.lines.length-1];this._isSignature(s)?(i.isSignature=!0,this._addFragment(i,r),i=null):0===a.length&&this._isQuoteHeader(s)&&(i.isQuoted=!0,this._addFragment(i,r),i=null)}var f=this._isQuote(a);null!==i&&this._isFragmentLine(i,a,f)||(i&&this._addFragment(i,r),(i=new p).isQuoted=f),i.lines.push(a)}i&&this._addFragment(i,r);var l=[];for(var v of r)l.push(v.toFragment());return new e(u(l))}_addFragment(t,r){(t.isQuoted||t.isSignature||0===t.lines.join(\"\").length)&&(t.isHidden=!0),r.push(t)}_isFragmentLine(t,r,n){return t.isQuoted===n||!!t.isQuoted&&(this._isQuoteHeader(r)||0===r.length)}_isSignature(t){return this._signatureRegex.test(c.reverse(t))}_isQuote(t){return this._quotedLineRegex.test(t)}_isQuoteHeader(t){return i(this._quoteHeadersRegex,r=>r.test(c.reverse(t))).length>0}}},function(t,r,n){var e=n(62),o=n(49),u=n(157);t.exports=class{constructor(t){this._fragments=t}getFragments(){return e(this._fragments)}getVisibleText(){var t=o(this._fragments,t=>!t.isHidden());return u(t,t=>t.getContent()).join(\"\\n\")}}},function(t,r,n){var e=n(63);t.exports=function(t){return e(t,5)}},function(t,r,n){var e=n(17),o=n(92),u=n(33),i=n(94),c=n(101),a=n(104),s=n(105),f=n(106),p=n(107),l=n(46),v=n(108),b=n(15),h=n(113),y=n(114),x=n(119),d=n(0),j=n(21),_=n(121),g=n(4),m=n(123),O=n(7),w={};w[\"[object Arguments]\"]=w[\"[object Array]\"]=w[\"[object ArrayBuffer]\"]=w[\"[object DataView]\"]=w[\"[object Boolean]\"]=w[\"[object Date]\"]=w[\"[object Float32Array]\"]=w[\"[object Float64Array]\"]=w[\"[object Int8Array]\"]=w[\"[object Int16Array]\"]=w[\"[object Int32Array]\"]=w[\"[object Map]\"]=w[\"[object Number]\"]=w[\"[object Object]\"]=w[\"[object RegExp]\"]=w[\"[object Set]\"]=w[\"[object String]\"]=w[\"[object Symbol]\"]=w[\"[object Uint8Array]\"]=w[\"[object Uint8ClampedArray]\"]=w[\"[object Uint16Array]\"]=w[\"[object Uint32Array]\"]=!0,w[\"[object Error]\"]=w[\"[object Function]\"]=w[\"[object WeakMap]\"]=!1,t.exports=function t(r,n,F,A,S,D){var $,P=1&n,z=2&n,E=4&n;if(F&&($=S?F(r,A,S,D):F(r)),void 0!==$)return $;if(!g(r))return r;var k=d(r);if(k){if($=h(r),!P)return s(r,$)}else{var B=b(r),M=\"[object Function]\"==B||\"[object GeneratorFunction]\"==B;if(j(r))return a(r,P);if(\"[object Object]\"==B||\"[object Arguments]\"==B||M&&!S){if($=z||M?{}:x(r),!P)return z?p(r,c($,r)):f(r,i($,r))}else{if(!w[B])return S?r:{};$=y(r,B,P)}}D||(D=new e);var I=D.get(r);if(I)return I;D.set(r,$),m(r)?r.forEach((function(e){$.add(t(e,n,F,e,r,D))})):_(r)&&r.forEach((function(e,o){$.set(o,t(e,n,F,o,r,D))}));var C=E?z?v:l:z?keysIn:O,Q=k?void 0:C(r);return o(Q||r,(function(e,o){Q&&(e=r[o=e]),u($,o,t(e,n,F,o,r,D))})),$}},function(t,r){t.exports=function(){this.__data__=[],this.size=0}},function(t,r,n){var e=n(9),o=Array.prototype.splice;t.exports=function(t){var r=this.__data__,n=e(r,t);return!(n<0)&&(n==r.length-1?r.pop():o.call(r,n,1),--this.size,!0)}},function(t,r,n){var e=n(9);t.exports=function(t){var r=this.__data__,n=e(r,t);return n<0?void 0:r[n][1]}},function(t,r,n){var e=n(9);t.exports=function(t){return e(this.__data__,t)>-1}},function(t,r,n){var e=n(9);t.exports=function(t,r){var n=this.__data__,o=e(n,t);return o<0?(++this.size,n.push([t,r])):n[o][1]=r,this}},function(t,r,n){var e=n(8);t.exports=function(){this.__data__=new e,this.size=0}},function(t,r){t.exports=function(t){var r=this.__data__,n=r.delete(t);return this.size=r.size,n}},function(t,r){t.exports=function(t){return this.__data__.get(t)}},function(t,r){t.exports=function(t){return this.__data__.has(t)}},function(t,r,n){var e=n(8),o=n(19),u=n(20);t.exports=function(t,r){var n=this.__data__;if(n instanceof e){var i=n.__data__;if(!o||i.length<199)return i.push([t,r]),this.size=++n.size,this;n=this.__data__=new u(i)}return n.set(t,r),this.size=n.size,this}},function(t,r,n){var e=n(30),o=n(77),u=n(4),i=n(32),c=/^\\[object .+?Constructor\\]$/,a=Function.prototype,s=Object.prototype,f=a.toString,p=s.hasOwnProperty,l=RegExp(\"^\"+f.call(p).replace(/[\\\\^$.*+?()[\\]{}|]/g,\"\\\\$&\").replace(/hasOwnProperty|(function).*?(?=\\\\\\()| for .+?(?=\\\\\\])/g,\"$1.*?\")+\"$\");t.exports=function(t){return!(!u(t)||o(t))&&(e(t)?l:c).test(i(t))}},function(t,r,n){var e=n(6),o=Object.prototype,u=o.hasOwnProperty,i=o.toString,c=e?e.toStringTag:void 0;t.exports=function(t){var r=u.call(t,c),n=t[c];try{t[c]=void 0;var e=!0}catch(t){}var o=i.call(t);return e&&(r?t[c]=n:delete t[c]),o}},function(t,r){var n=Object.prototype.toString;t.exports=function(t){return n.call(t)}},function(t,r,n){var e,o=n(78),u=(e=/[^.]+$/.exec(o&&o.keys&&o.keys.IE_PROTO||\"\"))?\"Symbol(src)_1.\"+e:\"\";t.exports=function(t){return!!u&&u in t}},function(t,r,n){var e=n(1)[\"__core-js_shared__\"];t.exports=e},function(t,r){t.exports=function(t,r){return null==t?void 0:t[r]}},function(t,r,n){var e=n(81),o=n(8),u=n(19);t.exports=function(){this.size=0,this.__data__={hash:new e,map:new(u||o),string:new e}}},function(t,r,n){var e=n(82),o=n(83),u=n(84),i=n(85),c=n(86);function a(t){var r=-1,n=null==t?0:t.length;for(this.clear();++r\n \n \n Template for ChatGPT email\n \n \n \n

\n {{ $json.text }}\n

\n \n

\n Was this message helpful? Yes • No\n

\n \n\n"},"typeVersion":1},{"id":"38e0f992-a461-4bc1-9f5c-2ceb0e461708","name":"Record feedback","type":"n8n-nodes-base.noOp","position":[-1360,2980],"parameters":{},"typeVersion":1},{"id":"899a0c63-0333-4dc4-ba83-5615a38ae431","name":"Fallback route","type":"n8n-nodes-base.noOp","position":[-1360,3280],"parameters":{},"typeVersion":1},{"id":"2fd5b109-8a54-4684-a8a3-3f7b2d961ae3","name":"Identify trigger #2","type":"n8n-nodes-base.set","position":[-2240,2940],"parameters":{"values":{"string":[{"name":"triggeredFrom","value":"webhook"}]},"options":{}},"typeVersion":1},{"id":"8c27f798-d947-432c-bfc9-d22727d0159e","name":"Identify trigger #1","type":"n8n-nodes-base.set","position":[-2240,2680],"parameters":{"values":{"string":[{"name":"triggeredFrom","value":"gmail"}]},"options":{}},"typeVersion":1},{"id":"bd8cc1dd-3643-4d2f-9527-cfd740a4072a","name":"Do not send unfinished email reply","type":"n8n-nodes-base.noOp","position":[-40,2060],"parameters":{},"typeVersion":1},{"id":"c8b68fdb-c1c0-4f94-b712-e0570a3ad53c","name":"If reply is complete","type":"n8n-nodes-base.if","position":[-260,1960],"parameters":{"conditions":{"string":[{"value1":"={{ $json.finish_reason }}","value2":"stop"}]}},"typeVersion":1},{"id":"f9d56d42-aa4e-4394-8c83-8d39164a784e","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-100,2020],"parameters":{"width":225.59802712700315,"height":314.2786683107279,"content":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nIf your workflow reaches this stage, you will need to consider increasing the tokens in `Generate reply` node."},"typeVersion":1},{"id":"039714b3-88ac-4ca8-86fc-ec1c109110c3","name":"Do not send email to this recipient","type":"n8n-nodes-base.noOp","position":[-1140,2560],"parameters":{},"typeVersion":1},{"id":"330c67dd-e538-414d-a144-e05dbf5effb3","name":"Send reply to database","type":"n8n-nodes-base.noOp","position":[-260,2380],"parameters":{},"typeVersion":1},{"id":"6e7586db-f437-4450-a1c7-e5ea7e8767b0","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[-3060,2520],"parameters":{"width":516.6954377311955,"height":680.5491163173024,"content":"## Send a ChatGPT email reply when email received and save responses to Google Sheets\nThis workflow sends a OpenAI GPT reply when an email is received from specific email recipients. It then saves the initial email and the GPT response to an automatically generated Google spreadsheet. Subsequent GPT responses will be added to the same spreadsheet. Additionally, when feedback is given for any of the GPT responses, it will be recorded to the spreasheet, which can then be used later to fine-tune the GPT model.\n\n### How it works\nThis workflow is essentially a two-in-one workflow. It triggers off from two different nodes and have very different functionality from each trigger.\n\n**`On email received`**:\n1. Triggers off on the `On email received` node.\n2. Extract the email body from the email.\n3. Generate a response from the email body using the `OpenAI` node.\n4. Reply to the email sender using the `Send reply to recipient` node. A feedback link is also included in the email body which will trigger the `On feedback given` node. This is used to fine-tune the GPT model.\n5. Save the email body and OpenAI response to a Google Sheet. If a sheet does not exist, it will be created.\n\n\n**`On feedback given`**:\n1. Triggers off when a feedback link is clicked in the emailed GPT response.\n2. The feedback, either positive or negative, for that specific GPT response is then recorded to the Google Sheet.\n"},"typeVersion":1},{"id":"9d5e780e-4282-4c7e-b083-3f769f7dc740","name":"Determine which trigger ran","type":"n8n-nodes-base.switch","position":[-1660,2800],"parameters":{"rules":{"rules":[{"value2":"gmail"},{"output":1,"value2":"webhook"}]},"value1":"={{ $json.triggeredFrom }}","dataType":"string","fallbackOutput":3},"typeVersion":1},{"id":"2c6c604c-7f59-42cc-9ed2-6d55f342f0ae","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[-1420,3240],"parameters":{"width":225.59802712700315,"height":289.61775585696694,"content":"\n\n\n\n\n\n\n\n\n\n\n\n\n\nThis workflow should never reach this node. It is only here for extending the functionality of this workflow if needed."},"typeVersion":1},{"id":"3defbf98-0caa-49b1-9bfd-f4640b43d64b","name":"Is text within token limit?","type":"n8n-nodes-base.if","position":[-700,2360],"parameters":{"conditions":{"boolean":[{"value1":"={{ $json.reply.length() / 4 <= $('Configure').first().json.maxTokenSize - $('Configure').first().json.replyTokenSize }}","value2":true}]}},"typeVersion":1},{"id":"b268b8a3-6361-4515-a995-320cd0979688","name":"Do nothing","type":"n8n-nodes-base.noOp","position":[-480,2460],"parameters":{},"typeVersion":1},{"id":"413588d1-ede0-4a51-85fa-c9035ec2e605","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[-540,2420],"parameters":{"width":225.59802712700315,"height":288.2949081608216,"content":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe email that was received is too large to process, as it exceeds token limit. See more on [token limits](https://help.openai.com/en/articles/4936856-what-are-tokens-and-how-to-count-them)."},"typeVersion":1}],"connections":{"Configure":{"main":[[{"node":"Determine which trigger ran","type":"main","index":0}]]},"Format data":{"main":[[{"node":"If no spreadsheet in configuration #1","type":"main","index":0}]]},"Generate UUID":{"main":[[{"node":"Extract message content (advanced)","type":"main","index":0}]]},"Email template":{"main":[[{"node":"Send reply to recipient","type":"main","index":0}]]},"Generate reply":{"main":[[{"node":"Send reply to database","type":"main","index":0},{"node":"If reply is complete","type":"main","index":0}]]},"Show HTML page":{"main":[[{"node":"If no spreadsheet in configuration #2","type":"main","index":0}]]},"If no sheet IDs":{"main":[[{"node":"Create spreadsheet","type":"main","index":0}],[{"node":"Get data from `Format data`","type":"main","index":0}]]},"Record feedback":{"main":[[{"node":"Thanks for your response!","type":"main","index":0}]]},"Get sheet IDs #1":{"main":[[{"node":"If no sheet IDs","type":"main","index":0}]]},"Get sheet IDs #2":{"main":[[{"node":"Send feedback for fine-tuned data","type":"main","index":0}]]},"Send email reply":{"main":[[{"node":"Email template","type":"main","index":0}]]},"On email received":{"main":[[{"node":"Identify trigger #1","type":"main","index":0}]]},"On feedback given":{"main":[[{"node":"Identify trigger #2","type":"main","index":0}]]},"Create spreadsheet":{"main":[[{"node":"Store spreadsheet ID","type":"main","index":0}]]},"Identify trigger #1":{"main":[[{"node":"Configure","type":"main","index":0}]]},"Identify trigger #2":{"main":[[{"node":"Configure","type":"main","index":0}]]},"If reply is complete":{"main":[[{"node":"Send email reply","type":"main","index":0}],[{"node":"Do not send unfinished email reply","type":"main","index":0}]]},"Store spreadsheet ID":{"main":[[{"node":"Get data from `Format data` node","type":"main","index":0}]]},"Create or update rows":{"main":[[{"node":"If spreadsheet doesn't exist","type":"main","index":0}]]},"Send reply to database":{"main":[[{"node":"Format data","type":"main","index":0}]]},"Thanks for your response!":{"main":[[{"node":"Show HTML page","type":"main","index":0}]]},"Determine which trigger ran":{"main":[[{"node":"Only continue for specific emails","type":"main","index":0}],[{"node":"Record feedback","type":"main","index":0}],null,[{"node":"Fallback route","type":"main","index":0}]]},"Get data from `Format data`":{"main":[[{"node":"Create or update rows","type":"main","index":0}]]},"Is text within token limit?":{"main":[[{"node":"Generate reply","type":"main","index":0}],[{"node":"Do nothing","type":"main","index":0}]]},"Store specific sheet IDs #1":{"main":[[{"node":"If no sheet IDs","type":"main","index":0}]]},"Store specific sheet IDs #2":{"main":[[{"node":"Send feedback for fine-tuned data","type":"main","index":0}]]},"If spreadsheet doesn't exist":{"main":[[{"node":"Create spreadsheet","type":"main","index":0}],[{"node":"Successfully created or updated row","type":"main","index":0}]]},"Get data from `Format data` node":{"main":[[{"node":"Paste data","type":"main","index":0}]]},"Only continue for specific emails":{"main":[[{"node":"Generate UUID","type":"main","index":0}],[{"node":"Do not send email to this recipient","type":"main","index":0}]]},"Extract message content (advanced)":{"main":[[{"node":"Is text within token limit?","type":"main","index":0}]]},"If no spreadsheet in configuration #1":{"main":[[{"node":"Get sheet IDs #1","type":"main","index":0}],[{"node":"Store specific sheet IDs #1","type":"main","index":0}]]},"If no spreadsheet in configuration #2":{"main":[[{"node":"Get sheet IDs #2","type":"main","index":0}],[{"node":"Store specific sheet IDs #2","type":"main","index":0}]]}}}