Describe the problem/error/question
I am trying to retrieve an email address from a google sheets file. When I do it in the confined agent (contact agent) and feed it the same string in a chat trigger as comes from the main workflow it works fine, when is send the same string via the main workflow it always errors.
Via chat trigger: Can you retrieve Steve Utting’s email address?
Output: Steve Utting’s email address is [email protected]
Via main workflow:
Error: query
Can you retrieve Steve Utting’s email address?
error
No prompt specified
What is the error message (if any)?
Error: query
Can you retrieve Steve Utting’s email address?
error
No prompt specified
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
```{
"nodes": [
{
"parameters": {
"inputSource": "passthrough"
},
"type": "n8n-nodes-base.executeWorkflowTrigger",
"typeVersion": 1.1,
"position": [
0,
0
],
"id": "1fb2c696-b85c-4776-8492-3dec481f5ee3",
"name": "Workflow Input Trigger"
}
],
"connections": {
"Workflow Input Trigger": {
"main": [
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "bd6b4409fbf51ffa4ab24c1cfcf2d7f3493d7b12ed95aaa1d2c6f20ebdf49059"
}
}
{
"nodes": [
{
"parameters": {
"options": {
"systemMessage": "You are a contact agent. You are responsible for maintaining the list of contacts and retrieving details as needed.\n\n### Available Tools ###\n1. 'Get Contact' - Use this tool to get contact emails and other details.\n2. 'Add or Update Contact' - Use this tool to compare new data and update as necessary as well as to add a completely new record for a contact.\n\n### **Agent Workflow and Rules***\n1. **Identify the Action Type**\n - Determine whether the request is related to getting contact details, adding new contact details or updating details.\n\n2. **Gather Required Information**\n - If the task involves a contact, retrieve necessary details using 'Get Contact' before proceeding.\n - Example: get an email address i.e \"Can you retrieve for me Steve Utting's email address \".\n - If contact information is missing, ask the user for details before proceeding.\n\n3. **Call the Correct Tool**\n -Pass the user's request to the appropriate too in a structured query format. For email address query use \"Get Contact\"\n\n4. **Confirm Task Completion**\n - Provide a confirmation response once the too has executed the action.\n -If the tool requires more information, request it from the user before proceeding.\n\n### **Examples of Agent Execution**\n#### **Example 1: Retrieve an email address**\n**User Input:** \"can you retrieve Kelvin's email for me.\"\n\n**Action Steps:**\n1. Use 'Get Contact' to retrieve Kelvin's email address.\n\n---\n\n#### **Example 2: Add a New Contact**\n**User Input:** \"Add Kelvin's contact details.\"\n\n**Action Steps:**\n1. Use 'Add or Update Contact' to add a new contact.\n - if contact does not exist, add the new contact as a new record.\n - if the contact exists, check the current details and ukpdate with the new data if necessary.\n\n\n#### **Example 3: Update Contact details**\n**User Input:** \"Update Kelvin's phone number with the new number 0417555689.\"\n1. Call \"Add or Update Contact\" and check the phone number stored and update with then new one.\n2. Notify User: \"Kelvins phone number was updated\".\n\n---\n\n### **Error Handling and Clarifications**\n- **Missing Contact Information**\n - if the action requres an email and it's not found, stop and ask the user before pooceeding.\n- **Tool-Specific Errors:**\n - if a tool fails to execuete an action, notify the user and provide alternative suggestions.\n- **Ambiguous Requests:**\n - If a request is unclear, as the suer for clarification.\n\n---\n\n### **Final Notes**\n- Always confirms task completion or requests additional information from the user if needed.\n- Here is the current date/time {{ $now }}"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.7,
"position": [
220,
-160
],
"id": "dd1765c9-5aef-48cd-8e6e-f52c31c2c0d6",
"name": "Contact Agent",
"retryOnFail": true,
"onError": "continueErrorOutput"
}
],
"connections": {
"Contact Agent": {
"main": [
[],
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "bd6b4409fbf51ffa4ab24c1cfcf2d7f3493d7b12ed95aaa1d2c6f20ebdf49059"
}
}
{
"nodes": [
{
"parameters": {
"documentId": {
"__rl": true,
"value": "16XL0MiUHYldeyGq3Ow7pM7bKRQlXTs0DrFCI4-rqwO8",
"mode": "list",
"cachedResultName": "Contacts-new",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16XL0MiUHYldeyGq3Ow7pM7bKRQlXTs0DrFCI4-rqwO8/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 22910942,
"mode": "list",
"cachedResultName": "contacts-refined",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16XL0MiUHYldeyGq3Ow7pM7bKRQlXTs0DrFCI4-rqwO8/edit#gid=22910942"
},
"filtersUI": {
"values": [
{
"lookupColumn": "First Name",
"lookupValue": "={{ $fromAI(\"firstName\") }}"
},
{
"lookupColumn": "Last Name",
"lookupValue": "={{ $fromAI(\"surName\") }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTool",
"typeVersion": 4.5,
"position": [
340,
100
],
"id": "1902570a-5efc-490e-9caa-d93932f0dd53",
"name": "Get Contact",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "3UZ0kGcCmWGhEeU1",
"name": "Google Sheets account 3"
}
}
}
],
"connections": {
"Get Contact": {
"ai_tool": [
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "bd6b4409fbf51ffa4ab24c1cfcf2d7f3493d7b12ed95aaa1d2c6f20ebdf49059"
}
}
## Share the output returned by the last node
<!-- If you need help with data transformations, please also share your expected output. -->
## Information on your n8n setup
- **n8n version:**
- **Database (default: SQLite):**
- **n8n EXECUTIONS_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):**
- **Operating system:**
- [details="instance information"]
# Debug info
## core
- n8nVersion: 1.76.1
- platform: docker (cloud)
- nodeJsVersion: 20.18.2
- database: sqlite
- executionMode: regular
- concurrency: 5
- license: community
- consumerId: 00000000-0000-0000-0000-000000000000
## storage
- success: all
- error: all
- progress: false
- manual: true
- binaryMode: filesystem
## pruning
- enabled: true
- maxAge: 168 hours
- maxCount: 2500 executions
## client
- userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/132.0.0.0 safari/537.36 edg/132.0.0.0
- isTouchDevice: false
Generated at: 2025-02-10T02:51:22.563Z
[/details]