Learn how to automate sending license keys via Gmail upon payment capture in Razorpay using Pabbly Connect and Google Sheets. Follow this detailed tutorial! Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below


1. Setting Up Pabbly Connect for Automation

To automate the delivery of license keys upon payment capture, start by accessing Pabbly Connect. This integration platform allows you to connect Razorpay, Google Sheets, and Gmail seamlessly. First, navigate to the Pabbly Connect website and log in or create a new account if you haven’t done so.

Once logged in, click on the ‘Access Now’ button under Pabbly Connect. This will take you to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button, name your workflow (e.g., ‘Send License Key on Razorpay Payment’), and select the appropriate folder for organization.


2. Configuring the Trigger Event in Pabbly Connect

The next step involves setting up the trigger event in Pabbly Connect. Since you want to initiate the process when a payment is captured in Razorpay, search for Razorpay in the trigger application field. Select it, then choose the ‘Payment Captured’ event from the dropdown menu.

  • Select Razorpay as the trigger application.
  • Choose the ‘Payment Captured’ event.
  • Connect Razorpay to Pabbly Connect by copying the Webhook URL provided.

After setting up the trigger, head to your Razorpay account to configure the Webhook settings. Paste the copied Webhook URL into the appropriate field and select the ‘Payment Captured’ event as the active event. This ensures that every time a payment is successfully captured, Razorpay sends the data to Pabbly Connect.


3. Filtering Payments for Specific Software in Pabbly Connect

After setting up the trigger, you need to filter the payments to ensure that only those for your software are processed. In Pabbly Connect, create a filter step that checks the payment details. This is essential to ensure that the automation only runs for relevant transactions.

  • Set the filter to check for the software name in the payment response.
  • Use the ‘Filter by P’ application for this step.
  • Ensure the condition is set to ‘equals’ the software name.

By implementing this filter, you ensure that only payments for your specific software trigger the subsequent actions. This step is crucial for maintaining the integrity of your automation, ensuring that each license key is sent only to the correct customer.


4. Retrieving License Keys from Google Sheets via Pabbly Connect

With the trigger and filter set, the next step is to retrieve the license key from Google Sheets. In Pabbly Connect, add an action step and select Google Sheets as the application. Choose the ‘Lookup Spreadsheet Row V2’ as the action event to find the appropriate license key based on the payment data.

Connect your Google Sheets account to Pabbly Connect, and select the spreadsheet containing your license keys. Set the lookup value to the status of the license (e.g., ‘Not Linked’) to ensure you fetch an unused key. This setup allows you to access the correct license key associated with the payment.


5. Sending License Keys via Gmail Using Pabbly Connect

Finally, to send the license key to the customer, add another action step and select Gmail as the application in Pabbly Connect. Choose ‘Send Email’ as the action event. Connect your Gmail account and prepare the email content, mapping the recipient’s email from the payment data and the license key from the Google Sheets response.

Compose the email with a subject like ‘Your License Key for PAB Integration’ and include a message that thanks the customer for their purchase and provides the license key. Once the email is configured, save the action. This completes the automation, ensuring customers receive their license keys promptly after payment.


Conclusion

In this tutorial, we demonstrated how to automate the delivery of license keys using Pabbly Connect, Razorpay, and Google Sheets. By following these steps, you can ensure a streamlined process that saves time and minimizes manual effort. This integration allows for efficient management of software activation through automatic email notifications.

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