Email a requested CSV file to the teammate who asked for it.
Get a CSV copy of the exact spreadsheet tab you need, with its row count in your inbox or a clear explanation when no file can be sent.
Your teammates get the current reporting tab as a CSV attachment, with the file name and data row count in the reply.
Your coworkers get the Google Sheets tab they asked for as a CSV attachment, or a reply explaining what needs fixing.