Create
Query
database.sqlite
—
execution_data
annotation_tag_entity
auth_identity
auth_provider_sync_history
chat_hub_agents
chat_hub_messages
chat_hub_sessions
credentials_entity
data_table
data_table_column
event_destinations
execution_annotation_tags
execution_annotations
execution_data
execution_entity
execution_metadata
folder
folder_tag
insights_by_period
insights_metadata
insights_raw
installed_nodes
installed_packages
invalid_auth_token
migrations
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_user_consents
processed_data
project
project_relation
role
role_scope
scope
settings
shared_credentials
shared_workflow
sqlite_sequence
tag_entity
test_case_execution
test_run
user
user_api_keys
variables
webhook_entity
workflow_dependency
workflow_entity
workflow_history
workflow_statistics
workflows_tags
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 91 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":"1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk","mode":"list","cachedResultName":"Automated Onboarding System","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk/edit?usp=drivesdk"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"Sheet1","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1cHZ6V1w3lfPtVfNWZhZi5Y7DDCSff5MlILfyJqW2iRk/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"},{},{"runData":"4","pinData":"5","lastNodeExecuted":"6"},{"contextData":"7","nodeExecutionStack":"8","metadata":"9","waitingExecution":"10","waitingExecutionSource":"11","runtimeData":"12"},{"On form submission":"13","OpenAI Chat Model":"14","AI Agent":"15","OpenAI":"16","Gmail":"17","OpenAI Chat Model1":"18","AI Agent1":"19","OpenAI1":"20","Google Sheets":"21"},{},"Google Sheets",{},[],{"OpenAI Chat Model":"22","OpenAI Chat Model1":"23"},{},{},{"version":1,"establishedAt":1764631013007,"source":"24"},["25"],["26"],["27"],["28"],["29"],["30"],["31"],["32"],["33"],["34"],["35"],"manual",{"startTime":1764631013010,"executionIndex":0,"source":"36","hints":"37","executionTime":2,"executionStatus":"38","data":"39"},{"startTime":1764631013078,"executionTime":2060,"executionIndex":2,"executionStatus":"38","source":"40","data":"41","inputOverride":"42","metadata":"43"},{"startTime":1764631013014,"executionIndex":1,"source":"44","hints":"45","executionTime":2133,"executionStatus":"38","data":"46"},{"startTime":1764631015148,"executionIndex":3,"source":"47","hints":"48","executionTime":2752,"executionStatus":"38","data":"49"},{"startTime":1764631017911,"executionIndex":4,"source":"50","hints":"51","executionTime":591,"executionStatus":"38","data":"52"},{"startTime":1764631018522,"executionTime":1372,"executionIndex":6,"executionStatus":"38","source":"53","data":"54","inputOverride":"55","metadata":"56"},{"startTime":1764631018503,"executionIndex":5,"source":"57","hints":"58","executionTime":1394,"executionStatus":"38","data":"59"},{"startTime":1764631019899,"executionIndex":7,"source":"60","hints":"61","executionTime":1277,"executionStatus":"38","data":"62"},{"startTime":1764631021177,"executionIndex":8,"source":"63","hints":"64","executionTime":2221,"executionStatus":"38","data":"65"},{"subRun":"66"},{"subRun":"67"},[],[],"success",{"main":"68"},["69"],{"ai_languageModel":"70"},{"ai_languageModel":"71"},{"subRun":"66"},["72"],[],{"main":"73"},["74"],[],{"main":"75"},["76"],[],{"main":"77"},["78"],{"ai_languageModel":"79"},{"ai_languageModel":"80"},{"subRun":"67"},["81"],[],{"main":"82"},["83"],[],{"main":"84"},["85"],[],{"main":"86"},["87"],["88"],["89"],{"previousNode":"90","previousNodeRun":0},["91"],["92"],{"previousNode":"93"},["94"],{"previousNode":"90"},["95"],{"previousNode":"96"},["97"],{"previousNode":"98","previousNodeRun":0},["99"],["100"],{"previousNode":"93"},["101"],{"previousNode":"98"},["102"],{"previousNode":"103"},["104"],{"node":"105","runIndex":0},{"node":"106","runIndex":0},["107"],"AI Agent",["108"],["109"],"On form submission",["110"],["111"],"OpenAI",["112"],"AI Agent1",["113"],["114"],["115"],["116"],"OpenAI1",["117"],"OpenAI Chat Model","OpenAI Chat Model1",{"json":"118","pairedItem":"119"},{"json":"120"},{"json":"121"},{"json":"122","pairedItem":"123"},{"json":"124","pairedItem":"125"},{"json":"126","pairedItem":"127"},{"json":"128"},{"json":"129"},{"json":"130","pairedItem":"131"},{"json":"132","pairedItem":"133"},{"json":"134","pairedItem":"135"},{"Name":"136","Email":"137","Company Industry":"138","What do you want to achieve with us in 5 months":"139","submittedAt":"140","formMode":"141"},{"item":0},{"response":"142","tokenUsage":"143"},{"messages":"144","estimatedTokens":172,"options":"145"},{"output":"146"},{"item":0},{"index":0,"message":"147","logprobs":null,"finish_reason":"148"},{"item":0},{"id":"149","threadId":"149","labelIds":"150"},{"item":0},{"response":"151","tokenUsage":"152"},{"messages":"153","estimatedTokens":76,"options":"154"},{"output":"155"},{"item":0},{"index":0,"message":"156","logprobs":null,"finish_reason":"148"},{"item":0},{"Name":"136","Email":"137","Summary":"157"},{"item":0},"Damon Hess","damonhess@hotmail.com","Awesomeness","Everything","2025-12-01T15:16:52.941-08:00","test",{"generations":"158"},{"completionTokens":146,"promptTokens":177,"totalTokens":323},["159"],{"openai_api_key":"160","model":"161","timeout":60000,"max_retries":2,"configuration":"162","model_kwargs":"163"},"Subject: Welcome to ABC Corp, Damon!\n\nBody: \nHi Damon,\n\nI hope this email finds you well. On behalf of the entire team at ABC Corp, I'm thrilled to welcome you aboard and to begin our exciting journey together!\n\nYour company’s dedication to Awesomeness caught our attention, and we're enthusiastic about the endless possibilities that lie ahead for our partnership. We are committed to supporting \"everything\" you'd like to achieve and ensuring a seamless and successful collaboration.\n\nPlease don't hesitate to reach out if you have any questions or need further assistance. We're here to help and excited to start this chapter with you.\n\nBest regards, \nBob Bob \nVP of Internal Relations \nABC Corp\n\nEmail: damonhess@hotmail.com",{"role":"164","content":"165","refusal":null,"annotations":"166"},"stop","19adc347b4491bb3",["167"],{"generations":"168"},{"completionTokens":69,"promptTokens":81,"totalTokens":150},["169"],{"openai_api_key":"170","model":"161","timeout":60000,"max_retries":2,"configuration":"171","model_kwargs":"172"},"Name: Damon Hess\n\nEmail: damonhess@hotmail.com\n\nSummary: Damon Hess works in the dynamic and innovative industry of \"Awesomeness.\" With ambitious and all-encompassing goals labeled as \"Everything,\" Damon seeks to maximize potential and achieve extensive objectives. This client appears eager to explore and leverage opportunities to their fullest extent.",{"role":"164","content":"173","refusal":null,"annotations":"174"},"Damon Hess works in the dynamic and innovative industry of 'Awesomeness.' With ambitious and all-encompassing goals labeled as 'Everything,' Damon seeks to maximize potential and achieve extensive objectives. This client appears eager to explore and leverage opportunities to their fullest extent.",["175"],"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":"176","id":"177"},"gpt-4o",{"baseURL":"178","fetchOptions":"179"},{},"assistant",{"Subject":"180","Body":"181","Email":"137"},[],"SENT",["182"],"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":"176","id":"183"},{"baseURL":"178","fetchOptions":"184"},{},{"Name":"136","Email":"137","Summary":"157"},[],["185"],"secret",["186"],"https://api.openai.com/v1",{},"Welcome to ABC Corp, Damon!","Hi Damon,\n\nI hope this email finds you well. On behalf of the entire team at ABC Corp, I'm thrilled to welcome you aboard and to begin our exciting journey together!\n\nYour company’s dedication to Awesomeness caught our attention, and we're enthusiastic about the endless possibilities that lie ahead for our partnership. We are committed to supporting \"everything\" you'd like to achieve and ensuring a seamless and successful collaboration.\n\nPlease don't hesitate to reach out if you have any questions or need further assistance. We're here to help and excited to start this chapter with you.\n\nBest regards,\nBob Bob\nVP of Internal Relations\nABC Corp",["187"],["186"],{},{"text":"146","generationInfo":"188"},"OPENAI_API_KEY",{"text":"155","generationInfo":"189"},{"prompt":0,"completion":0,"finish_reason":"148","system_fingerprint":"190","model_name":"191","service_tier":"192"},{"prompt":0,"completion":0,"finish_reason":"148","system_fingerprint":"193","model_name":"191","service_tier":"192"},"fp_672b6a21ba","gpt-4o-2024-08-06","default","fp_ed643dde95"]
TEXT NOT NULL
Update
Cancel