Docs

ETCMC Documentation

API Reference & Integration Guides

Status Tutorials Documentation Support

Excel & Google Sheets Integration

Get your node information directly in Excel or Google Sheets without using Telegram.

Get Your Token

Go to your account page to get your API token. If you don't have one yet, it will be generated for you.

https://etcmc-monitor.org/account_update

API Endpoint

Use this API URL with your token to get node information in JSON format.

https://etcmc-monitor.org/api/nodes_info_excel?token=YOUR_TOKEN_HERE

For Excel Users

Open Excel
Go to Data → Get Data → From Web
Paste the API URL with your token
Click OK - your nodes will appear in a table

For Google Sheets Users

First, you need to create a custom function to import JSON data:

function IMPORTJSON(url) {
  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());
  var headers = Object.keys(json[0]);
  var data = json.map(row => headers.map(header => row[header]));
  data.unshift(headers);
  return data;
}

Then in any cell, use this formula:

=IMPORTJSON("https://etcmc-monitor.org/api/nodes_info_excel?token=YOUR_TOKEN_HERE")

Your nodes will automatically appear in the sheet as a formatted table.

API Endpoints

Complete list of available API endpoints for the ETCMC client.

POST /login

POST /logout

Log out of the session

POST /change_credentials

Change your login credentials

GET/POST /api/parameters

Get or update system parameters

GET /get_claim_estimated_time

Get estimated time before next claim

GET /delete-chain-data/confirm

Delete blockchain data

GET /register/delete/confirm

Delete node registration (via GET)

GET /register/check_status

Check if node is registered

GET /save_port/confirm

Save the port number used by the node (via GET). To use, make a GET request to this route with the port number as a query parameter. Example: /save_port/confirm?port=30303

GET /get_port

Get the current saved port

GET /system_usage

Get CPU/RAM/disk usage statistics

GET /geth_output

Fetch current Geth output logs

GET /statistics

Retrieve system or claim statistics

POST /claim/confirm

Trigger ETCPOW claim

GET /balance

Get current ETCPOW token balance

GET /stop_node/confirm

Stop the Geth node (via GET)

GET /start_node/confirm

Start the Geth node (via GET)

GET /get_auto_start_status

Get current auto-start setting

GET /api/geth/status

Get current geth status

GET /get-enode

Get current Enode

GET /api/token

Get Registration Token

POST /toggle_auto_start/confirm

Enable or disable auto-start on boot. To use, send a POST request to this route to toggle the status.

Next Post Previous Post