Thanks @MikeCB, it's helpful in the sense that it's a response with facts that lead to more facts.
Looks like the new method will be via the Google Analytics Data API and it looks like there's a tangentially related forum thread regarding this already Google Analytics 4 and Data API v1 via REST resource issue
Hopefully the Retool team will build native support for the newer method in the future.