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

Learn how to automate the process of sending Razorpay payment links upon Google Forms submission and updating Google Sheets using Pabbly Connect. Follow this detailed tutorial!

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To automate the process of sending Razorpay payment links upon Google Forms submission, you first need to set up Pabbly Connect. Start by signing up for a free account on Pabbly Connect. Once you have your account, log in to access the dashboard.

Next, create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow, for example, ‘Google Forms to Razorpay to Google Sheets’. After naming the workflow, select the appropriate folder in your Pabbly Connect account and click on ‘Create’. This sets the stage for the automation process.

2. Connecting Google Forms as a Trigger

The first step in the automation is to connect Google Forms to Pabbly Connect. In the trigger window, select Google Forms and choose the trigger event as ‘New Response Received’. Pabbly Connect will provide you with a webhook URL that you’ll use to connect Google Forms with Pabbly Connect.

• Copy the webhook URL provided by Pabbly Connect.
• Open your Google Form and navigate to the ‘Responses’ tab.
• Link the form to a Google Sheet by selecting ‘Link to Sheets’.

After linking, go to the Google Sheet created for your form responses. Access the Extensions menu, click on Add-ons, and install the Pabbly Connect Webhooks add-on. Once installed, refresh your Google Sheet, and then go to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the copied webhook URL and select the trigger column, which is usually the last column containing data. Finally, click on Submit to complete the setup.

3. Integrating Razorpay to Generate Payment Links

With Google Forms connected, the next step is to integrate Razorpay using Pabbly Connect. In the action step, search for Razorpay and select the action event as ‘Create Payment Link’. Click on Connect and add a new connection by entering your Razorpay API Key ID and Secret.

To obtain your API credentials, log into your Razorpay account, go to Account Settings, and find the API Keys section. Generate a new key if necessary, and copy both the Key ID and Secret into Pabbly Connect. After saving the connection, specify the amount for the payment link in the smallest currency unit (e.g., for ₹999, enter 99900) and choose INR as the currency.

• Set the payment type to ‘link’.
• Provide a description for the payment link.
• Map the user’s name, email, and mobile number from the Google Forms responses.

After configuring these details, click on Save and Send Test Request. This generates a payment link that will be sent via email and SMS to the user.

4. Updating Google Sheets with Payment Link and Status

The final step in this automation is to update the Google Sheets with the generated payment link and its status. In Pabbly Connect, add another action step and select Google Sheets. Choose the action event as ‘Update Row’ and connect your Google Sheets account.

In the action setup, select the spreadsheet where the Google Form responses are stored. Then, map the row index from the trigger step to ensure the payment link is added to the correct row. In the fields provided, map the payment link received from Razorpay and set the payment status as ‘Pending’.

Select the correct spreadsheet and sheet. Map the row index to update the right entry. Fill in the payment link and status fields.

After completing the mapping, click on Save and Send Test Request. Check your Google Sheet to confirm that the payment link and its status have been updated successfully.

5. Conclusion: Automate Your Payment Process with Pabbly Connect

This tutorial has guided you through the process of automating the generation and sending of Razorpay payment links upon Google Forms submission using Pabbly Connect. By following these steps, you can streamline your payment collection process and ensure that all necessary information is accurately recorded in Google Sheets.

With Pabbly Connect, you can integrate various applications to create seamless workflows that enhance your productivity. Start automating your processes today and experience the benefits of efficient task management!