1. Visit the CoinMarketCap website and sign up for an account if you haven’t already.
2. Navigate to the API section and request an API key.
3. Once you have your API key, note it down securely as you’ll need it to access the API.

1. Open Google Sheets and create a new spreadsheet or use an existing one.
2. Decide on the structure of your data and set up the columns accordingly. For example, you might have columns for ‘Symbol’, ‘Price’, ‘24h Volume’, etc.

1. In your Google Sheets, click on “Extensions” in the top menu and then select “Apps Script”.
2. A new tab will open with the Apps Script editor. Here, you’ll write the code to fetch data from CoinMarketCap’s API.
3. Replace any existing code with the following script (customize it according to your needs):

const COINMARKETCAP_API_KEY = 'your_api_key_here';
const API_URL = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest';

function importCoinMarketCapData() {
 const options = {
   'method' : 'GET',
   'headers' : {
     'X-CMC_PRO_API_KEY': COINMARKETCAP_API_KEY,
   }
 };
 
 const response = UrlFetchApp.fetch(API_URL, options);
 const json = response.getContentText();
 const data = JSON.parse(json);
 
 const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 sheet.clearContents(); // Optional: Clear the existing data
 
 const rows = [];
 
 // Assuming you want to get the symbol and price for each cryptocurrency
 data.data.forEach(function(currency) {
   const symbol = currency.symbol;
   const price = currency.quote.USD.price;
   rows.push([symbol, price]);
 });
 
 // Write data to the first and second column, starting from the second row
 sheet.getRange(2, 1, rows.length, 2).setValues(rows);
}

// Optionally, create a custom menu to run the script from the Google Sheets UI
function onOpen() {
 const ui = SpreadsheetApp.getUi();
 ui.createMenu('CoinMarketCap')
   .addItem('Import Data', 'importCoinMarketCapData')
   .addToUi();
}


4. Replace 'your_api_key_here' with the API key you obtained from CoinMarketCap.
5. Customize the API_URL and the data processing part (data.data.forEach...) to fetch the specific information you want.
6. Click on the disk icon or “File” > “Save” to save the script.

1. Click on the play button (▶️) in the Apps Script editor to run the importCoinMarketCapData function.
2. The first time you run the script, you’ll need to authorize the script to access your Google Sheets data. Follow the prompts to grant the necessary permissions.

1. If you want to automatically update the data at regular intervals, click on the clock icon (⏲️) in the Apps Script editor to create a trigger.
2. Click on “+ Add Trigger” in the bottom right corner.
3. Set the function to run (importCoinMarketCapData), the deployment (Head), the event source (Time-driven), and the timing (e.g., every hour).

1. Refresh your Google Sheets page.
2. You will now see a new menu item called ‘CoinMarketCap’ in the toolbar.
3. Click on it and select ‘Import Data’ to manually run the script and import the latest data.