Need help to deploy a full stack nextjs app

hey folks, new to the cf platform have deployed a few static sites on the pages but now when I tried to deploy something more, getting a bunch of errors the app is in nextjs, fetches real estate info from a google sheet so far tried to use edge runtime, nothing was on the depoyed URL api routes work fine in local but becomes messy when I use functions, nothing loads on the app used this guide - https://developers.cloudflare.com/workers/framework-guides/web-apps/nextjs/#deploy-an-existing-nextjs-project-on-workers no luck with this as well, have been trying in local, the preview or run dev commands dont bring up the app in the respeactive port shared the screenshot with project structure and errors as well what else is missing or going wrong here, can anyone please help out to make this work with wrangler locally, then I will jump to the deployed one please let me know what else do I need to share to give more context