The client locations an order with Google Varieties and the invoice quantity is calculated routinely primarily based on the chosen objects. A personalized UPI QR Code is generated to make the fee.
Cake Studio is a neighborhood bakery that accepts orders by way of Google Varieties. When a buyer locations an order, the client routinely receives a UPI QR Code to make the fee. This QR Code is generated dynamically primarily based on the order quantity and the client will pay the invoice utilizing any UPI app.
Within the above screenshot, the client ordered a Butterscotch Cake by way of Google Type and so they obtained a personalized UPI QR Code that features the precise invoice quantity. The quantity is calculated routinely primarily based on the chosen objects within the Google Type.
Google Varieties and UPI Funds
This tutorial explains how one can ship customized UPI QR Codes to clients routinely every time they place an order through Google Varieties. We are going to use Google Sheets to calculate the invoice quantity and generate the QR codes, and Doc Studio to ship the emails with the QR codes to the shoppers.
Let’s see the way you arrange this workflow in a couple of easy steps.
Put together Google Type for Orders
Here’s a pattern Google Type that we’ve created for Cake Studio. As you’ll be able to see, and that is necessary, we’ve talked about the quantity of every cake within the choices itself.
Put together Google Sheet
Open the Google Sheet that’s linked to the Google Type. The Google Sheet will include columns for the questions within the Google Type. We’ll now add extract columns that will assist us generate the customized UPI QR codes.
Chances are you’ll discover the Google Sheet with UPI formulae here
Add Columns to Google Sheet
1. Invoice Quantity – This column will retailer the worth of the cake that the client has ordered. We’ll write a method utilizing the REGEXREPLACE operate to extract the worth from the chosen possibility.
=ARRAYFORMULA(IF(ROW(D:D)=1,"Invoice Quantity",
IF(NOT(ISBLANK(D:D)),REGEXREPLACE(D:D,".+₹ ",""),)))
2. Whole Quantity – Our second column will retailer the whole invoice quantity which provides GST on the worth of the cake. We’ll use Arrayformula to use the calculation down the whole column.
=ARRAYFORMULA(IF(ROW(E:E)=1,"Whole Quantity",
IF(NOT(ISBLANK(E:E)), E:E * 1.18,)))3. UPI QR Code – The ultimate column will retailer the customized UPI QR code that features the whole invoice quantity. We are going to use the built-in UPI function to generate the QR code.
A personalized UPI QR Code will likely be generated for every order. The QR code will embody the whole invoice quantity in order that the client could make the fee with out having to enter the quantity manually.
Embed UPI QR codes in Electronic mail
Now that we’ve the UPI QR codes within the Google Sheet, we are going to use Doc Studio to ship emails to clients with the QR codes embedded within the e-mail physique.
Launch Document Studio in your Google Sheets and create a brand new workflow. Add a Ship Electronic mail job to the workflow. Create a message template that features the Embed Image marker to embed the UPI QR code within the e-mail.
{{Embed IMAGE, UPI QR Code}}We’ve talked about UPI QR Code because the second parameter within the above marker since it’s the title of the column that comprises the generated QR codes in our Google Sheet.
Save the Workflow and ensure to allow the Run on Type Submit possibility in order that the emails are despatched routinely every time a brand new order is positioned by way of the Google Type.
Take a look at the UPI Cost Workflow
Fill this Google Form and it’s best to see a brand new row added to this Google Sheet with the invoice quantity and the UPI QR code. You’ll additionally obtain an e-mail with the UPI QR code embedded within the e-mail physique.
