Sort of, though perhaps with some limitations. Google/Nest WiFi support a "guest" network that has a separate SSID and password. Devices connected to that network can connect to the internet, but can't see any devices on the non-guest network (unless those devices – like a printer, for example – have been explicitly shared with the guest network). Likewise, devices connected to the main network can't see any devices on the guest network.
What I haven't tested is whether devices on the guest network can see each other (devices on the main network definitely can). So, if you need that, you might have to do a little experimenting to see if it works.