SQLite Web: database.sqlite

versionId

Primary key. varchar(36) NOT NULL

workflowId

varchar(36) NOT NULL

authors

varchar(255) NOT NULL

createdAt

datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')

updatedAt

datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')

nodes

[{"parameters":{"formTitle":"Onboarding System","formDescription":"Please fulfill all of the fields","formFields":{"values":[{"fieldLabel":"Name","placeholder":"Enter Your Name","requiredField":true},{"fieldLabel":"Email","placeholder":"Please Enter Your Email","requiredField":true},{"fieldLabel":"Company Industry","placeholder":"e.g. Finances, Health Care","requiredField":true},{"fieldLabel":"What do you want to achieve with us in 5 months","requiredField":true}]},"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":{"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 }}","options":{}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-432,-352],"id":"277fce44-7c1a-4eda-83c6-ebb1e1acd9ca","name":"AI Agent"},{"parameters":{"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":{"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 }}"}]},"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":{"sendTo":"={{ $json.message.content.Email }}","subject":"={{ $json.message.content.Subject }}","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":{"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","options":{}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":1.9,"position":[-560,32],"id":"1c257b43-9d15-4bf6-ba3d-5879d9d39642","name":"AI Agent1"},{"parameters":{"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":{"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 }}"}]},"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":{"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"}}}]

TEXT NOT NULL

connections

TEXT NOT NULL

name

varchar(128)

autosaved

boolean NOT NULL (default false

description

TEXT

database.sqlite — workflow_history

Update row 296f90b4-b155-4472-8256-73e1765a13f7 in workflow_history