I was not able to do on a sub-domain in Google Domains since there seems to be no way to delegate a sub-domain back to Google Domains.

You may be able to do this the wrong way by creating an A record for name.subdomain IN A 1.2.3.4 for the domain foo.com