How To Export Dashboard Data/KPI To Google Sheets

Go got the Google workspace marketplace and click "View more"

Click "Admin install"

Alternatively, you can find it in Google Sheets by navigating to: Extensions → Add-ons → Get add-ons (Marketplace)

Search for the "Profit Metrics" Extension in the Marketplace

Click "Continue"

Go back to your Google Sheet, click 'Extensions' → "ProfitMetrics for Google Sheets", and then select "Open Sidebar".

Go back to the ProfitMetrics Connections page and click "Generate" Key to create your API key.

Enter a custom name to identify your token.

Select the key’s expiration date: use an end date for one-time exports or 'No Expiration' for ongoing ones.

Choose site access so either the key has access to all the websites in the account or only a specific one. You can choose the websites in the Google Sheet extension afterwards. If you give full access, but it can also be that you want to grant someone access and export in Google Sheet for only a specific site. Then choose this custom.

Enable "Metrics reads"

Click "Generate token" and copy the key

Choose the website you would like to export dashboard data from to the Google Sheet. You can only export from one.

Choose the data export period from the website—select 'All Time' to export from the first recorded data to today, or pick a rolling window like the last 7, 30, or 12 months, which will update by overriding older data to keep only the recent period.

Select the start date sets when data export begins; by default, it uses the earliest data available for that website in ProfitMetrics, so leave it blank if you want to use that.

Choose the currency for the data in Google Sheets; if different from the website’s currency in ProfitMetrics, it will be converted using today’s exchange rate.

Now select the metrics. You can choose and search for the metrics you would like to include from the ProfitMetrics website in the import to Google Sheets. A column will be created for each of them daily, and it will be updated based on your frequency settings. You can also select all available KPIs that you have in the ProfitMetrics Dashboard. Please be aware that if there is a new KPI in the Profitmetrics dashboard, there may be a short delay before it is released in the Google Sheets extension. However, we are planning to make all KPIs available from the Dashboard, making it possible to export them to Google Sheets and analyze or use them in an external dashboard tool or for LMM analyses.

Choose the frequency of how often the data should be fetched from the dashboard and into the Google Sheets. If you choose hourly, today's row will be updated every  hour and refreshed with the current data from the ProfitMetrics dashboard.

Click "Save" to store your settings, "Schedule" to set automatic updates at your chosen frequency and date range, or 'Fetch Now' to immediately retrieve data—use 'Fetch Now' alone for one-time imports.

After the import completes, a pop-up notification will appear—its duration varies by data size and period.Then click 'OK' to finish.