Currently the only way to import fresh data into Google Sheets is by selecting a specific period corresponding to ‘last 7 days’ or ‘last 180’ days.
This makes it impossible for both old data to be kept, and new data to be added.
A feature that is able to schedule reports to run from a certain point in time until ‘Yesterday’ or ‘Today’ will solve that issue.
Awesome!!