Wondering if anyone has tried using the google sheets node to import financial data (using GOOGLEFINANCE function) into n8n?
I have some workflows that format an HTML table using stock quote data from Google Sheets that are scheduled to send by Gmail.
It seems to work for standard attributes, but things get strange with calculated columns on the Sheet (e.g. 1 week change %, 1 year change %). I had it working fine over several tests. But an hour later, the table cells for calculated attributes became either blank or showed “#N/A (No matches are found in FILTER evaluation.)” Indeed the Json shows as:
{
“row_number”:
6,
“Index”:
“KOSPI”,
“Price”:
2556.61,
“This Week”:
“#N/A ()”,
“1-Year”:
“#N/A ()”
}
When I go back to the sheet, I can see the calculated data populated (of course if I manually reload the sheet, #N/A is displayed for a few seconds until the data loads. So what could be going on?