Automate License Key Delivery with Pabbly Connect: A Step-by-Step Guide

Learn how to automate license key delivery from Google Sheets to Shopify using Pabbly Connect in this detailed tutorial. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating license key delivery, access Pabbly Connect by visiting the official website. You can sign up for a free account or log in if you are an existing user. Once logged in, you will be directed to the dashboard where all your workflows are displayed.

After logging in, click on the ‘Create Workflow’ option to begin. You will be prompted to name your workflow. For this tutorial, name it ‘Send License Key on Shopify Order from Google Sheets’ and select the appropriate folder for organization.

2. Setting Up Trigger with Shopify in Pabbly Connect

In this step, we will set up the trigger in Pabbly Connect to capture new orders from Shopify. Select Shopify as the trigger application and choose the trigger event as ‘New Order.’ This event will initiate the workflow whenever a new order is placed.

• Select ‘New Order’ as the trigger event.
• Copy the provided webhook URL.
• Log into your Shopify account and navigate to Settings > Notifications.
• Create a new webhook using the copied URL.

Once the webhook is created in Shopify, Pabbly Connect will be ready to receive data from Shopify whenever a customer places an order.

3. Filtering Orders for Specific Products

Next, we need to filter the orders to ensure that only the correct product triggers the license key delivery. In Pabbly Connect, add a filter step after the Shopify trigger. This filter will check if the purchased product is the software requiring a license key.

• Select ‘Filter’ as the action application.
• Set the condition to check if the product name equals ‘PAB Audio Extractor.’
• If true, proceed to the next action; otherwise, stop the workflow.

This filtering ensures that only relevant orders prompt the delivery of license keys, maintaining the integrity of your workflow in Pabbly Connect.

4. Sending License Key via Gmail

After filtering, the next action is to send the license key to the customer via Gmail. In Pabbly Connect, select Gmail as the action application and choose the ‘Send Email’ event. This will allow you to send personalized emails to customers with their license keys.

Map the recipient’s email address from the Shopify order response. Set the email subject and content, including the mapped license key. Test the email to ensure it is sent correctly.

By utilizing Pabbly Connect, you can automate the entire email sending process, ensuring customers receive their license keys immediately after purchase.

5. Updating Google Sheets with License Key Status

The final step in our automation workflow is to update Google Sheets with the status of the license keys. In Pabbly Connect, add Google Sheets as the action application and select the ‘Update Row’ event. This will allow you to mark the license key as linked and update the customer’s email address.

Select the spreadsheet containing the license keys. Map the row index of the license key that was sent. Update the status to ‘Linked’ and add the customer’s email address.

This ensures that your records in Google Sheets remain accurate and up-to-date, all facilitated through Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate the delivery of license keys from Google Sheets to Shopify using Pabbly Connect. By setting up triggers, filters, and actions, you can streamline the entire process without any coding. This integration not only saves time but also enhances customer satisfaction by ensuring timely delivery of software licenses.