Does Mail My Sheets work on personal Gmail accounts or only Google Workspace?

Yes, Mail My Sheets works on both personal Gmail and Google Workspace accounts.