Here is what you wrote:
var range = ss.getSheets()[0].getRange("A1:A1");
var url = 'https://multipool.us/api.php?api_key=<12345_MYAPI_KEY_6789>';
var content = UrlFetchApp.fetch(url).getContentText();
var mydata = Utilities.jsonParse(content);
/* LTC */
var datacut = mydata['currency']['ltc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
var range = ss.getSheets()[0].getRange("A2:A2");
var mydata = Utilities.jsonParse(content);
var datacut = mydata['currency']['ltc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
var range = ss.getSheets()[0].getRange("A3:A3");
var mydata = Utilities.jsonParse(content);
var datacut = mydata['currency']['ltc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
Sounds like you don't have much experience with json, I'll make this simple for you. Above that section in your script put this:
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Refresh", functionName: "onOpen"} ];
ss.addMenu("Update", menuEntries);
Then at the end you need to close the function with }
Now, lets say you want to pull your balances off of multipool -- then your entire code would look like this:
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Refresh", functionName: "onOpen"} ];
ss.addMenu("Update", menuEntries);
var range = ss.getSheets()[0].getRange("A1:A1");
var url = 'https://multipool.us/api.php?api_key=<12345_MYAPI_KEY_6789>';
var content = UrlFetchApp.fetch(url).getContentText();
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['ltc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C41:C41");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['ltc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E41:E41");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['ltc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B42:B42");
var price = ticker['currency']['nvc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C42:C42");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['nvc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E42:E42");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['nvc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B43:B43");
var price = ticker['currency']['ftc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C43:C43");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['ftc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E43:E43");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['ftc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B44:B44");
var price = ticker['currency']['mnc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C44:C44");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['mnc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E44:E44");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['mnc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B45:B45");
var price = ticker['currency']['wdc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C45:C45");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['wdc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E45:E45");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['wdc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B46:B46");
var price = ticker['currency']['dgc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C46:C46");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['dgc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E46:E46");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['dgc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B47:B47");
var price = ticker['currency']['lky']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C47:C47");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['lky']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E47:E47");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['lky']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B48:B48");
var price = ticker['currency']['arg']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C48:C48");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['arg']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E48:E48");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['arg']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B49:B49");
var price = ticker['currency']['pxc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C49:C49");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['pxc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E49:E49");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['pxc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B50:B50");
var price = ticker['currency']['mec']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C50:C50");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['mec']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E50:E50");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['mec']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B51:B51");
var price = ticker['currency']['cap']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C51:C51");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['cap']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E51:E51");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['cap']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("B52:B52");
var price = ticker['currency']['cgb']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("C52:C52");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['cgb']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
var range = ss.getSheets()[0].getRange("E52:E52");
var ticker = Utilities.jsonParse(content);
var price = ticker['currency']['cgb']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
}
You'll have to change the getRange values to fit your needs. This will give you the confirmed rewards, estimated rewards and your current hash rate on whichever coin you are mining.. Some of the code is unneeded, but I generated it with a different script instead of rewriting each coin.