Quickly Scrape Ethereum Wallets using Node.js

Scrape from Google Drive using Node.js, Typescript & ethers.js

If you’ve been in NFTs or Sh*tcoins, there’s no doubt you will have come across Allowlists/Waitlists for Token presales or a new NFT mint. As a developer who has helped several NFT projects in the past and is now building his own, I have noticed that there is no easy solution for tracking all the wallets that get accumulated in a single or multiple Google Sheets. If the list is small and is in one Google Sheet, you can get away with simply copy pasting the list into a json file. However if you are a dev for a big project like us, you likely have a spreadsheet that has links to many other wallets, something that looks like this:

Now, you can’t/shouldn’t expect your collab manager(s) to go through each sheet individually and copy paste the wallet addresses into a single sheet. Phew. I’m tired just thinking about it. But as devs we can find quicker ways 😄.

Here’s a 3 step guide on how to automate this process:

1. Create your Google Service Account Key

Go to: https://console.cloud.google.com/. Click on “New Project”: