Google Sheets x Venly
This step-by-step guide explains how to mint and distribute NFTs, using Google Sheets.
Scenario Explained
In this guide, we will be working with the Venly and Google Sheets integration on Zapier
We will create an automated workflow such that whenever the Stage column is updated in the table, an NFT will be minted and sent to the email or wallet address. The automated workflow takes care of minting and sending the NFT to an email or wallet address.
End Result
You enter the NFT mint details in the table and update the Stage column to Mint NFT. This triggers the zap, and the NFT minting process starts. In a few minutes, the NFT is minted and sent to the specified wallet/email address.
As a result, the NFT is minted and sent to the wallet address or email:
Prerequisites
- You should have completed the onboarding with Zapier.
- You should have an NFT contract/collection already created.
- You should have an account on Google Sheets. If not, click here to sign up.
Configuring Zapier with Venly & Google Sheets
1. Configure Google Sheets
We have created an NFT minting template sheet for you. Open the Google sheet by clicking here, then click on File and Make a copy.
Rename the sheet if you want and finally click on Make a copy to save it to your drive.
1.2 Configure Google Sheets trigger on Zapier
- Head over to your Zapier dashboard and click on + Create Zap.
- Click on the Trigger , search and click on Google Sheets
- Select the trigger event as New or Updated Spreadsheet Row and continue
- Connect your Google Sheets account with Zapier (A pop-up window will appear where you need to log in to your Google Sheets account.) When done, click on Continue.
- Next, in the Configure section, select your Spreadsheet(which you just made a copy of), Worksheet, select the Trigger Column as Stage and continue. (this indicates that the trigger column for the zap will be the Stage column)
- You can skip the Test trigger, that's it for configuring Google Sheets with Zapier.
2. Configure Venly Action on Zapier
- Next, we need to add the action
- Click on Action
- Search and click on Venly
- Choose the action event as Create and Mint NFT and continue
- Next, add your Venly account to Zapier. Your account should already be visible if you previously created your contract. Read how to add Venly account on Zapier.
3. Configure the action fields:
Basic fields (need to be set up manually)
- Blockchain: First, select the blockchain of your NFT contract from the drop-down list.
- Contract: Your existing NFT contracts will be displayed here based on the blockchain selected. Choose the NFT contract from the drop-down list. Learn how to create an NFT contract with Zapier.
- Fungible: Next, manually set the Fungible property to False. (This means you will be minting NFTs)
Configure required fields
- Name: This is the name of the NFT. You can mint customized NFTs by adding a message and then merging it with the end-user's name. In this example, we have configured the Name as the Name column from Google Sheets. Click on the + icon and then select the column name you want to map with. This will autofetch the data from your selected column.
- Description: Add a customized message in the description for the NFT. Similarly, configure this field with the Description column.
- Image URL: The image URL for the NFTs. Similarly, configure this field with the Image URL column.
- External URL: This can be a link to your website or anything. Similarly, configure this field with the External URL column.
- Mint Address: This is the wallet/email address where the NFT will be sent. Similarly, configure this field with the Mint Address column.
- Mint Amount: This is the number of NFTs you want to mint. Similarly, configure this field with the Mint Amount column.
Optional fields
- Max Supply: This is the maximum number of NFTs that can be minted. You can configure the NFT supply to 1,2 10, 100, etc. Similarly, configure this field with the Max Supply column.
- Attributes: Pass an array of JSON objects to add attributes. Learn about attributes. Similarly, configure this field with the Attributes column.
- Once you have every field configured, click on Continue.
- Click on Skip test and then Publish.
Testing the integration
Now that your zap is live, you can continue with testing. Open your sheet and start adding data in the rows. The first row already has some data prefilled. Start by adding the name, description, etc in the row. Once you have all the boxes filled, continue by changing the Stage to Mint NFT. This is the trigger for your zap and in a few minutes, your NFT will be minted and sent to the specified address.
You can verify the NFT mint by going to Zap History. As you can see the NFT mint is indicated as succeeded.
Minted NFT
Updated 27 days ago