Skip to content

Instantly share code, notes, and snippets.

@cordt-sei
cordt-sei / EVMSheet.md
Created April 8, 2025 22:45
Google Sheets App Script to fetch EVM contract and token infos as available from some block explorer API

Template/Example sheet can be found here. Contributions welcome. Fork this gist and edit it then send it back or something I guess. (Why are gists forkable? Has anyone ever really used this?)

////////////////////////////////////////////////////////////////////////////////
// Contract Info Fetching & Updating Script for Google Sheets
// -----------------------------------------------------------
// This script helps fetch contract metadata (Name, ABI, Symbol, Decimals)
// for each row in a Google Sheet that has a contract address.
//
#!/bin/bash
# Enhanced initialize_local_chain.sh with multiple setup options
# This script provides various options for setting up Sei local environments
set -e
# Color codes for better output
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
RED='\033[0;31m'
{
"tx": {
"body": {
"messages": [
{
"@type": "/seiprotocol.seichain.evm.MsgEVMTransaction",
"data": {
"@type": "/seiprotocol.seichain.eth.LegacyTx",
"nonce": "45",
"gas_price": "100000000000",
{
"code": 3,
"message": "encoding/hex: invalid byte: U+0026 '&': invalid request",
"details": []
}
{
"tx": {
"body": {
"messages": [
{
"@type": "/seiprotocol.seichain.evm.MsgEVMTransaction",
"data": {
"@type": "/seiprotocol.seichain.eth.LegacyTx",
"nonce": "46",
"gas_price": "100000000000",
@cordt-sei
cordt-sei / 01-instructions.md
Last active February 6, 2025 18:29
seid atlantic configs

Ez Setup

Before starting - ensure you have stopped the seid process:

systemctl stop seid

1. Navigate to the ~/.sei directory and import these configs + statesync script

{
"jsonrpc": "2.0",
"id": 1,
"result": {
"from": "0xa9d3338b983cb663c6aa85ca49d56c096670254f",
"gas": "0x989680",
"gasUsed": "0x20556",
"to": "0x6b6425affd12fadede75f159cf0c497e7587219a",
"input": "0xffe221170000000000000000000000009c1cb740f3b631ed53600058ae5b2f83e15d9fbf0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000",
"calls": [
{
"jsonrpc": "2.0",
"id": 1,
"result": {
"from": "0xa2439545c6cd0d6b0679cbbbbc6ce7921ed8d9c9",
"gas": "0x989680",
"gasUsed": "0x29599",
"to": "0x7db59594d8382100357d7e7923f5af9528b82ec3",
"input": "0xffe22117000000000000000000000000152b9d0fdc40c096757f570a51e494bd4b943e500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000000a590b1b5f948398cb9f97548f1a0d748de656f0820e8daa14dc631b7e3b0a2d66297f6ebaf98284e243c59f6672763f34dacc7cff3a3a225c2272e57df75b9d64f03e7c24a05bf44ef54114582209d81a23bac0bd877422066fc0f6e117d990961314b73e990811a18bd9c898556e68244587df288e94d92f1eb1a9ea1dbb05f6826994a0837fdcbee957c044f6798e0b45f5637eb07d92896a4dd41c61bf0079bfbd0573634f8f3cc94bc4bee8b7215b53aef0c1975c5a695873e470ab8cebd6bb8367850cb7699666e5814583b6974d8f57eeaff76c1d86158e55e7eb15e44bcfa30d86553dd7273bcdea
{
"jsonrpc": "2.0",
"id": 1,
"result": []
}
{
"hash": "3F92A485F787B631ACCFA4908F6EB707AEB01246C2EAAF08D39400F6C16836BF",
"height": "127093764",
"index": 36,
"tx_result": {
"data": "CiYKJC9jb3Ntd2FzbS53YXNtLnYxLk1zZ0V4ZWN1dGVDb250cmFjdA==",
"log": "[{\"events\":[{\"type\":\"execute\",\"attributes\":[{\"key\":\"_contract_address\",\"value\":\"sei10nulnfpdhx2wf7lp9kqa8aez2yxuyxwjyfw9rzlrexd500nhal0sl7mtzm\"}]},{\"type\":\"message\",\"attributes\":[{\"key\":\"action\",\"value\":\"/cosmwasm.wasm.v1.MsgExecuteContract\"},{\"key\":\"module\",\"value\":\"wasm\"},{\"key\":\"sender\",\"value\":\"sei15pz333htntschjk0mu89m7rmetduemvdvpl4cr\"}]},{\"type\":\"wasm\",\"attributes\":[{\"key\":\"_contract_address\",\"value\":\"sei10nulnfpdhx2wf7lp9kqa8aez2yxuyxwjyfw9rzlrexd500nhal0sl7mtzm\"},{\"key\":\"action\",\"value\":\"transfer_nft\"},{\"key\":\"sender\",\"value\":\"sei1n5n56lvfsda29hm38a2tn5pnf6nx84a3kje530\"},{\"key\":\"recipient\",\"value\":\"sei1n5n56lvfsda29hm38a2tn5pnf6nx84a3kje530\"},{\"key\":\"token_id\",\"value\":\"0\"},{\"key\":\"action\",