The sb8200 is a modem only device. It doesn't have an ssid. The ssid is the wireless broadcast. You'd need a router for that

Will this modem work with the Google nest?

Yes

Any chance you can help me? Or should I call my internet provider (spectrum)? I’m getting to the point where the spectrum site wants new modem MAC address and I’m putting it in and says can’t find. 

I suggest you to contact your router manufacturer (Google Nest) for further assistance.

Just make sure you only have 1 thing connected to the sb8200. It has 2x ports but spectrum only supports 1 public ip address. (meaning only 1 thing can be connected)

There is two ethernet ports on SB8200. But you can access only one port at the same time, because both ports are assigned under same IP address.

If you wish to use both ports at the same time, I suggest you to contact your internet service provider to activate the second port with different IP address.