We have discovered an issue with Google Search Console queries in Google Sheets that caused "Combine new results with old" setting to remove the older data in the report. Affected users may have experienced a situation where updating the query caused the older data to disappear from the report. This problem was caused due to an internal bug in our caching system, and we are unfortunately not able to retrieve this data anymore.
The only way to pull the missing data back to your file is to follow these steps:
1. Revert to an earlier version of your report where you still had the historical data
2. Duplicate the old query right under the last row of your query results (do not press "Get data to table" yet)
3. Modify the new query to not to include the header row (keep the "Combine new results with old checked)
4. Run the new duplicate query and you should have your old results and new results in place
5. Important! Remove the oldest query to prevent it from breaking the "Combine new results with old" setting when updating the queries in the future
Now your report should have the temporarily lost data on the first rows, and the new query after those rows with a functioning version of the "Combine new results with old" setting. Completing all of the steps above should ensure that you are able to retrieve the prior data back to your report as well as keep having it refreshed by triggers and combine the new data with old.
We are truly sorry for any inconvenience caused by this and have now implemented procedures to prevent these caches from getting deleted in the future.