Integrating Instamojo Payments with Google Sheets and WhatsApp Alerts Using Pabbly Connect

Learn how to automate WhatsApp alerts for Instamojo payments and log details in Google Sheets using Pabbly Connect. Step-by-step tutorial included. 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. Accessing Pabbly Connect for Integration

To begin the integration process, first visit the Pabbly Connect website. Pabbly Connect is the central platform that enables seamless automation between various applications. If you are a new user, you can sign up for free and get started with 100 free tasks each month.

Once signed in, navigate to the dashboard where you will see all available Pabbly applications. Click on Pabbly Connect to access the automation features. Here, you can create a new workflow that will connect Instamojo with Google Sheets and WhatsApp.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. This will prompt a dialog box where you can name your workflow and select a folder to save it.

• Enter a name for the workflow, such as ‘Send WhatsApp Alerts for Successful and Failed Instamojo Payments’.
• Select a folder to organize your workflow, for example, ‘Instamojo Automations’.
• Click the ‘Create’ button to finalize the workflow setup.

This process sets up the foundation for your automation, allowing you to manage payment notifications effectively.

3. Setting Up the Trigger for Instamojo Payments

The next step involves setting up the trigger for your workflow in Pabbly Connect. Select Instamojo as the trigger application and choose the event type as ‘New Sale’. This will allow Pabbly Connect to capture payment details whenever a student makes a purchase using Instamojo.

After selecting the trigger application, Pabbly Connect will generate a unique webhook URL. Copy this URL, as you will need to connect it to your Instamojo account. This connection is crucial for capturing payment data automatically.

4. Connecting Instamojo to Pabbly Connect

Now that you have your webhook URL, log in to your Instamojo account. Navigate to the page where you manage your payment settings. Here, you can add the webhook URL you copied from Pabbly Connect.

In the settings, look for the option to add a webhook. Paste the URL and select the payment statuses you want to track, such as successful and failed payments. Save your changes to ensure that Instamojo can send payment notifications to Pabbly Connect.

Once the webhook is set up, perform a test transaction to verify that Pabbly Connect captures the payment details correctly. This will ensure that your workflow is functioning as intended.

5. Logging Payments in Google Sheets and Sending WhatsApp Alerts

After successfully capturing payment details, the next step is to log these details into Google Sheets. Select Google Sheets as the action application in Pabbly Connect and choose the event type as ‘Add New Row’. This will allow you to create a new entry in your spreadsheet for each payment.

• Map the fields from the previous step to the corresponding columns in your Google Sheets.
• Ensure that the payment ID, name, email, phone number, and payment status are included in the row.

Finally, set up WhatsApp alerts using the WhatsApp by AI Sensi application. Select it as the action application and choose the event type as ‘Send Template Message’. Map the necessary fields, such as the recipient’s mobile number and the message template you created for successful or failed payments. This completes the automation process.

Conclusion

This tutorial demonstrated how to integrate Instamojo payments with Google Sheets and WhatsApp alerts using Pabbly Connect. By following these steps, you can automate payment notifications and efficiently manage your educational course enrollments.