As you know in current google sheet there are some features and some have issues.
I ask to improve:
- In “Read” feature, node load all data from table on google sheets but it return just first row unfortunately.
I thin there are some two important feature for google sheets for manage rows and column that is missed.
I search google sheet API and I see below references:
REST Resource: spreadsheets.developerMetadata
By these methods:
get feature: You could get specific row or column I think.
search feature: It return all matches rows or columns. (lookup feature just return one matches row, I think)