Saltar al contenido

Respuesta automática de email con ChatGPT y registro en Google Sheets con feedback

Automatiza respuestas a emails con ChatGPT, guarda el historial en Google Sheets y permite feedback para entrenar el modelo, creando hojas si no existen.

AI 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 Webhook

Detalles

ID
1898
Nodos
49
Conex.
Sí
Tipos
14

Pertenece a:

Atención al Cliente Marketing & Email openai gmail google-sheets

¿Qué hace este workflow?

Este workflow automatiza la gestión de correos electrónicos al generar respuestas inteligentes con ChatGPT. Al recibir un email, el sistema procesa su contenido, crea una contestación personalizada y la envía. Paralelamente, registra toda la comunicación en una hoja de Google Sheets, la cual se crea automáticamente si aún no existe, asegurando un historial completo y organizado. Una característica clave es su sistema de feedback: permite a los usuarios revisar y calificar las respuestas generadas por la IA, utilizando esta información para entrenar y refinar el modelo de ChatGPT. Esto asegura que las respuestas sean cada vez más precisas y adecuadas a las necesidades de tu negocio, mejorando continuamente la calidad. Ideal para equipos con alto volumen de correos, este sistema incrementa la eficiencia y calidad en la atención, reduce el tiempo de respuesta y libera recursos, permitiendo escalar la comunicación sin perder personalización.

¿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, Marketing & Email. 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 Respuestas de Email con IA y Centraliza Historial en Hojas de Cálculo

avanzado ★ Alto

Gestión Inteligente de Emails en Gmail con IA y Google Sheets

intermedio ★ Alto

Automatiza el análisis de sentimiento de reseñas con IA y Google Sheets

intermedio ★ Alto

Automatiza tus Respuestas de Email con IA y Gestiona Feedback

avanzado ★ Alto

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

basico ★ Alto

Clasifica Emails de Gmail con GPT-4o-mini: Categorización Multi-Etiqueta

intermedio

Organizador de Gmail Inteligente con IA para Clasificación Automática

intermedio
"},"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
\n

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

\n
\n \n

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

\n

\n
\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}]]}}}