Automate License Key Delivery with Pabbly Connect, Stripe, and Google Sheets

Learn how to automate license key delivery using Pabbly Connect, Stripe, and Google Sheets. Step-by-step tutorial for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating license key deliveries, begin by accessing Pabbly Connect. This platform allows you to connect different applications seamlessly. First, sign in to your Pabbly Connect account, or create a new one if you are a first-time user.

After logging in, you will see the dashboard. From here, select Pabbly Connect by clicking on ‘Access Now’. This leads you to the workflow creation area where you can set up your automation process.

2. Creating a Workflow in Pabbly Connect

Once you are in Pabbly Connect, click on the ‘Create Workflow’ button located in the top right corner. A dialog box will appear asking for a workflow name and folder selection.

• Enter the workflow name: ‘Send License Key on Stripe Payment from Google Sheets’
• Select a folder to save the workflow, such as ‘Stripe’.

After entering the details, click ‘Create’. You will see two sections: Trigger and Action. The Trigger is what starts the workflow, and the Action is what happens as a result.

3. Setting Up Trigger in Pabbly Connect

For the trigger application, select Pabbly Connect as your platform to capture Stripe payments. Choose the event as ‘New Charge’ to ensure it activates when a payment is made.

Pabbly Connect will provide you with a webhook URL. Copy this URL to link Stripe with Pabbly Connect. Go to your Stripe account, navigate to the Developers section, and click on Webhooks.

• Click on ‘Add Endpoint’ and paste the copied webhook URL.
• Set the event to ‘Charge Succeeded’ and click ‘Add Event’.

After completing these steps, return to your workflow in Pabbly Connect to confirm it is waiting for a webhook response.

4. Action Steps in Pabbly Connect

Next, you will set up the action steps in Pabbly Connect. First, use the Filter feature to ensure only valid payments are processed. Select ‘Filter by Pabbly’ and set the conditions based on the payment amount.

Once the filter is applied, you will add another action step to retrieve the unique license key from Google Sheets. Choose ‘Google Sheets’ as the application and ‘Lookup Spreadsheet Row V2’ as the action event.

Connect to your Google Sheets account and select the spreadsheet containing the license keys. Set the lookup value to ‘Not Linked’ to find an available license key.

After setting this up, you will receive the unique license key that can be sent to the customer.

5. Sending License Key Email via Pabbly Connect

Now it’s time to send the license key to your customer via email. For this, select ‘Gmail’ as your action application in Pabbly Connect and choose ‘Send Email V1’ as the action event.

Authorize your Gmail account and fill in the recipient’s email address using the mapped data from the previous steps. Set the email subject to ‘Your Software License Key for PAB Audio Extractor’.

Compose the email body, including a thank you note and the unique license key. Finally, send a test email to ensure everything is working correctly.

After sending the email, check your Gmail account to confirm that the email has been received with the correct license key.

Conclusion

In this tutorial, we demonstrated how to automate the delivery of license keys using Pabbly Connect, Stripe, and Google Sheets. By setting up triggers and actions, you can streamline your software sales process effectively.

Using this integration, you can ensure that customers receive their unique license keys immediately after payment, enhancing customer satisfaction and operational efficiency.