Create new sheets for every new scheduled report using Google Sheets
To create new sheets for every new Google Sheet schedule, you need to select the "Add Sheets" option.
You can see this option when you select Google Sheet in the "How do you want the report to be delivered?" section.
Click here to know more about creating Google Sheet schedule.