Skip to content

Simple script to dump ETH/DAI transactions into Google Sheet

Notifications You must be signed in to change notification settings

troggy/eth-sheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

eth-sheets

Simple script to dump ETH/DAI transactions into Google Sheet

Install

  1. Create service account to access Google Sheets: https://cloud.google.com/iam/docs/service-accounts. You will need email for it and private key
  2. Create spreadsheet (may be blank or use the reference https://shrtco.de/leap-treasury)
  3. Give service account write access to your spreadsheet (Share → add account's email)
  4. Clone this repo
  5. yarn
  6. Set ENV variables in .env file:
    • ES_API_KEY — Etherscan API key
    • EMAIL — email for Google Drive service account
    • PRIVATE_KEY — private key for Google Driver service account
    • SPREADSHEET_ID — Google Spreadsheet ID to write data to
  7. Inside the script:
    • setup wallet(s) to scan
    • adjust block heights to scan from
    • adjust DAI/ERC20 contract address if needed
  8. (optional) add known addresses to knownAddresses.json
  9. Run itnode src/

Reference spreadsheet

LeapDAO treasury:

Nothing is mandatory. Import could be done in the blank vanilla google sheet, just the name of the list should match the one from the script

Roadmap

  • Basic import of ethereum transactions (incoming/outgoing)
  • Basic import of ERC20/DAI transactions
  • Protection against duplicate imports
  • Integration with Gnosis Multisig
  • Source extra metadata from bounty spreadsheets (bounty payout goes through google/netlify form, script reads it)
  • Integration with Gnosis Safe
  • Get away from using Google products

About

Simple script to dump ETH/DAI transactions into Google Sheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published