GA4 Sheets Add-on
With UA being sunset at the end of June 2023, here is a Google Sheets replacement for the UA Google Analytics Sheets Add-on that runs for GA4: https://docs.google.com/spreadsheets/d/1vlO5XhrYolG6prDA5cpKZhZJY7EcE-Kv0Zr_X5VAmZ0/copy All the code is open source in the Apps Script of the sheet and doesn't share any information to other people (unless you give other people access to the sheet). It uses the Google Analytics Data API, Google Analytics Admin API and Google Sheets API. The 'Config' tab is designed to be similar to the official sheets add-on for UA. The values entered need to use GA4 API values which can be most easily found using https://ga-dev-tools.google/ga4/query-explorer/ To use the sheet: Make a copy of the sheet above Read the 'Config Notes' tab Fill in col B of the 'Config' tab with details for your first report. Fill from Col C onwards to get additional reports in the same spreadsheet Click the 'Run Reports' menu > 'Refresh...