Yeah, Claude Code is an AI tool that can make software projects, including websites, from scratch.

From your description, you'd probably need a backend for storing user data, and I'm not sure you'd be able to achieve that using just Google Sites.