No, you do not need a hosting plan in order to have Google Workspace, but you do need a domain name to associate with your Google Workspace license. During Google Workspace signup, DreamHost asks you to select from a list of the domains in your DreamHost account.