The NSA does not need consent from Google. Google is simply ordered to comply. See https://policies.google.com/terms/information-requests?hl=en...
> FISA orders and authorizations can be used to compel electronic surveillance and the disclosure of stored data, including content from services like Gmail, Drive, and Photos.
If you look at the content requests under FISA, you can see that there were over 118000 requests for user data between July 2023 and December 2023. https://transparencyreport.google.com/user-data/us-national-...
It was totally unrelated to PRISM, which was more like a voluntary law enforcement access portal that autoapproved every request. The participating companies since made public statements saying they no longer operate the portal, thereby forcing intelligence agencies to use National Security Letters instead. That's certainly closer to the intent of the laws passed by Congress.