The audio detection feature is present in the wired Nest doorbell, which can detect loud noises but cannot detect low sounds. Once it detects such noises, the device sends a notification to your Google device.
But this feature is not available in the battery-powered version, though its motion sensing capabilities can be enhanced using the Nest Aware subscription. Alternatively, you can pair it with the Nest Hub to search for sounds.