You can use Awesome Table Connectors to export data from Google Analytics 4 to Google Sheets by logging in with the Google Analytics 4 connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Google Analytics 4 connector.
On the Connect to Google Analytics 4 screen, click Sign in with Google Analytics 4.You are redirected to the Google sign-in page.
On the Google sign-in page, choose the account you want to sign in with.
Click Allow to grant Awesome Table permissions.Awesome Table informs you if your connection is successful.