Google Sheets Get Range Values includes header in output

How To
1

I’m using the Get Range Values Module from Google Sheets to get a list of keywords. I’m then using another module to search those keywords. However Google Sheets is including the header row as the first bundle and that is ending up in the search module that follows.

I’ve checked “Table contains headers” and have tried leaving “Row with headers” blank and also putting “A1:C1”. The header value always get output to the next module anyway.

image

image

Am I doing something wrong or is this a bug?

1 Like
2

Hi @barron2020

Here is a sample setup for sheet shared:

image
image671×801 61.2 KB

image
image883×355 60.9 KB

Output:

image
image445×913 37.7 KB

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like
3

Thank you! Silly oversight on my part. I had assumed the range should include the full data set including headers and then by flagging the table contains headers, the Module would know what to do with those headers.

All good now.

1 Like
4

Glad to know @barron2020

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation