Learn how to automate the process of sending license keys from Google Sheets after a Thrive Cart sale using Pabbly Connect in this detailed tutorial.

Watch Step By Step Video Tutorial Below


1. Accessing Pabbly Connect for Automation

To start automating the process of sending license keys, you first need to access Pabbly Connect. Simply go to the Pabbly website and log in to your account. If you are a new user, you can sign up for a free account to explore the features offered by Pabbly Connect.

Once you are logged in, navigate to the Pabbly Connect dashboard. Here, you will find the option to create a new workflow. Click on the ‘Create Workflow’ button and name your workflow appropriately, such as ‘Send License Key on Thrive Cart Sale from Google Sheets’. This sets the stage for your automation process.


2. Setting Up the Trigger in Pabbly Connect

In this section, you will configure the trigger application using Pabbly Connect. For our automation, select Thrive Cart as the trigger application. This means that every time a product is purchased, it will trigger the workflow.

  • Select ‘Thrive Cart’ as the trigger application.
  • Choose ‘Product Purchase’ as the trigger event.
  • Connect your Thrive Cart account by entering the API key.

After setting the trigger, proceed to test the connection to ensure it captures data correctly. This step is crucial as it lays the foundation for the subsequent actions in your workflow.


3. Configuring Action Steps with Google Sheets

Next, you will set up the action application using Pabbly Connect to fetch the license keys from Google Sheets. Select Google Sheets as the action application to retrieve the unique license key for the purchased product.

For this, choose the action event as ‘Lookup Spreadsheet Row’. This allows you to search for the license key associated with the customer’s email address. Follow these steps:

  • Connect your Google Sheets account.
  • Select the spreadsheet containing your license keys.
  • Map the lookup value to the email address from the trigger step.

By configuring these actions, you enable Pabbly Connect to dynamically retrieve the correct license key based on the customer’s purchase, streamlining the entire process.


4. Sending License Keys via Gmail

Now that you have the license key, it’s time to send it to the customer using Gmail through Pabbly Connect. Select Gmail as the action application and choose ‘Send Email V2’ as the action event.

In this step, map the recipient’s email address from the previous step, and customize the email content. Here’s how to do it:

Map the recipient email to the email captured from the Thrive Cart purchase. Set the email subject to something like ‘Your License Key for Pap Audio Extractor’. Include the license key in the email body.

Once you’ve set up the email details, test the action to ensure that the email is sent successfully to the customer. This integration allows for immediate delivery of the license key, enhancing customer satisfaction.


5. Updating Google Sheets Status

The final step in this workflow involves updating the Google Sheets status to reflect that the license key has been sent. Using Pabbly Connect, select Google Sheets again as the action application and choose ‘Update Row’ as the action event.

Here, you will need to map the row index of the license key that was sent. Additionally, update the status to ‘Linked’ and add the customer’s email address. Follow these steps:

Select the same spreadsheet used earlier. Map the row index dynamically from the previous lookup step. Update the status to ‘Linked’ and add the customer email.

After testing this action, you will see that the Google Sheets is updated automatically, ensuring all records are accurate and up-to-date. This finalizes your automated workflow using Pabbly Connect.


Conclusion

In this tutorial, you learned how to automate the sending of license keys using Pabbly Connect, Thrive Cart, and Google Sheets. By following these steps, you can streamline your sales process and ensure customers receive their keys instantly, enhancing their overall experience.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.