n8n
November 8, 2024, 8:55pm
2
It looks like your topic is missing some important information. Could you provide the following if applicable.
n8n version:
Database (default: SQLite):
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app):
Operating system:
Here is some add’l info
-version 1.62.6
-n8n cloud
ria
November 12, 2024, 7:31am
4
Hi @FantasticMRFox
It would be nice if you could provide a bit more context about the error you are getting
Nevertheless, we had a recent bug fix with the Google Sheets node that went out with 1.64.0
Can you please update your n8n version and then come back if you’re still facing any issues (and please be more descriptive this time! ) Thanks!
n8n-io:master
← soerenuhrbach:bug/11234
opened 08:35PM - 11 Oct 24 UTC
## Summary
This change reduces the amount of data that will be loaded to iden… tify columns when appending new rows to a google sheet.
### Explanation
Before this change was the whole data set of the spreadsheet loaded, but only a few rows were needed to identity the columns. The problem is that the provided "range" parameter of the execute function only contains the sheet name without any range annotations. In case there would be any range annotations in the range, I extract the sheet name from it.
## Related Linear tickets, Github issues, and Community forum posts
Github issue #11234
## Review / Merge checklist
- [x] PR title and summary are descriptive. ([conventions](../blob/master/.github/pull_request_title_conventions.md)) <!--
**Remember, the title automatically goes into the changelog.
Use `(no-changelog)` otherwise.**
-->
- [ ] [Docs updated](https://github.com/n8n-io/n8n-docs) or follow-up ticket created.
- [ ] Tests included. <!--
A bug is not considered fixed, unless a test is added to prevent it from happening again.
A feature is not complete without tests.
-->
- [ ] PR Labeled with `release/backport` (if the PR is an urgent fix that needs to be backported)