How to export data to Google Sheets using the ProfitMetrics extension (V2)

NOTE: The extension exports data in US numerical format. Before getting started, open your Google Sheet and go to File → Settings → General → Locale and set it to United States, then click Save and Reload.

Prerequisites

You need the following before starting:

A ProfitMetrics account with at least one website configured
A Google account with access to Google Sheets
An API key with Metrics Read permission (see below)

Install the Extension

In ProfitMetrics, go to Integration → Connections and click Google Sheet Export.
You will be taken to the Google Workspace Marketplace. Click Install.
Sign in with your Google account and click Continue, then Allow to grant the required permissions.
Open a Google Sheet. Go to Extensions → ProfitMetrics for Google Sheets → Open Sidebar.

Generate an API Key

In ProfitMetrics, go to Integration → Connections → Google Sheet Export and click 🗝Generate.
Enter a name to identify your token (e.g. Google Sheets Export).
Set the expiration — use No Expiration for ongoing scheduled exports, or set an end date for one-time imports.
Choose Site Access — either all websites in the account, or a specific website. You can still choose which websites to include per schedule in the extension itself.
Enable Metrics Read under permissions.
Click Generate Token and copy the API key.

The API key is only shown once. Store it somewhere secure before closing the dialog.

Connect the Extension

In your Google Sheet, open the ProfitMetrics sidebar (Extensions → ProfitMetrics for Google Sheets → Open Sidebar).
Click the Settings tab.
Paste your API key into the API Key field and click Save.

Configure a Schedule

Switch to the Metrics tab and click Configuration to create a new export schedule. Each schedule writes to its own sheet tab within the spreadsheet.

Setting	Description
Sheet name	The name of the tab this schedule writes to. Each schedule creates a separate tab, so you can run multiple schedules in the same spreadsheet — for example, one tab per website.
Websites	Select which website(s) to include in this export. If you have multiple websites and want them on separate tabs, create a schedule for each one with a different sheet name.
Period	The rolling date window to export — e.g. `Last 7 days`, `Last 30 days`, `Last 12 months`, or `All Time`.
Currency conversion	If set to a different currency than the website's default, values are converted using the current exchange rate at the time of export.
Select metrics	Choose which KPIs to include. Each selected metric becomes a column in the sheet. All metrics available on the ProfitMetrics dashboard are available here.
Resolution	The time granularity for each row of data: `Day`, `Week`, `Month`, or `Total`. For example, if you select `Day` you will see one row per day, and if you select `Week` you will see one row per week.
Frequency	How often the export runs — `Hourly`, `Daily`, `Weekly`, or `Monthly`. If set to Hourly, the current day's row is updated every hour with the latest data from ProfitMetrics.
Minute of hour	Controls when within the hour the scheduled export runs. Set to `0` for the top of the hour, `30` for half past, etc.

Import Mode

Import mode controls how new data is written to the sheet when the schedule runs.

Mode	Behaviour
Append	Fetches the data for the configured period and adds it to the existing sheet. New rows are appended for any new dates. Rows already in the sheet that fall within the period are updated in place, while rows outside the period are left untouched. This is useful for building a growing historical dataset — each run extends the sheet with new data without clearing older entries.
Replace	Clears the entire sheet and writes only the data for the current period. The sheet will always contain exactly the rows covered by the configured date window. Use this when you want a clean, rolling snapshot with no residual data from previous runs.

Once configured, click Save schedule.

Multiple Sheets

You can create multiple schedules within the same spreadsheet, each writing to its own tab. This is useful when you have more than one website in your ProfitMetrics account and want to keep data separated.

For example, you could create three schedules — one per website — each with a descriptive Sheet name like UK Store, DE Store, and US Store. Each schedule can have its own period, metrics, resolution, frequency, and import mode.

Managing Schedules

Click the Schedules tab in the sidebar to view all active schedules for the current spreadsheet. Each card shows the sheet name, owner, period, and import mode.

From this view you can:

Test — Run the schedule immediately to verify it works.
Edit — Opens the schedule back in the Metrics → Configuration view so you can change any settings.
Remove — Delete the schedule. This stops future runs but does not delete the data already in the sheet tab.

NOTE: If you originally setup your Google Sheets export using an older version of the Google Sheets extension, a schedule will be automatically created for you based on the previous settings. Please double-check that the schedule is satisfactory for you.

Troubleshooting

Issue	Solution
Sidebar does not appear	Verify the extension is installed via Extensions → Add-ons → Manage add-ons. Ensure you are signed in with the same Google account used during installation.
API key not accepted	Check that the key has Metrics Read permission and has not expired. Generate a new key in ProfitMetrics if needed.
Data appears in wrong number format	The export uses US numerical format. Go to File → Settings → General → Locale and set to United States.
Missing metrics or empty columns	New KPIs added to the ProfitMetrics dashboard may have a short delay before they are available in the Google Sheets extension. Also, ensure that the data is available in the dashboard.
Schedule not running	Google Sheets triggers require the spreadsheet to be associated with an active Google account. If the sheet owner's account is inactive, schedules may stop. Re-open the sheet and re-save the schedule.
Error when loading sidebar	If you see an error code from Google when loading the extension this is likely due to insufficient permissions. Remove the add-on, re-install and ensure you check the boxes during the setup to give Google the required permissions.