Hi Vipin,
Is there a way to notify outside neartail platform the payment selection?
In my form I offer two payment types: Card and cash on delivery. How can I send the costumer payment selection into google sheets? The thing is that I manage everything based on google sheets and it is a crucial step to have that information along with the costumer's selection.
Hi Rafael, If you used the Neartail templates to create your order form, then you will also be able export the Neartail Reports data to google sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > click on the sync button in the bottom right corner. The responses will be synced to Sheets ONLY when you click on the Export button in Neartail. This includes order status, payment status & more.
When you sync the Neartail reports to Google Sheets, we create three sheets:
(1) Order summary: This includes the order id, order date, order status, payment method, payment status, customer contact details, amount and other fields in the form.
(2) Order lineitems: This includes the order lineitems data such as order id, order date, product name, price, quantity, amount, status, name, email. You can use the pivot table option on this sheet to create the aggregate reports you need.
(3) Order details: This includes the quantity ordered for the products in each order. Each product will be added as a column. For products with variants, each variant will be a separate column.
Note: If you sync the Google Forms responses to Google Sheets, only the responses for the fields in the form will be available in Sheets. Order status, payments status etc won't be available.