Generate Unique Coupon Codes on Webhook Response & Send via Email Using Pabbly Connect

Learn how to generate unique coupon codes using Pabbly Connect and send them via email upon webhook response with this detailed tutorial. 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. Accessing Pabbly Connect for Integration

To start generating unique coupon codes using Pabbly Connect, first, access the Pabbly Connect website. If you’re an existing user, sign in to your account; if not, you can sign up for free and get 100 free tasks every month. Upon logging in, you will see the Pabbly Connect dashboard.

Once on the dashboard, click on the ‘Create Workflow’ button located in the top right corner. A dialog box will appear asking for a workflow name. Name your workflow ‘Generate Unique Coupon Codes on Webhook Response and Send via Email’ and choose a folder to save it in, such as ‘Gmail Automations.’ Click on ‘Create’ to initiate the workflow.

2. Setting Up Webhook Trigger with Pabbly Connect

In this step, we will set up the webhook trigger for our workflow. Click on the arrow next to the trigger application and select ‘Webhook by Pabbly’. Choose the trigger event as ‘Catch Webhook’. Pabbly Connect will provide you with a webhook URL that will be used to connect your form.

• Copy the provided webhook URL.
• Open your form application (e.g., Pabbly Form Builder).
• Navigate to the integration section and create a new webhook by pasting the copied URL.

Once you have added the webhook to your form, go back to your Pabbly Connect workflow and wait for a webhook response. This indicates that your form is successfully connected to Pabbly Connect.

3. Filtering Form Submissions in Pabbly Connect

After setting up the webhook, we need to filter the form submissions to ensure the workflow only proceeds for specific forms. Add a new action step and select ‘Filter by Pabbly’. This will allow you to filter the responses based on the form ID.

• Choose the label as ‘Form ID’.
• Set the filter type to ‘Equal to’ and enter the specific form ID.

After configuring the filter, click on ‘Save and Test’. This ensures that only submissions from the specified form will trigger the next steps in your Pabbly Connect workflow.

4. Fetching Unique Coupon Codes from Google Sheets

Next, we will fetch the unique coupon codes from Google Sheets. Add another action step and select ‘Google Sheets’ as the application. Choose the action event as ‘Lookup Spreadsheet Row’ to find the coupon codes that have not been used yet.

Connect your Google Sheets account to Pabbly Connect by clicking on ‘Add New Connection’. After authorization, select your spreadsheet containing the coupon codes. Specify the sheet name, lookup value as ‘No’ (indicating unused codes), and the relevant columns for the lookup.

5. Sending Coupon Codes via Email Using Pabbly Connect

In this final step, we will send the fetched coupon code to the customer via email. Add another action step and select ‘Gmail’ as the application. Choose the action event as ‘Send Email V1’ and connect your Gmail account to Pabbly Connect.

Map the recipient’s email address from the webhook response, enter a subject line, and compose the email content. Use HTML format if necessary to customize the email. Finally, click on ‘Save and Send Test Request’ to send the email.

Check your Gmail account to confirm that the email with the unique coupon code has been received. This completes the automation process using Pabbly Connect, ensuring that each customer receives a unique coupon code upon form submission.

Conclusion

In this tutorial, we demonstrated how to generate unique coupon codes on webhook response and send them via email using Pabbly Connect. This process automates customer engagement and enhances marketing strategies effectively.