For this zap, you need to execute a trigger every time that an order is placed, if you don't know how to do it please take a 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 this 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 the 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 created the template you only need to test it and public your zap to be able to register all your orders in 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.
Comments
0 comments
Please sign in to leave a comment.