Atipica Inc: Add Payments to Google Forms

Google Forms is a useful tool for conducting surveys, but it doesn’t have built-in payment processing options. However, I found a workaround called PayQ. PayQ is an add-on for Google Forms that helps me create forms with payment capabilities.

As a professional or business owner, whether you’re managing an NGO, working as a freelancer, planning events, selling real estate, training at a gym, coaching individuals, or teaching, you likely use market research forms to gather important insights about your audience. However, studies have shown that creating these forms directly within your platform can significantly boost conversion rates by up to 67%.

Sending customers to separate payment platforms after generating interest often leads to drop-offs and missed revenue opportunities. By integrating online payment directly into your forms, you can simplify the process and maximize income.

Discover the benefits of PayQ:

  • Seamlessly integrate payment collection within your forms.
  • Enhance conversion rates by providing a smooth user experience.
  • Capture valuable insights without disrupting the customer journey.
  • Maximize revenue potential by reducing the number of lost sales due to multiple steps in the purchasing process.

Make Google Forms Payable Using PayQ (Google Add-on)

PayQ is a Google Workspace Marketplace add-on designed to merge payment options within Google Forms. Acting as a pipeline between form content and various payment gateways such as RazorPay, PayPal, and Stripe, PayQ streamlines the payment collection process.

But its capabilities extend beyond mere transaction facilitation. PayQ empowers users to not only collect payments directly from the Google Forms interface but also provides comprehensive payment tracking features through dedicated Google Sheets.

Now, let’s delve into each step of the process in detail:

Step 1: Installing PayQ

For steps, follow along:

  1. You can download the PayQ addon by heading over to the Google Workspace marketplace and search for PayQ.
  2. Once the extension shows up, scroll to read its features.
  3. Hit “Install”.Install PayQ
  4. Allow the terms and conditions.
    Read the terms and conditions

You can access the PayQ after a couple more steps.

  1. Head over to Google Forms and sign in using your email ID.
  2. You can now choose from a set of pre-existing forms or create a new form.
  3. Locate the PayQ app using the “Puzzle” icon.

Click the “PayQ-Add payments on Google Forms” option to open a chat box-style PayQ interface next to the form. From there, you can click on “Get Started” to receive a demo of how to use the tool and access settings fillers.

Step 2: Link the Form to Google Sheets

Before using PayQ, make sure you customize the form according to your preferences. I’m currently setting up a test form with essential fields for user input.

Customize the Form
  1. Once you finalize the structure of the form to your satisfaction, go to the PayQ chatbox that is already open in your view and select the first option, “Link form and sheet“.
    Link Form and Sheet
  2. As you link the Google Sheets with your form, a popup form will open with information on how the linking works. It also has an option that takes you to the Google Sheet, which is connected to your form.
    See the Linked Sheet

Note: PayQ automatically includes an Email field in your form, which is used to send payment links and receipts to the submitter of the Google Form.

Linking the Google form and the sheet is important because it allows PayQ to track email IDs and payments effectively. The information users provide via the form is mirrored on the sheet, which includes payment details.

Additionally, PayQ improves Google Sheets by adding crucial information like order IDs, order receipt links, and the collected amount.

Verify the Columns

Step 3: Add Payment Input Option

If you haven’t manually added a payment option, PayQ has a customizable solution through the “sample payment input.” This feature is particularly useful if you’re uncertain about the ideal way to encourage the audience to make a selection.

More importantly, PayQ offers multiple choices, including Checkboxes, Radio Buttons, Dropdown menus, Checkbox Grids, and even Short Text, which you can choose and integrate into the form.

Select Sample Payment Input

Depending on the nature of the form, you have the flexibility to select the payment input method. For example, a subscription-based service form may need checkboxes or radio buttons.

Step 4: Integrating Payment Partners

Within PayQ, you’ll find a section “Enter payment details.” Here, you can add your preferred payment gateway, such as Stripe, RazorPay, or PayPal, with the form data.

Add Payment Partner

It also offers the option to collect payments in your preferred currency.

Select the Currency

You can revisit the previous step, which involves the sample payment input, to select the format and customize the text to include the currency symbol such as “$“.

If you wish to accept payments in INR, RazorPay is the preferred payment gateway to opt for.

Step 5: Trying the Test Mode

To try the test mode for all associated payment gateways, you must subscribe to a PayQ plan. After purchasing the appropriate plan, you can start testing the payment gateways in the test mode.

  1. Opt for “Stripe” as the payment gateway. After selection, navigate to the Stripe dashboard or your account, proceed to the “Developers” section, select the “test mode,” and obtain the API keys.
    Copy API Key
  2. Once you have acquired the API keys, put them into the PayQ and initiate a test payment. While testing the payment interface, you have the option to include tax and handling charges or a promo code to verify the functionality of the Stripe interface.
    Paste the API and Secret Key
  3. To test payments using “PayPal,” begin by deactivating the Stripe tab and activating PayPal as the gateway. Then, proceed to the Developers section to log in and retrieve your API keys.
  4. After obtaining the API keys, you can proceed to test a payment and verify the correct generation of the sample receipt. Additionally, you can confirm the same through PayPal’s API Calls section. Other payment gateways, including RazorPay and PayPal, also facilitate testing API keys as part of the test mode.
    Payment Receipt

During testing, you can also explore the “Notifications” section to customize the messages users receive upon successfully paying for an order or service.

  1. Once all test mode elements are arranged, you can click “Send” to create a user-specific version of the form.

The test mode provides an opportunity to verify the working of payment gateways, notifications, promotional features, and other details of your payment setup.

Step 6: Tracking Payments

If the test mode yields the anticipated outcomes, you should return to the chosen payment gateway, activate “Live mode,” configure the appropriate live mode API keys, and proceed with actual payments. Here’s how you can track the process:

  1. Access the linked sheet that was initially created.
  2. Observe the PayQ fields as they are updated following each submission.
  3. Cross-check the information using the dashboard of your payment gateway to confirm if the payments have been received.

Every response, including payment credits, is documented in the linked Google Sheet.

Verify Details

Upon completing these steps, you’ll be able to utilize PayQ to collect payments directly via Google Forms. Users who make payments will receive a receipt or payment acknowledgment sent to the email address they provided initially.

Email Confirmation

This summarizes the usage of PayQ.

PayQ Features that You may Find Handy

Here are some key features of PayQ that you may find useful:

  • Simple payment setup with support for three reputable gateways.
  • Customizable order messages.
  • Detailed payment receipts for users.
  • Automated order verification alerts via SMS and emails.
  • Email-powered order lookup option for users.
  • Payment automation without requiring any coding.
  • Capability for businesses to create and market promos across various interfaces.
  • Support for a wide range of use cases, including online ordering, fundraising, and more.

Each of these features makes PayQ not only convenient but also highly adaptable.

What are the Benefits of Payable Google Forms?

Now, let’s delve into the benefits of using Payable Google Forms:

  • Cost-effective solution as it eliminates the need for investing in an external website.
  • Seamless data collection on users, their payment methods, and more via a single platform.
  • Simple implementation process.
  • Unmatched accessibility of Google Forms.
  • Real-time data tracking, including payment information.
  • Facilitates quick payment collection for NGOs.
  • Widely recognized and hence, considered a credible payment collection option.

Wrap Up!

You are now fully equipped to create your first payable Google Form using PayQ. While sticking closely to the mentioned steps is enough, it’s essential to note that you should only use one payment gateway at a time.

Additionally, during the integration process, always check for any region-specific restrictions. Once everything is sorted, don’t worry and create your payable form right away.