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

Learn how to automate license key delivery using Pabbly Connect, Google Sheets, and Stripe. Streamline your business processes effectively! 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. Setting Up Pabbly Connect for Automation

To begin using Pabbly Connect, first, access the platform by signing in. If you’re a new user, you can easily sign up for a free account. Once logged in, you will see the dashboard where you can create workflows.

Click on the ‘Create Workflow’ button in the top right corner. You will be prompted to enter a name for your workflow, such as ‘Send License Key on Stripe Payment from Google Sheets,’ and select a folder for organization. After naming your workflow, click ‘Create’ to proceed.

2. Configuring Trigger Event with Stripe

The next step involves setting up the trigger in Pabbly Connect. Choose Stripe as your trigger application, and select the event as ‘New Charge’. This will allow Pabbly Connect to capture new payments made through Stripe.

• Select ‘Stripe’ as the trigger application.
• Choose ‘New Charge’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, navigate to your Stripe account. Under the ‘Developers’ section, click on ‘Webhooks’ and add a new endpoint using the copied URL. Select the event ‘Charge Succeeded’ to ensure that Pabbly Connect receives notifications for successful payments.

3. Filtering Payment Events in Pabbly Connect

Once the trigger is set up, the next step is to filter the payment events using Pabbly Connect. This is crucial for ensuring that only relevant payments are processed. Add an action step and select ‘Filter by Pabbly’ as the action application.

• Set the filter condition to check the payment amount.
• Specify the amount that matches your product pricing.

Once the filter is configured, proceed to test the filter. If the condition is met, the workflow will continue to the next steps, ensuring that only valid transactions trigger the subsequent actions.

4. Retrieving License Keys from Google Sheets

After filtering the payments, it’s time to retrieve the unique license keys from Google Sheets using Pabbly Connect. Add another action step and select Google Sheets as your action application. Choose the action event as ‘Lookup Spreadsheet Row V2’ to find the license key based on the status.

Connect your Google Sheets account and select the spreadsheet where your license keys are stored. Set the lookup value to ‘Not Linked’ to ensure that only unused keys are fetched. After configuring the lookup parameters, test this action to confirm that it retrieves the correct license key.

5. Sending License Keys via Gmail

The final step in this automation process involves sending the retrieved license key to the customer via email using Pabbly Connect. Add another action step and select Gmail as your action application. Choose the action event as ‘Send Email V1’ to initiate the email sending process.

Map the recipient’s email address from the previous response to ensure the email is sent to the correct customer. Customize the email subject and content to include the license key and relevant information. Once everything is set up, send a test email to verify that the integration works seamlessly.

Conclusion

This tutorial demonstrated how to automate the process of sending license keys using Pabbly Connect, Google Sheets, and Stripe. By following these steps, you can streamline your workflow and enhance customer satisfaction with immediate delivery of license keys upon payment.