Log on-chain activity to Google Sheets (NO-CODE)
In this tutorial, we’ll show you how to create a historical activity log for on-chain (Web3) data in Google Sheets, without writing a single line of code.
Using Dispatch webhooks and Zapier, you can automatically send on-chain activity data to all kinds of apps.
No more endless block explorer checks and lost time. This is great for:
• Logging NFT and other smart contract activity as it happens
• Getting actionable data & insights
• Sending Web3 data to Web2 apps and services
We hope you enjoy this tutorial, and if there are other things you want to learn, let us know in the comments!
—-------------------------------
🔗 Helpful links:
—-------------------------------
Google Sheets template: https://docs.google.com/spreadsheets/...
Step-by-step guide: https://blog.esprezzo.io/automaticall...
----------------------------------------------------------
⏰ Timestamps:
----------------------------------------------------------
0:00 Intro
0:31 Getting started
1:28 Setting up column headings in Sheets
2:01 Creating your Patch in Dispatch
4:03 Start creating a Zap in Zapier
4:24 Adding Zapier webhook URL to Dispatch
5:56 Connecting Google Sheets to Zapier
6:35 Filling in and saving the data to Google Sheets
8:25 Turning your Patch on
9:04 Creating charts based on on-chain activity
9:33 Outro
----------------------------------------------------------
👀 Resources:
----------------------------------------------------------
Get early access to Dispatch: https://dispatch.esprezzo.io/signup
Esprezzo Docs: https://docs.esprezzo.io/
Website: https://esprezzo.io/
__________________________
Come say hi 👋
Twitter: / esprezzoapp
Discord: / discord
Linkedin: / esprezzo-app
__________________________
For more videos like this, subscribe to our channel: / @esprezzo