When using a relative URL in the Go to URL action, the page must exist, so it sounds like you have not created a logout page, however you likely won't need this.
You can use the Supabase logout endpoint, however I default to using /.toddle/logout in the Go to URL action, which destroys the session and logs the user out with a redirect to the homepage.