hi. i need help. the gsuite read range doesn’t work well. i have empty cells in one column. i want the empty cells to be read as well. but it turns out it only reads the last row that have values and doesn’t read the cells that have values.
for example: column0 have 50 rows. row 1 - 47 have values and row 48-50 doesn’t have values. when i view the output it only shows me the value in row 1- 47 and not row 1-50.
i already checked the selector. i made the range static so why is this happening?