SQLite Web: database.sqlite

Update row 90 in execution_data

executionId

Primary key. INT NOT NULL

workflowData

{"id":"HhEZikdtm5ZZuKtm","name":"Onboarding System Automation","active":false,"nodes":[{"parameters":{"authentication":"none","formTitle":"Onboarding System","formDescription":"Please fulfill all of the fields","formFields":{"values":[{"fieldLabel":"Name","fieldType":"text","placeholder":"Enter Your Name","requiredField":true},{"fieldLabel":"Email","fieldType":"text","placeholder":"Please Enter Your Email","requiredField":true},{"fieldLabel":"Company Industry","fieldType":"text","placeholder":"e.g. Finances, Health Care","requiredField":true},{"fieldLabel":"What do you want to achieve with us in 5 months","fieldType":"text","placeholder":"","requiredField":true}]},"responseMode":"onReceived","addFormPage":"","options":{"appendAttribution":false}},"type":"n8n-nodes-base.formTrigger","typeVersion":2.2,"position":[-896,-128],"id":"88677045-dca5-4658-8884-e9956ad30e71","name":"On form submission","webhookId":"12a1a279-5ebd-44fb-985f-0a072f63e2dd"},{"parameters":{"aiAgentStarterCallout":"","preBuiltAgentsCallout":"","agent":"toolsAgent","promptType":"define","text":"=Can you generate a warm and professional welcome email for a new client based on the information provided? The message should be friendly, brief, and personalized—while still sounding professional. It should reflect the client’s industry and their goals for our collaboration. Below is the client’s information:\n\nName: {{ $json.Name }}\n\nEmail: {{ $json.Email }}\n\nCompany Industry: {{ $json['Company Industry'] }}\n\nGoals for the Partnership: {{ $json['What do you want to achieve with us in 5 months'] }}\n\nMake sure to always end the email with the following sign-off:\n\nBest regards,\nBob Bob\nVP of Internal Relations\nABC Corp\n\nDo not use placeholders like [Your Name] or [Your Contact Information] under any circumstances, even if some information is missing.\n\nReturn the result in 3 separate fields:\n\nSubject: The email’s subject line\n\nBody: The main email content\n\nEmail: {{ $json.Email }}","hasOutputParser":false,"options":{},"credentials":""},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-432,-352],"id":"277fce44-7c1a-4eda-83c6-ebb1e1acd9ca","name":"AI Agent"},{"parameters":{"notice":"","model":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"gpt-4o"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-400,-192],"id":"2752d5a3-30a2-4958-aff7-8bbea2d26610","name":"OpenAI Chat Model","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"resource":"text","operation":"message","modelId":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"GPT-4O"},"messages":{"values":[{"content":"Parse the JSON query and output the parameters seperately:\n\nSubject\nBody\nEmail","role":"system"},{"content":"={{ $json.output }}","role":"user"}]},"simplify":true,"jsonOutput":true,"options":{}},"type":"@n8n/n8n-nodes-langchain.openAi","typeVersion":1.8,"position":[-96,-352],"id":"011afeed-566d-4268-bd9d-b18e7b27ec9c","name":"OpenAI","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"preBuiltAgentsCalloutGmail":"","authentication":"oAuth2","resource":"message","operation":"send","sendTo":"={{ $json.message.content.Email }}","subject":"={{ $json.message.content.Subject }}","emailType":"html","message":"={{ $json.message.content.Body }}","options":{"appendAttribution":false}},"type":"n8n-nodes-base.gmail","typeVersion":2.1,"position":[272,-352],"id":"b62dc869-63a3-494f-ad6c-094c374bb9b2","name":"Gmail","webhookId":"803e30f5-7321-4612-8c73-9c7923f30356","credentials":{"gmailOAuth2":{"id":"jq5N8RrWCTNs4opL","name":"Gmail account"}}},{"parameters":{"aiAgentStarterCallout":"","preBuiltAgentsCallout":"","agent":"toolsAgent","promptType":"define","text":"=Use the client details below to generate a clear summary of their profile. Here is the information provided:\n\nName: {{ $json.Name }}\n\nCompany Industry: {{ $json['Company Industry'] }}\n\nGoals with Us: {{ $json['What do you want to achieve with us in 5 months'] }}\n\nReturn the following fields separately:\n\nName: {{ $json.Name }}\n\nEmail: {{ $json.Email }}\n\nSummary: A concise overview of the client based on the information provided above\n","hasOutputParser":false,"options":{},"credentials":""},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-560,32],"id":"1c257b43-9d15-4bf6-ba3d-5879d9d39642","name":"AI Agent1"},{"parameters":{"notice":"","model":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"gpt-4o"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[-608,208],"id":"5cf0053e-3d69-49da-8b21-d0c6550c353b","name":"OpenAI Chat Model1","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"resource":"text","operation":"message","modelId":{"__rl":true,"value":"gpt-4o","mode":"list","cachedResultName":"GPT-4O"},"messages":{"values":[{"content":"Parse the JSON query into 3 fields\n\nName\nEmail\nSummary","role":"system"},{"content":"={{ $json.output }}","role":"user"}]},"simplify":true,"jsonOutput":true,"options":{}},"type":"@n8n/n8n-nodes-langchain.openAi","typeVersion":1.8,"position":[-128,32],"id":"f0070d92-8c39-43a8-ab40-3d0b43031a7b","name":"OpenAI1","credentials":{"openAiApi":{"id":"5DFuvUPLavfaWChn","name":"OpenAi account"}}},{"parameters":{"preBuiltAgentsCalloutGoogleSheets":"","authentication":"oAuth2","resource":"sheet","operation":"append","documentId":{"__rl":true,"value":"1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4","mode":"list","cachedResultName":"Client's Onboarding","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"Name":"={{ $json.message.content.Name }}","Email":"={{ $json.message.content.Email }}","Summary":"={{ $json.message.content.Summary }}"},"matchingColumns":[],"schema":[{"id":"Name","displayName":"Name","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Email","displayName":"Email","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true},{"id":"Summary","displayName":"Summary","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[240,32],"id":"b3816505-1846-4cfe-af19-dd97cee68d5f","name":"Google Sheets","credentials":{"googleSheetsOAuth2Api":{"id":"NufmenCs2JQN68sm","name":"Google Sheets account"}}}],"connections":{"On form submission":{"main":[[{"node":"AI Agent1","type":"main","index":0},{"node":"AI Agent","type":"main","index":0}]]},"OpenAI Chat Model":{"ai_languageModel":[[{"node":"AI Agent","type":"ai_languageModel","index":0}]]},"AI Agent":{"main":[[{"node":"OpenAI","type":"main","index":0}]]},"OpenAI":{"main":[[{"node":"Gmail","type":"main","index":0}]]},"AI Agent1":{"main":[[{"node":"OpenAI1","type":"main","index":0}]]},"OpenAI Chat Model1":{"ai_languageModel":[[{"node":"AI Agent1","type":"ai_languageModel","index":0}]]},"OpenAI1":{"main":[[{"node":"Google Sheets","type":"main","index":0}]]}},"settings":{"executionOrder":"v1"},"staticData":{},"pinData":{}}

TEXT NOT NULL

data

[{"startData":"1","resultData":"2","executionData":"3"},{"destinationNode":"4"},{"error":"5","runData":"6","pinData":"7","lastNodeExecuted":"8"},{"contextData":"9","nodeExecutionStack":"10","metadata":"11","waitingExecution":"12","waitingExecutionSource":"13","runtimeData":"14"},"AI Agent",{"level":"15","tags":"16","description":"17","timestamp":1764630735244,"context":"18","functionality":"19","name":"20","node":"21","messages":"22","httpCode":"23","message":"24","stack":"25"},{"On form submission":"26","OpenAI Chat Model":"27","AI Agent":"28","OpenAI Chat Model1":"29","AI Agent1":"30","OpenAI1":"31","Google Sheets":"32"},{},"Google Sheets",{},["33"],{"OpenAI Chat Model":"34","OpenAI Chat Model1":"35"},{},{},{"version":1,"establishedAt":1764630725140,"source":"36"},"warning",{},"The caller does not have permission",{},"regular","NodeApiError",{"parameters":"37","type":"38","typeVersion":4.5,"position":"39","id":"40","name":"8","credentials":"41"},["42"],"403","Forbidden - perhaps check your credentials?","NodeApiError: Forbidden - perhaps check your credentials?\n    at ExecuteContext.apiRequest (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@aws-sdk+credential-providers@3.808.0_asn1.js@5_8da18263ca0574b0db58d4fefd8173ce/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/transport/index.ts:78:9)\n    at processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at GoogleSheet.spreadsheetGetSheet (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@aws-sdk+credential-providers@3.808.0_asn1.js@5_8da18263ca0574b0db58d4fefd8173ce/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/helpers/GoogleSheet.ts:129:21)\n    at ExecuteContext.router (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@aws-sdk+credential-providers@3.808.0_asn1.js@5_8da18263ca0574b0db58d4fefd8173ce/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/actions/router.ts:43:20)\n    at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@aws-sdk+credential-providers@3.808.0_asn1.js@5_8da18263ca0574b0db58d4fefd8173ce/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/GoogleSheetsV2.node.ts:30:10)\n    at WorkflowExecute.executeNode (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@file+packages+core_@opentelemetry+api@1.9.0_@opentelemetry+sdk-trace-base@1.30_08b575bec2313d5d8a4cc75358971443/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1074:8)\n    at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@file+packages+core_@opentelemetry+api@1.9.0_@opentelemetry+sdk-trace-base@1.30_08b575bec2313d5d8a4cc75358971443/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1255:11)\n    at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@file+packages+core_@opentelemetry+api@1.9.0_@opentelemetry+sdk-trace-base@1.30_08b575bec2313d5d8a4cc75358971443/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1691:27\n    at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@file+packages+core_@opentelemetry+api@1.9.0_@opentelemetry+sdk-trace-base@1.30_08b575bec2313d5d8a4cc75358971443/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:2307:11",["43"],["44"],["45"],["46"],["47"],["48"],["49"],{"node":"50","data":"51","source":"52"},["53"],["54"],"manual",{"preBuiltAgentsCalloutGoogleSheets":"55","authentication":"56","resource":"57","operation":"58","documentId":"59","sheetName":"60","columns":"61","options":"62"},"n8n-nodes-base.googleSheets",[240,32],"b3816505-1846-4cfe-af19-dd97cee68d5f",{"googleSheetsOAuth2Api":"63"},"403 - {\"error\":{\"code\":403,\"message\":\"The caller does not have permission\",\"status\":\"PERMISSION_DENIED\"}}",{"startTime":1764630725144,"executionIndex":0,"source":"64","hints":"65","executionTime":4,"executionStatus":"66","data":"67"},{"startTime":1764630727459,"executionTime":3366,"executionIndex":2,"executionStatus":"66","source":"68","data":"69","inputOverride":"70","metadata":"71"},{"startTime":1764630725152,"executionIndex":1,"source":"72","hints":"73","executionTime":5719,"executionStatus":"66","data":"74"},{"startTime":1764630730930,"executionTime":2351,"executionIndex":4,"executionStatus":"66","source":"75","data":"76","inputOverride":"77","metadata":"78"},{"startTime":1764630730872,"executionIndex":3,"source":"79","hints":"80","executionTime":2412,"executionStatus":"66","data":"81"},{"startTime":1764630733285,"executionIndex":5,"source":"82","hints":"83","executionTime":1601,"executionStatus":"66","data":"84"},{"startTime":1764630734887,"executionIndex":6,"source":"85","hints":"86","executionTime":358,"executionStatus":"87","error":"88"},{"parameters":"89","type":"38","typeVersion":4.5,"position":"90","id":"40","name":"8","credentials":"91"},{"main":"92"},{"main":"85"},{"subRun":"93"},{"subRun":"94"},"","oAuth2","sheet","append",{"__rl":true,"value":"95","mode":"96","cachedResultName":"97","cachedResultUrl":"98"},{"__rl":true,"value":"99","mode":"96","cachedResultName":"100","cachedResultUrl":"101"},{"mappingMode":"102","value":"103","matchingColumns":"104","schema":"105","attemptToConvertTypes":false,"convertFieldsToString":false},{},{"id":"106","name":"107"},[],[],"success",{"main":"108"},["109"],{"ai_languageModel":"110"},{"ai_languageModel":"111"},{"subRun":"93"},["112"],[],{"main":"113"},["114"],{"ai_languageModel":"115"},{"ai_languageModel":"116"},{"subRun":"94"},["117"],[],{"main":"118"},["119"],[],{"main":"120"},["121"],[],"error",{"level":"15","tags":"16","description":"17","timestamp":1764630735244,"context":"18","functionality":"19","name":"20","node":"21","messages":"22","httpCode":"23","message":"24","stack":"25"},{"preBuiltAgentsCalloutGoogleSheets":"55","authentication":"56","resource":"57","operation":"58","documentId":"122","sheetName":"123","columns":"124","options":"125"},[240,32],{"googleSheetsOAuth2Api":"126"},["127"],["128"],["129"],"1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4","list","Client's Onboarding","https://docs.google.com/spreadsheets/d/1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4/edit?usp=drivesdk","gid=0","Sheet1","https://docs.google.com/spreadsheets/d/1Y28XTc7qLq0sOJZrARmBZBpVk7EbklDmm3QoAkjO1z4/edit#gid=0","defineBelow",{"Name":"130","Email":"131","Summary":"132"},[],["133","134","135"],"NufmenCs2JQN68sm","Google Sheets account",["136"],{"previousNode":"4","previousNodeRun":0},["137"],["138"],{"previousNode":"139"},["140"],{"previousNode":"141","previousNodeRun":0},["142"],["143"],{"previousNode":"139"},["144"],{"previousNode":"141"},["145"],{"previousNode":"146"},{"__rl":true,"value":"95","mode":"96","cachedResultName":"97","cachedResultUrl":"98"},{"__rl":true,"value":"99","mode":"96","cachedResultName":"100","cachedResultUrl":"101"},{"mappingMode":"102","value":"147","matchingColumns":"148","schema":"149","attemptToConvertTypes":false,"convertFieldsToString":false},{},{"id":"106","name":"107"},["150"],{"node":"151","runIndex":0},{"node":"152","runIndex":0},"={{ $json.message.content.Name }}","={{ $json.message.content.Email }}","={{ $json.message.content.Summary }}",{"id":"153","displayName":"153","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},{"id":"155","displayName":"155","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},{"id":"156","displayName":"156","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},["157"],["158"],["159"],"On form submission",["160"],"AI Agent1",["161"],["162"],["163"],["164"],"OpenAI1",{"Name":"130","Email":"131","Summary":"132"},[],["165","166","167"],{"json":"168","pairedItem":"169"},"OpenAI Chat Model","OpenAI Chat Model1","Name","string","Email","Summary",{"json":"170","pairedItem":"171"},{"json":"172"},{"json":"173"},{"json":"174","pairedItem":"175"},{"json":"176"},{"json":"177"},{"json":"178","pairedItem":"179"},{"json":"168","pairedItem":"180"},{"id":"153","displayName":"153","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},{"id":"155","displayName":"155","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},{"id":"156","displayName":"156","required":false,"defaultMatch":false,"display":true,"type":"154","canBeUsedToMatch":true},{"index":0,"message":"181","logprobs":null,"finish_reason":"182"},{"item":0},{"Name":"183","Email":"184","Company Industry":"185","What do you want to achieve with us in 5 months":"186","submittedAt":"187","formMode":"188"},{"item":0},{"response":"189","tokenUsage":"190"},{"messages":"191","estimatedTokens":172,"options":"192"},{"output":"193"},{"item":0},{"response":"194","tokenUsage":"195"},{"messages":"196","estimatedTokens":76,"options":"197"},{"output":"198"},{"item":0},{"item":0},{"role":"199","content":"200","refusal":null,"annotations":"201"},"stop","Damon Hess","damonhess@hotmail.com","Awesomeness","Everything","2025-12-01T15:12:05.087-08:00","test",{"generations":"202"},{"completionTokens":161,"promptTokens":177,"totalTokens":338},["203"],{"openai_api_key":"204","model":"205","timeout":60000,"max_retries":2,"configuration":"206","model_kwargs":"207"},"Subject: Welcome to the ABC Corp Family, Damon!\n\nBody:  \n\nDear Damon,\n\nI hope this message finds you well! On behalf of everyone at ABC Corp, I want to extend a warm welcome to you and express our excitement at the opportunity to partner with you in the vibrant world of Awesomeness.\n\nWe are thrilled to embark on this journey with you and are fully committed to helping you achieve everything you're aiming for. Our team is eager to start working closely with you, ensuring that our collaboration is both fruitful and inspiring.\n\nPlease feel free to reach out anytime with questions or ideas. We’re here to support you every step of the way.\n\nLooking forward to an amazing partnership!\n\nBest regards,  \nBob Bob  \nVP of Internal Relations  \nABC Corp  \n\nEmail: damonhess@hotmail.com",{"generations":"208"},{"completionTokens":56,"promptTokens":81,"totalTokens":137},["209"],{"openai_api_key":"210","model":"205","timeout":60000,"max_retries":2,"configuration":"211","model_kwargs":"212"},"Name: Damon Hess\n\nEmail: damonhess@hotmail.com\n\nSummary: Damon Hess is associated with the dynamic and unique industry of \"Awesomeness.\" Driven by the aspiration to achieve virtually every possible goal with us, Damon presents an ambitious and limitless vision for collaboration.","assistant",{"Name":"183","Email":"184","Summary":"213"},[],["214"],"Human: Can you generate a warm and professional welcome email for a new client based on the information provided? The message should be friendly, brief, and personalized—while still sounding professional. It should reflect the client’s industry and their goals for our collaboration. Below is the client’s information:\n\nName: Damon Hess\n\nEmail: damonhess@hotmail.com\n\nCompany Industry: Awesomeness\n\nGoals for the Partnership: Everything\n\nMake sure to always end the email with the following sign-off:\n\nBest regards,\nBob Bob\nVP of Internal Relations\nABC Corp\n\nDo not use placeholders like [Your Name] or [Your Contact Information] under any circumstances, even if some information is missing.\n\nReturn the result in 3 separate fields:\n\nSubject: The email’s subject line\n\nBody: The main email content\n\nEmail: damonhess@hotmail.com",{"lc":1,"type":"215","id":"216"},"gpt-4o",{"baseURL":"217","fetchOptions":"218"},{},["219"],"Human: Use the client details below to generate a clear summary of their profile. Here is the information provided:\n\nName: Damon Hess\n\nCompany Industry: Awesomeness\n\nGoals with Us: Everything\n\nReturn the following fields separately:\n\nName: Damon Hess\n\nEmail: damonhess@hotmail.com\n\nSummary: A concise overview of the client based on the information provided above\n",{"lc":1,"type":"215","id":"220"},{"baseURL":"217","fetchOptions":"221"},{},"Damon Hess is associated with the dynamic and unique industry of \"Awesomeness.\" Driven by the aspiration to achieve virtually every possible goal with us, Damon presents an ambitious and limitless vision for collaboration.",["222"],"secret",["223"],"https://api.openai.com/v1",{},["224"],["223"],{},{"text":"193","generationInfo":"225"},"OPENAI_API_KEY",{"text":"198","generationInfo":"226"},{"prompt":0,"completion":0,"finish_reason":"182","system_fingerprint":"227","model_name":"228","service_tier":"229"},{"prompt":0,"completion":0,"finish_reason":"182","system_fingerprint":"230","model_name":"228","service_tier":"229"},"fp_672b6a21ba","gpt-4o-2024-08-06","default","fp_ed643dde95"]

TEXT NOT NULL

Cancel

database.sqlite — execution_data

Update row 90 in execution_data