The shopper locations an order with Google Types and the bill quantity is routinely calculated primarily based on the chosen objects. A customized UPI QR code might be generated to make the cost.
Cake Studio is an area bakery that accepts orders by way of Google Types. When a buyer locations an order, the shopper routinely receives a UPI QR code to make the cost. This QR code is dynamically generated primarily based on the order quantity and the shopper pays the bill utilizing any UPI app.
Within the screenshot above, the shopper ordered a Butterscotch Cake through Google Kind and acquired a customized UPI QR code with the precise bill quantity. The quantity is routinely calculated primarily based on the chosen objects within the Google Kind.
Google Types and UPI Funds
This tutorial explains easy methods to routinely ship customized UPI QR codes to clients after they place an order by way of Google Types. We use Google Sheets to calculate the bill quantity and generate the QR codes, and Doc Studio to ship the emails with the QR codes to the shoppers.
Let’s examine easy methods to arrange this workflow in a number of easy steps.
Put together Google Kind for orders
This is an instance of a Google Kind we created for Cake Studio. As you may see, and that is vitalWe have now acknowledged the amount per cake within the choices ourselves.
Put together Google Sheet
Open the Google Sheet related to the Google Kind. The Google Sheet incorporates columns for the questions within the Google Kind. We are actually including extraction columns that can permit us to generate the customized UPI QR codes.
You will discover the Google Spreadsheet with UPI formulation right here
Add columns to Google Spreadsheet
1. Bill quantity – This column shops the value of the cake that the shopper has ordered. We write a system utilizing the REGEXREPLACE
operate to extract the value from the chosen possibility.
=ARRAYFORMULA(IF(ROW(D:D)=1,"Invoice Quantity",
IF(NOT(ISBLANK(D:D)),REGEXREPLACE(D:D,".+₹ ",""),)))
2. Complete quantity – Our second column shops the whole bill quantity, which provides GST to the value of the cake. We use Arrayformula to use the calculation to the complete column.
=ARRAYFORMULA(IF(ROW(E:E)=1,"Complete Quantity",
IF(NOT(ISBLANK(E:E)), E:E * 1.18,)))
3. UPI QR code – The final column shops the customized UPI QR code containing the whole invoice quantity. We are going to use the built-in UPI function to generate the QR code.
A customized UPI QR code is generated for every order. The QR code incorporates the whole bill quantity, so the shopper could make the cost with out manually coming into the quantity.
Embed UPI QR codes in e mail
Now that we’ve got the UPI QR codes within the Google Spreadsheet, we’ll use Doc Studio to ship emails to clients with the QR codes embedded within the physique of the e-mail.
Launch Doc Studio in your Google Sheets and create a brand new workflow. add a Ship E mail
activity to the workflow. Create a message template with the Embed Picture marker to embed the UPI QR code within the e mail.
Embed IMAGE, UPI QR Code
We have now listed UPI QR Code because the second parameter within the above markup as that is the title of the column that incorporates the generated QR codes in our Google Sheet.
Save the workflow and be sure to have the Run on Kind Submit
possibility in order that the emails are despatched routinely when a brand new order is positioned through the Google kind.
Check the UPI cost workflow
Fill out this Google Kind and a brand new row ought to be added to this Google Sheet with the bill quantity and the UPI QR code. Additionally, you will obtain an e mail with the UPI QR code embedded within the physique of the e-mail.