Last updated by Jamiu Idowu a month ago
Now, let’s get started with Part 1.
If you don’t have a Zapier account already, you need to create one. Not confident in your Zapier skills yet? Check out this collection of 2-min videos on the Zapier essentials, from the Zapier University. You can skip it if you know how to use Zapier already.
From your Zapier dashboard, click create a Zap. Connect Grindery Web3 Gateway to Google Sheets ( select Create Spreadsheet Row). Next, you should have the following page.
Once you click on Trigger, the next step is to choose an account. If you have already connected your Grindery Gateway account to Zapier, you can choose the account directly. However, if you don’t have a Gateway account, you will be automatically taken to a page where you can create one as shown in the figure below.
Afterwards, click Continue. Now, you can complete setting up your trigger. For Grindery Driver, select Wallet (EOA) on EVM Chains. Similarly, select New Transaction for Driver Trigger. Next, choose Blockchain; we are selecting Binance for our example. Finally, add the recipient’s EVM address. You may not add any Sender address as what you want to detect is a deposit transaction. A fully setup trigger looks like the following figure. Click on Continue.
Now test the trigger. If all goes well, you should get the following result. Click Continue to proceed.
Make a copy of this Google Sheet template and have it saved in your Google Drive. The next step is to set up your action on Zapier. To do this, you need to select Create Spreadsheet Row (if you have not done that before) and connect your Google Sheets account. Then, select the s preadsheet template you just initially. You should see the fields from the sheet as shown below. Click on each field and select the corresponding data from the options provided (click Show all options to see all the data available). For instance, for TX ID, we are selecting Data hash and for credit amount, we are selecting value. Note, we are leaving the debit amount, chain ID and any other field for now. Finally, click continue, then Test Action. Boom! You should see the two transaction details on your Google Sheets now.
That’s all! Go back to the course page to proceed to Part 2 .