Hello everyone, hope you are doing well. I am using a payment gateway and it is connected to zapier. In google sheets I have a fixed template which makes reciepts for individual user. So it has specific cells for name, price and some calculation that take place. I want all the data that is collected using the payment gateway to get stored in those specific cells that are there in my google sheets and then once all the data is filled, I want the google sheet to be saved as a PDF and then repeat this whole process for the next payment.
I would really appreciate help with this.