Learn how to automate license key delivery for your software using Pabbly Connect with Google Sheets and Gmail in this step-by-step tutorial. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for License Key Automation

To automate license key delivery, you first need to set up Pabbly Connect. This powerful integration platform allows you to connect various applications seamlessly. Start by visiting the Pabbly Connect homepage and either sign in or create a new account.

Once logged in, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button and name it something relevant, like ‘Send License Key on Flexi Funnels Payment from Google Sheets.’ This workflow will be the backbone of your automation process.

2. Setting Up the Trigger with Flexi Funnels

In this step, you will set up the trigger application as Flexi Funnels. This is crucial because it allows Pabbly Connect to initiate the workflow whenever a new purchase is made. Select the trigger event as ‘New Purchase’ to capture the payment details automatically.

  • Select ‘Flexi Funnels’ as your trigger application.
  • Choose the event as ‘New Purchase’.
  • Copy the generated webhook URL for later use.

After setting up the trigger, you will need to configure your Flexi Funnels account to use the copied webhook URL. This ensures that every new purchase triggers the workflow in Pabbly Connect.

3. Action Steps: Extracting License Keys from Google Sheets

Next, you will set up the action step to extract the license key from Google Sheets. Select Google Sheets as your action application in Pabbly Connect. This allows you to retrieve the unique license key linked to the purchase made in Flexi Funnels.

  • Choose the action event ‘Look Up Spreadsheet Rows’.
  • Connect your Google Sheets account to Pabbly Connect.
  • Select the spreadsheet and sheet containing your license keys.

Make sure to set the lookup value to ‘not linked’ to find an available license key. This process ensures that each customer receives a unique key that has not yet been assigned.

4. Sending License Keys via Gmail

Now that you have extracted the license key, the next action is to send it to the customer via Gmail. In this step, select Gmail as your action application in Pabbly Connect. This integration allows you to send automated emails containing the license key.

Choose the action event ‘Send Email’. Map the recipient’s email address from the previous step. Craft a personalized email content including the license key.

After filling in the necessary details, click ‘Save and Send Test Request’. This will send the email to the customer, ensuring they receive their license key promptly.

5. Updating Google Sheets with License Key Status

The final step in your workflow is to update the Google Sheets with the status of the license key. This is important to prevent the same key from being sent to multiple customers. Select Google Sheets again as your action application in Pabbly Connect.

In this action, choose the event ‘Update a Row’. Connect to your existing Google Sheets account and specify the spreadsheet and row index where the license key was used. Update the status to ‘linked’ to signify that the key has been assigned.

Once you have configured this step, save your settings. This ensures that your Google Sheets is always up to date with the latest information regarding license keys.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

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

In conclusion, using Pabbly Connect enables you to automate the entire process of sending license keys from Google Sheets via Gmail whenever a purchase is made in Flexi Funnels. This not only saves time but also enhances customer satisfaction by providing immediate access to purchased software. By following the outlined steps, you can streamline your software delivery process effectively.