Comment by houseatrielah

I'd let supabase handle auth ++ db and use a "supabase edge scheduled function" to execute your script.