Supabase-Lovable Sync Setup

My SaaS is already live in Lovable; what’s missing is a solid bridge to Supabase so user information flows automatically in both directions. I need you to:

• Create the appropriate table(s) in Supabase that mirror the user fields already defined in Lovable.
• Build the connection between the two platforms—Supabase Edge Functions, WebHooks, REST endpoints, or another proven method are all fine as long as the sync is reliable and secure.
• Apply three layers of transformation before anything lands in Supabase:
 1. Data cleaning and validation (e.g., trim whitespace, enforce field types, reject malformed entries).
 2. Data aggregation and summarization where required—for instance, rolling up usage stats that Lovable tracks per session into daily totals.
 3. Data format conversion so every record matches the schema we lock in for Supabase.
• Document the flow clearly and include a quick-start script or Postman collection I can run to verify everything.
• Provide short hand-off notes on how to extend the sync later (e.g., adding product details).

Acceptance Criteria
– Table structure in Supabase matches Lovable’s user model.
– New or updated Lovable users appear in Supabase within the agreed interval.
– All three transformation steps run automatically and pass sample tests.
– Implementation is pushed to my Git repo with concise README.

If you’ve connected Supabase to third-party tools before and are comfortable writing transformation logic, let’s get this shipped.