CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
winshent
winshent

Reputation: 13

Google Sheets Update Filter data range when new rows aded

I have a Google Sheets spreadsheet with several tabs. Data is written to the 'tracker' tab constantly by a script which is writing information from incoming files. So new rows are constantly being added.

The tracker tab has a number of 'filter views' built using the UI. The data range that these filter views point to does not update when new rows are added.

I have seen some scripts which seem to be able to update the range if usng the Google Sheets API. However, I need something that runs within Google Apps Script itself..

Can anyone help?

Upvotes: 0

Views: 404

Answers (1)

winshent
winshent

Reputation: 13

The answer was to add the Google Sheets API via the add Services menu.

Upvotes: 0

Related Questions