My script pulls data via a JSON request on a time trigger. Another function makes a summary of that data based on the filter in place.
Both parts work, however whenever it pulls new data and the filter is still active, it seems to either corrupt my data or just ignore it, depending on the method I use.
I tried setValues, appendRow and failed figuring out the AdvancedAPI append thing. setValues removes some of my data. appendRow just does nothing.
Any ideas how to fix it? I know that manually reapplying the filter works, but I'd rather have an automatic way if possible. Also, is it possible to do a sort and not ignore filter cells?