Here’s a quick tip for you. Setting report triggers in Google Sheets is a lifesaver, but you may have queries in your reports that you don’t want to update every time the refresh happens. 

This is why we have a handy advanced setting called ​​’SKIP_QUERY_REFRESH’.

This setting skips the query you don’t want to update but runs the refresh to all other queries.