How to set start row and end row in google sheet node?

Questions
1

I have column named start row and end row and have values below that. I want the node to read only the specified rows. How do I achieve this?

Describe the problem/error/question

What is the error message (if any)?

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.)

Share the output returned by the last node

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:
2 Likes
3

Wouldnā€™t that result in n8n thinking that row 5 is a headers row?

2 Likes
4

My issue with the Range field in the Google Sheets node. When I set the range to something like A2:F5, the output is treating the first row of that range (row 2) as a header. This means the data from row 2 is being excluded, and my output starts from row 3

2 Likes
6

This sounds interesting, could you please show a screenshot of that for the ā€œGet Row(s)ā€ operation?

2 Likes
8

canā€™t find disable ā€˜First Row as Headerā€™ option.

1 Like
10

fetching one row earlier and replacing the header name with code node works

1 Like
12

I am confused about the location of this option. Locating and removing rows is not something I can do, I really need to find that option that says ā€œFirst Row as Headerā€. Could you please send a screenshot?

13

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