I’m trying to create a workflow that runs at midnight for every user (using their local time zone). Is this possible?
Recurring workflows were just introduced, and they should do the trick. There are some restrictions based on what plan you are on though, as it can potentially put a heavy load on the shared server.
Read more here: [New Feature] Recurring workflows