I messed up. I removed it from Cloudflare in hope it would things back to normal. However It didn’t which prompted me contact godaddy support who claimed the site is fine (but I still wasn’t able to access it), so I asked them to “reset” my DNS settings so I can remove custom domain from my google site and reconnect it again from scratch.
However it seems I am having issues now to connect it to my custom domain.
I would want to add it back to Cloudflare, please do help out. Thanks!