If you've linked Google Analytics to your Ads and AdSense accounts, you can use an add-on to bring your data into a Google Sheet, make any aggregations or modifications as needed, and then display the data with the Spreadsheets data source.
Install the Google Analytics add-on and connect your Google Analytics account.
Open a new Google Sheet, then click Add-ons > GA4 Reports Builder > Create new report.
Specify the Account, Property, and View (Profile) from which you want to pull data.
Select the metrics you’re interested in and any dimensions you’d like them broken down by. You can choose data from Adwords and AdSense from the Metrics and Dimensions menu.
Once you have the data in your sheet, you can then make any calculations needed.
When ready, connect it to Geckoboard to visualize your data.