Google Sheets Integration

Importing Coin Metrics Data to Google Sheets

Where our Coin Metrics API includes a csv format option data can be directly loaded into google sheets.

To do this input you API call into the =IMPORTDATA() formula.

Below is an example Once included there is warning that requires you to allow access: steps for setting this up yourself

1. Open a new google sheet

2. Add API Parameters to cells in columns A and add results to column B

   1. Example using time series asset-metrics endpoint

A	B
API KEY	{API_KEY}
ASSETS	btc
METRICS	PriceUSD
PAGE SIZE	1000
START TIME	2025-01-01T00:00:00Z
END TIME	2025-01-31T00:00:00Z
PAGING FROM	end
FREQUENCY	1d

1. Leverage this formula for creating your API Query

= "https://api.coinmetrics.io/v4/timeseries/asset-metrics?" &
"api_key="& B1 &
"&assets=" & B2 &
"&metrics=" & B3 &
"&page_size=" & B4 &
"&start_time=" & B5 &
"&end_time=" & B6 &
"&paging_from=" & B7 &
"&frequency=" & B8 &
"&format=csv"

1. In a new cell enter: =IMPORTDATA({Cell with API Call})

At this point you will see a warning where you need to allow access for the API Call

Example results: