The google sheets are not showing the normal 3 tabs of Order Summary, Line Items and Order Details. I don't know if it's because I created the form by clicking the Neartail extension on a pre-existing form in Google Forms and then once it made a copy in Neartail, I finished creating the form in Neartail. Please advise how to sort. Thank you!
Hi - 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 in the following format.
When you sync the Neartail reports to Google Sheets, we create three sheets. (1) Order summary: This includes the customer contact details, amount and other fields in the form. (2) Order lineitems: This includes the order lineitems data. 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.
If you customize the existing google form using the Neartail addon, the data synced to google sheets will be in the same format as google forms sync to google sheets. All the fields in the form are included as columns and each row is a response. The responses will be synced in real time.
