Web2 Plugins (Zapier)
Google Sheet New Row

Mint NFTs from Google Sheet Responses

In this tutorial, we'll setup a no-code automation using the Owl Zapier App (opens in a new tab) to mint an NFT whenever you add a row to your Google Sheet

Prerequisites

Before you begin you should have the following

Steps

Zapier Template

Create a Zap using our one-click template (opens in a new tab) for Google Sheet & Owl Protocol Zaps. You will now configure your Zap from within the Zapier Editor

start

Configure the Google Trigger

Click on New Sheet Response in Google Sheets box to configure the Zap Trigger.

  • Account: Connect your Google Account with Zapier
  • App & Event: Set the Event to "New Spreadsheet Row"
  • Trigger: Select your Google Drive, the Google Sheet you created (eg. "Google Sheets Zapier"), and the Worskheet with your data (eg. "Mints")
  • Test: The Zap Trigger should have collected the sample row with your email (see Prerequisites)
trigger

Configure the Owl Protocol Action

💡

To use Zapier with multiple Owl Protocol projects, you can connect new accounts to Zapier using each project's API Key. You can also rename connections to match your project name to easily identify them.

Click on Mint ERC721 in Owl Protocol box to configure the Zap Action.

  • Account: Connect your Owl Protocol Account with Zapier by pasting your API Key
  • App & Event: Set the Event to "Mint ERC721"
  • Action: Configure the action parameters
    • Collection Address: If you have already deployed a collection, you will see the names and addresses of these collections in the dropdown. If not, first deploy a collection.
    • To: Use the Email output from the Google Sheet. Tokens will be sent for each row you add with an email
    • Token Template ID (optional): If you have previously created Templates, they will appear in the dropdown. If not, you can skip this.
    • Name (optional)
    • Description (optional)
    • Image (optional)
    • Attributes (optional)
  • Test: The Google Sheet Trigger should have passed down the sample submission, and testing the Owl Action should mint a new ERC721 successfully
action

Publish your Zap

After testing the Zap, publish your Zap. While it is on, it will mint an ERC721 from the selected collection to each email you add to your spreadsheet.

success

Workflow Recap

By following this guide, you have successfully set up an automated workflow that mints NFTs whenever you add a row to your Google Sheet

Additional Tips

  • Troubleshooting: If your Google Sheet responses are not triggering the Zap, double-check that the sheet is properly accessible by Zapier.
  • Customization: Fill in fields such as name, image, and attributes to personalize the NFTs. You can also create Templates in the Owl Zapier App to further customize the NFTs to meet your specific needs.

Next Steps

Explore the wide range of apps available on Zapier and experiment with Owl Protocol. Develop your own workflows to meet your specific needs, and discover creative ways to automate and enhance your Web3 experience.