How to Create & Send Razorpay Payment Link on Google Forms Submission & Update Google Sheets Row

Learn how to automate sending Razorpay payment links through Google Forms submissions using Pabbly Connect, and update Google Sheets effectively. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To automate sending Razorpay payment links through Google Forms submissions, we start with Pabbly Connect. First, create a free account on Pabbly Connect to access its features. Once signed up, navigate to the dashboard to start creating your automation workflow.

Click on the ‘Create Workflow’ button, give it a name like ‘Google Forms to Razorpay to Google Sheets’, and select the folder where you want to save it. This setup initiates your automation process, allowing you to connect Google Forms with Razorpay seamlessly through Pabbly Connect.

2. Connecting Google Forms as a Trigger in Pabbly Connect

In this step, we will link Google Forms to Pabbly Connect so that every new submission triggers the workflow. Select Google Forms from the trigger options and choose ‘New Response Received’ as the trigger event.

• Copy the webhook URL provided by Pabbly Connect.
• Go to your Google Form, click on the ‘Responses’ tab, and link it to Sheets.
• Install the Pabbly Connect Webhooks add-on from Google Workspace Marketplace.

After installing, refresh the Google Sheet, go to Extensions > Pabbly Connect Webhooks, and click on ‘Initial Setup’. Here, paste the webhook URL and select the trigger column, typically the last column with data. Click ‘Submit’ to finalize the setup, enabling Pabbly Connect to capture new form responses automatically.

3. Generating Razorpay Payment Link

Once the Google Forms trigger is set, we move to create a payment link using Razorpay through Pabbly Connect. In the action step, search for Razorpay and select the action event as ‘Create Payment Link’.

Connect your Razorpay account by entering the API Key ID and Secret. These can be found in your Razorpay account under Account Settings > API Keys. After entering these details, specify the amount in paisa (e.g., 9999 INR should be entered as 999900). Set the currency to INR and provide a description for the payment link.

• Map the user’s name, email, and mobile number from the Google Forms response.
• Set the expiry of the payment link to 24 hours before the selected workshop date.
• Enable SMS and Email notifications for the payment link.

After configuring these settings, click ‘Save and Send Test Request’ to generate the payment link. This link will be sent to the user automatically via email and SMS, showcasing how Pabbly Connect streamlines the payment process.

4. Updating Google Sheets with Payment Link and Status

The final step involves updating the Google Sheets with the generated payment link and its status. In Pabbly Connect, add another action step and choose Google Sheets as the app. Select ‘Update Row’ as the action event.

Connect your Google Sheets account and select the spreadsheet where you want to update the payment information. Map the row index from the trigger step to ensure the payment link is added to the correct row. Then, in the fields for payment link and status, map the respective data from Razorpay.

Map the payment link generated from Razorpay. Set the payment status to ‘Pending’ initially.

After completing the mapping, click ‘Save and Send Test Request’. This action updates your Google Sheets with the payment link and status, demonstrating the complete automation process facilitated by Pabbly Connect.

5. Testing the Complete Automation Workflow

To ensure everything is working correctly, test the entire automation by submitting a new response through your Google Form. This will trigger the workflow in Pabbly Connect, generating a payment link and updating the Google Sheets.

After submission, check your Google Sheets to see if the new row includes the payment link and status. You should also receive the payment link via email and SMS, confirming that the automation is functioning as intended.

This successful integration showcases how Pabbly Connect can automate complex workflows, saving time and improving efficiency in managing payments and registrations.

Conclusion

By following this tutorial, you can effectively use Pabbly Connect to automate the process of sending Razorpay payment links through Google Forms submissions and updating Google Sheets. This integration enhances your workflow, ensuring smooth payment collection and management.