You mean I can add Google accounts just within my Google Workspace or anybody with a Googe account?

Also, can I assign different sheets to different users, so they will see just the sheet assigned to them?

Any Google account can be added, but the license states this must be teammates/contractors in your organization and not outside of it (i.e. friends, facebook group members, course members, etc).