For this zap, you need to execute a trigger every time an order is placed; if you don't know how to do it, please look at the following article.
Create a Zap with Trigger Actions →
Now that we have the trigger step completed, for the next step, you need to create a Google Sheet with these fields in the header of the columns (you can add more columns at the end if you want):
・ID
・Customer email
・Customer Name
・Business ID
・Dishes
・SubTotal
・Delivery fee
・Service fee
・Discount
・Driver Tip
・Total
・Date
Once you have your Document, you will need to create an action using Zapier and Google Sheet
And in action, you must select "create spreadsheet row."
Then you only need to connect your Google Account where you created the Google Sheet.
Now you need to specify where the data will be inserted
After that, you will select the info that will fill the row.
And do this with all the columns.
Once you have created the template, you only need to test it and publicize your zap to register all your orders on a comfortable Google Sheet page.
NOTES
・In the business ID, please verify, because there is more than one field with this name, but not all are the right one.
・Remember to not edit the google doc manually, because it may cause some unexpected functionality to the zap.
Have a Happy Ordering.