# N8N pointer to last row processed in Google Sheets

**URL:** <https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217>\
**Category:** Questions\
**Created:** [November 8, 2024, 8:55pm UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217 "2024-11-08T20:55:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![FantasticMRFox](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/fantasticmrfox/32/48334_2.png) [@FantasticMRFox](https://community.n8n.io/u/FantasticMRFox)\
**Post date:** [November 8, 2024, 8:55pm UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217/1 "2024-11-08T20:55:02Z")

</div>



---

<div class="post-metadata">

**Author:** ![n8n](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/n8n/32/26906_2.png) [@n8n](https://community.n8n.io/u/n8n)\
**Post date:** [November 8, 2024, 8:55pm UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217/2 "2024-11-08T20:55:04Z")

</div>

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:**

---

<div class="post-metadata">

**Author:** ![FantasticMRFox](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/fantasticmrfox/32/48334_2.png) [@FantasticMRFox](https://community.n8n.io/u/FantasticMRFox)\
**Post date:** [November 8, 2024, 9:24pm UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217/3 "2024-11-08T21:24:42Z")

</div>

Here is some add’l info  
-version 1.62.6  
-n8n cloud

---

<div class="post-metadata">

**Author:** ![ria](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ria/32/99251_2.png) [@ria](https://community.n8n.io/u/ria)\
**Post date:** [November 12, 2024, 7:31am UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217/4 "2024-11-12T07:31:50Z")

</div>

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!

> <https://github.com/n8n-io/n8n/pull/11235>
>
> \## 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)) 
> \- \[\] \[Docs updated\](https://github.com/n8n-io/n8n-docs) or follow-up ticket created.
> \- \[\] Tests included. 
> \- \[\] PR Labeled with \`release/backport\` (if the PR is an urgent fix that needs to be backported)

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [February 10, 2025, 7:32am UTC](https://community.n8n.io/t/n8n-pointer-to-last-row-processed-in-google-sheets/61217/5 "2025-02-10T07:32:47Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.