Use Zapier to create a zap that triggers every time you receive a new email with the report as an attachment
Set the zap to take this attachment and save it to Google Drive. Make sure to always save it under the same name (overwrite the old file)
Now you should have your report (CSV or Excel) automatically in Google Drive.
Use Sheetgo to connect to the file created in step 3 and have it automatically transfer the data from this report to your destination Google Sheets. Choose whether you want to connect or append your report.