I want loop over all values in specific row that i find in google sheet,
and know for sepcific cell its header.
Here my google sheet:
I found the row with “SUM” in column A
and now i want over on the cells and know for each cell its header
Can i iterate on the cells?
Also if i dont know how many cells in the row?
Hi,
You can use an iterator to loop through all values in that row. To get the header names, first use the “Get Range Values” module to fetch the header row (first row).
Then, as you iterate through each cell value in your target row, match its position with the header row to find the corresponding column name
Hi @Tzipora , you don’t need ‘iterator’ here. use ‘sheet get range’ module first for A1:B1 (i suppose?) to get header names as values. then use ‘sheet get range’ module for A2:B32. this automatically iterates all of next operations FOR EACH ROW. meaning you just need to filter before any third module with ‘getrange2: column B value’ = ‘getrange1: column B value’).
