Schedule queries to run once at a specific future date
I'd like to schedule a series of Google Sheets Supermetrics queries so that they only run once and they run on a specific date (the 2nd day of the month). For example, today is July 17, 2020 and I have want queries pull FB Ads Ad Spend for the month of July 2020 and I want this query to run on August 2, 2020. I want to keep this data so I don't want this data to be overwritten by scheduling the report to run monthly on the 2nd of the month as that will overwrite the July data (pulled on August 2) with the August data (if pulled on Sept 2).
Is this possible to configure within Supermetrics?
Would I need some custom Google Apps script to drive this logic?