Track a wallet activity on a Googlesheets using Starton and Zapier
In this tutorial, we will create a tracker for wallet with Starton and Zapier. We will start by creating a webhook on Zapier, adding the URL in a watcher on Starton, to populate a Googlesheets on Google Drive.
You will need:
Create a webhook
From Starton, go to Tools.
Click on the Zapier card.
Log in with your Zapier credentials.
Accept Invite & Build a Zap.
In Trigger, select
Catch Raw Hookand click to
Zapier provides you with a
Webhook URL. We will need this URL in our Watcher on Starton.
Creating a watcher in Starton
In Starton, go to
Type of notificationand click
Next. You can use
Address Activityto track when an address receives base currency or creates a transaction. For more information, check out Available event types.
Enter the watcher's
Select the blockchain on which you want to track the wallet (for example, we use Binance Smart Chain testnet ).
Wallet Addressthat you need to track.
Copy the URL and paste in
Enter the number of
Confirmations Blocksto wait before receiving the notification. More information on confirmation blocks.
For this example we use BSC Testnet, so we use 48 confirmation blocks.
Testing the trigger
To test, the webhook and the watcher, we need to send currency to the wallet to trigger for an activity event.
Transfer tokens to the wallet you need to watch. This will trigger an event in your watcher.
Wait for the number of
Come back to Zapier and click
If it's successful, you will read
We found a request!.
Configure the googlesheets
In Zapier, select an
For this integration, select
Create Spreadsheet Rowand click
Link your Google Sheets account.
Select your Google Sheets account.
Google Drive, go to your Google Sheets.
Create a new Google sheets.
In Zapier, enter your
Worksheet, for this example we use
On your Google sheets, create a header in cell A1, and type
Your event name, for this example
On Zapier, you can view the
Event nametyped in
Your event namein the Google Sheets.
Select the data you want to save in your google sheets.
Test action. If successful, you can see your data in your google sheets.
Now you can save your zap.
Congratulations! The activity of your wallet is now tracked on a Googlesheets.