Automating License Key Delivery with Pabbly Connect and Google Sheets

Learn how to automate license key delivery using Pabbly Connect, ThriveCart, and Google Sheets in this detailed tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin automating license key delivery, you first need to access Pabbly Connect. Open your browser and search for Pabbly Connect to reach its landing page. If you’re a new user, you can sign up for free and explore the application with 100 free tasks each month.

For existing users, click on the ‘Sign In’ button. Once you log in, you will see various Pabbly applications. Select Pabbly Connect to start creating your workflow. Click on ‘Access Now’ to enter your dashboard, where you can create a new workflow for automating license key delivery.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button, and you will be prompted to name your workflow. For this tutorial, name it ‘How to Send License Key on ThriveCart Sale from Google Sheets’ and select a folder to save it.

• Click on ‘Create’ after naming your workflow.
• You will be taken to the workflow window where you can set triggers and actions.

In the workflow window, you will define a trigger and action. The trigger is the event that starts the workflow, while actions are the tasks that follow. For this integration, select ThriveCart as your trigger application and set the trigger event to ‘Product Purchase’ to initiate the workflow when a new purchase occurs.

3. Connecting ThriveCart to Pabbly Connect

After selecting ThriveCart as the trigger application, you need to connect it to Pabbly Connect. Click on the ‘Connect’ button, and if you have an existing connection, you can select it. Otherwise, click on ‘Add a New Connection’ to enter your API key from ThriveCart.

• To get your API key, navigate to the API key section in your ThriveCart account.
• Create a new API key and copy it to use in your Pabbly Connect workflow.

Once you have entered the API key, click on ‘Save’ to establish the connection. After connecting, select the specific product (Pap Audio Extractor) for which you want to automate license key delivery. Set the product status to ‘Test Mode’ for testing purposes and save your settings.

4. Using Google Sheets to Manage License Keys

Next, you will integrate Google Sheets with Pabbly Connect to manage license keys. Add a new action step in your workflow and select Google Sheets as the action application. Choose the action event as ‘Lookup Spreadsheet Row’ to find the unique license key associated with the customer.

Connect your Google Sheets account to Pabbly Connect if you haven’t done so already. Select the spreadsheet containing license keys and specify the lookup value (the customer’s email).

After successfully mapping the details, click on ‘Save and Send Test Request’. This action will retrieve the license key from Google Sheets based on the customer’s email, allowing you to send it via email in the next step.

5. Sending License Keys via Gmail

In this final step, you will send the license key to the customer using Gmail integrated with Pabbly Connect. Add another action step, select Gmail as the action application, and choose ‘Send Email V2’ as the action event. Connect your Gmail account to Pabbly Connect and authorize the necessary permissions.

Map the recipient’s email address from the previous step to ensure the email is sent to the correct customer. Set the email subject and body, including the customer’s name and the license key.

Once you have filled in the email details, click on ‘Save and Send Test Request’. This action will send the email with the license key to the customer, completing the automation process.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the delivery of license keys from Google Sheets based on purchases made in ThriveCart. By following these steps, you can streamline your workflow, ensuring timely delivery of license keys to customers while updating your records efficiently.