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.
Click
Accept Invite & Build a Zap
.Click
Create Zap
.In Trigger, select
Webhook
.In
Event
, selectCatch Raw Hook
and click toContinue
.
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
Monitor
.Click
+ Watcher
.Select a
Type of notification
and clickNext
. You can useAddress Activity
to track when an address receives base currency or creates a transaction. For more information, check out Available event types.Enter the watcher's
Name
andDescription
. ClickNext
.Select the blockchain on which you want to track the wallet (for example, we use Binance Smart Chain testnet ).
Enter the
Wallet Address
that you need to track.Copy the URL and paste in
Webhook URL
.Enter the number of
Confirmations Blocks
to wait before receiving the notification. More information on confirmation blocks.
For this example we use BSC Testnet, so we use 48 confirmation blocks.
- Click
Create
.
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
Confirmations Block
configured.Come back to Zapier and click
Test trigger
.
If it's successful, you will read We found a request!
.
- Click
Continue
.
Configure the googlesheets
In Zapier, select an
Action
.For this integration, select
Google Sheets
.In
Event
, selectCreate Spreadsheet Row
and clickContinue
.Link your Google Sheets account.
Select your Google Sheets account.
Click to
Continue
.
In
Google Drive
, go to your Google Sheets.Create a new Google sheets.
In Zapier, enter your
spreadsheet
.Select a
Worksheet
, for this example we useSheet1
.On your Google sheets, create a header in cell A1, and type
Your event name
, for this exampleADDRESS_ACTIVITY
.On Zapier, you can view the
Event name
typed inYour event name
in the Google Sheets.Select the data you want to save in your google sheets.
Click
Continue
.
Click to
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.