Hi all, I'm a huge fan of what JJ and Stockton are doing at Better Than Data for agencies and consultants. They've now released a really nice template that lets you easily configure Mixed Analytics API Connector to set up your Google Analytics (GA4) request in Google Sheets, and then visualize that data in Looker Studio. Everything is done for you: the request configuration, the dashboard, and a video and course to explain it all.
Check it out here: https://betterthandata.com/tools/ga4-mixed/. It's free!
P.S. I highly recommend looking around at their complete offerings if you're a marketing/analytics agency or consultant looking to join a highly active and practical community dedicated to providing clients with really great results.