This tool is used to analyze the mempool and send the data to a local CSV file and to a Google Sheet for graphing. The script runs at a 30s interval.
You will need to follow the steps here to generate a credentials.json file.
Next, you will need to update the spreadsheet ID in app.js if you will be writing to a different sheet. This ID can be copied from the URL of the spreadsheet:
https://docs.google.com/spreadsheets/d/{SPREADSHEET-ID-HERE}/edit#gid=0
Replace the value in the initialization of SPREADSHEET
with the appropriate
value for your sheet:
const SPREADSHEET = "1vzZM3k7VkWMbWmU3-AbcNY8DcVpGxu5c-MNqYRKSWrQ";
To run the script, simply run:
./collect.sh
On first run, a browser window will pop up to authorize the access to Google Docs.
Changes should begin showing up in the spreadsheet every 30 seconds, and also in the local file, mempool.csv.