Why is my Google Sheets creating a new sheet every time I run an immediate report?
When you create an immediate export, your Google Sheet will create a new sheet for each export.
This is because an immediate export is used when you want to manually export your report for any date range immediately.
To have your report update the same Google Sheet, you need to create an hourly, daily, weekly or monthly export.
This will automatically update the same Google Sheet without creating a new sheet.
To know how to create a hourly schedule, click here.
To know how to create a daily schedule, click here.
To know how to create a weekly schedule, click here.
To know how to create a monthly schedule, click here.