I’ve created a dashboard with many charts based on a spreadsheet that I regularly update with Sheetgo.
The problem is that these charts don’t include the new rows in the input spreadsheet every time I update it with Sheetgo. This is due to the fact that your script overwrites the number of active rows in a sheet based on the input file. Isn’t there a way to prevent that?
Some screens for reference.
I’d like the spreadsheet not to be cut at 16 rows but to go all the way to 1000 rows. If I add 1000 rows below, the next time I update the spreadsheet with Sheetgo, it’ll go back to 16 rows.
This prevents me from setting the charts to be dynamic by including 1000 rows in the input range.