When Reading rows from Google Sheets I can see the data in the following task, (in my case I’m using that as an input to an HTTP Request)
however, when I’m trying to use the schema for using the dynamic JavaScript input I only get the first row, and not all rows, despite the fact I can see that all items have been red.
What is the error message (if any)?
None
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”: {
“documentId”: {
“__rl”: true,
“value”: “1U8SlRNz1l-4xR_xPB2CdwVJXOEZso5_L5wOEl85x8A8”,
“mode”: “list”,
“cachedResultName”: “Market Sources”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1U8SlRNz1l-4xR_xPB2CdwVJXOEZso5_L5wOEl85x8A8/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “Source list”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1U8SlRNz1l-4xR_xPB2CdwVJXOEZso5_L5wOEl85x8A8/edit#gid=0”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.5,
“position”: [
-800,
0
],
“id”: “71254533-3dda-4bca-ac34-4fb3e46afe90”,
“name”: “Google Sheets”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “pC72ORg0YDnAgNdM”,
“name”: “Google Sheets account”
}
}
}
],
“connections”: {
“Google Sheets”: {
“main”: [
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “944238c2433b37ed719c67279aad2893bb4f00da390cfe814a44cdb45288b311”
}
}
{
“nodes”: [
{
“parameters”: {
“method”: “POST”,
“url”: “https://api.perplexity.ai/chat/completions”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: "Bearer API-Key
}
]
},
“sendBody”: true,
“specifyBody”: “json”,
“jsonBody”: “={\n "model": "sonar",\n "messages": [\n {\n "role": "system",\n "content": "You are an experienced investment analyst specializing in stock market research. Your task is to gather, analyze, and summarize the most relevant stock market news from the following sources:{{ $json.Website}}.\n\nYour summary should include:\n1. Market Overview: Key stock indices performance (S&P 500, NASDAQ, Dow Jones).\n2. Top News Headlines: Major stock market events, economic reports, and corporate earnings.\n3. Sector Performance: Notable movements in industries like tech, finance, energy, and healthcare.\n4. Expert Opinions: Key analyst upgrades/downgrades or economic outlook insights.\n5. Trends & Forecasts: Emerging trends, notable investor sentiment, or macroeconomic shifts.\n\nEnsure that the summary is concise, well-structured, and fact-based, avoiding speculation. Focus on delivering actionable insights in a professional tone."\n },\n {\n "role": "user",\n "content": "Provide a detailed stock market news summary based on the latest data."\n }\n ],\n "max_tokens": 700,\n "temperature": 0.2,\n "top_p": 0.9,\n "search_domain_filter": ["perplexity.ai"],\n "return_images": false,\n "return_related_questions": false,\n "search_recency_filter": "month",\n "top_k": 0,\n "stream": false,\n "presence_penalty": 0,\n "frequency_penalty": 1,\n "response_format": {\n "type": "text"\n }\n}”,
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
-480,
0
],
“id”: “b58974e2-844e-4429-9825-3271ee3e0d22”,
“name”: “HTTP Request”
}
],
“connections”: {
“HTTP Request”: {
“main”: [
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “944238c2433b37ed719c67279aad2893bb4f00da390cfe814a44cdb45288b311”
}
}
Share the output returned by the last node
Information on your n8n setup
- n8n version:
Cloud
