How to Integrate Instamojo with Google Sheets and SMTP Using Pabbly Connect

Learn how to integrate Instamojo with Google Sheets and SMTP using Pabbly Connect for seamless payment management and email notifications. 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 start integrating Instamojo with Google Sheets and SMTP, first access Pabbly Connect. Simply visit the Pabbly website and sign in to your account. If you are a new user, you can sign up for a free trial.

Once signed in, navigate to the dashboard and locate the Pabbly Connect application. Click on the ‘Access Now’ button to proceed. This will take you to the workflow creation area where you can set up your integration.

2. Creating a Workflow in Pabbly Connect

To create your workflow, click on the ‘Create Workflow’ button. You will be prompted to enter a name for your workflow and select a folder to save it in. For this integration, name your workflow something like ‘Add Instamojo Payment Details to Google Sheets and Send Email via SMTP’.

• Click on the ‘Create’ button to initiate the workflow.
• This will open the workflow window where you can set your trigger and actions.

In the workflow window, select Pabbly Connect as the integration platform. Here, you will define the trigger, which will be the event that starts your automation.

3. Setting Up Instamojo Trigger in Pabbly Connect

For the trigger application, search for and select ‘Instamojo’. Then, choose the trigger event as ‘New Sale’. This means that every time a new payment is made, the workflow will be triggered.

After selecting the trigger, Pabbly Connect will provide you with a webhook URL. Copy this URL, as you will need it to set up the webhook in your Instamojo account. This connection ensures that Instamojo communicates with Pabbly Connect whenever a payment is made.

4. Configuring the Webhook in Instamojo

Log in to your Instamojo account and navigate to the product for which you want to set up the webhook. Click on the three dots next to the product and select ‘Edit’. Then, go to the ‘Advanced Settings’ section.

• In the Webhook section, click on ‘Add Webhook’.
• Paste the webhook URL copied from Pabbly Connect.
• Select the payment statuses you want to track, such as successful and failed payments.

After entering these details, save the changes. This configuration allows Pabbly Connect to receive payment notifications from Instamojo, which is crucial for your workflow.

5. Adding Actions in Pabbly Connect

Now that your trigger is set up, it’s time to add actions in Pabbly Connect. First, select the ‘Router’ app to create different paths based on the payment status. You can name the routes, such as ‘Payment Successful’ and ‘Payment Failed’.

For the successful payment route, add an action to connect to Google Sheets. Choose ‘Add New Row’ as the action event and connect your Google Sheets account. Map the fields from the Instamojo response to the corresponding columns in your Google Sheets.

Map fields like Name, Email, Phone Number, and Amount from the Instamojo payment response. For the failed payment route, select ‘SMTP by Pabbly’ and configure it to send an email notification.

Fill in the email details, including the recipient’s address, subject, and body, using dynamic data from the payment response. This setup ensures that your customers receive timely notifications based on their payment status.

Conclusion

Integrating Instamojo with Google Sheets and SMTP using Pabbly Connect streamlines your payment management and enhances customer communication. This setup automates data entry and ensures prompt notifications for both successful and failed payments, ultimately improving your business operations.