Chapter 6 · Fulfill orders
Google Sheets
Sync every order to a Google Sheet with three tabs: one row per order, one row per item, and one column per product.
Quick Answer
How do I send Neartail orders to Google Sheets?
Open the form's Orders tab, then the Google Sheets view, and choose Link to Sheets. Confirm Create a Google Sheet with all your orders? with Proceed. Neartail creates a sheet named after your form, adds your existing orders, and keeps syncing new ones. The sheet has three tabs: Order Summary, Line Items, and Order Details.
Your orders are already saved in Neartail. A sheet is useful when your team works in spreadsheets, or you want your own filters and formulas.
Link a sheet
Open the Google Sheets view
In your form, open Orders, then Google Sheets.
Choose Link to Sheets
If you're asked to sign in to Google, use the account that should own the sheet.
Choose Proceed
You'll see Your sheet is ready and syncing has started.
Choose View sheets
The sheet opens in Google Sheets, named after your form.
Orders you already had are added when the sheet is created. New orders follow as they come in.
What's in the sheet
| Tab | One row per | Columns | Use it for |
|---|---|---|---|
| Order Summary | Order | Id, Order Id, Date, Status, Payment, Paid with, the order amount and quantity, and your customer fields, such as Name, Phone, Email, and Delivery address | Payment checks, delivery lists, bookkeeping |
| Line Items | Product in an order | Order Id, Item Id, SKU, Date, Email, Name, Product, Price, Quantity, Status, Amount, Category | Kitchen totals, per-customer lists, pivot tables |
| Order Details | Order | Id, Order Id, Date, Status, and one column per product | Seeing whole orders side by side |
The columns depend on your form. A field you add later gets its own column.
Make a list for each customer
On Line Items, choose Data, then Create filter view, and filter by Name. You get one customer's items, which is handy for packing.
Phone numbers that start with +
Phone numbers entered with a + and country code, such as +1 555 0100, can show #ERROR! in the Order Summary tab, because Sheets reads them as formulas. The number is still correct in Neartail. To fix the sheet, select the column, choose Format → Number → Plain text, and retype the number, or read it from the order in Neartail.
Keep the sheet as a copy
Neartail is the record, and the sheet is a copy for working in:
- Changing a cell in the sheet doesn't change the order in Neartail. Edit the order instead.
- Add your own columns or tabs to the right of Neartail's, so syncing doesn't overwrite them.
- Name the form and the sheet so they obviously match.
- A copied weekly form needs its own sheet. Link it again after you duplicate.
Share the sheet
Share it from Google Sheets as you would any sheet. People you share it with don't need a Neartail subscription. To give someone access to the orders in Neartail itself, see Work with your team.
Another route: forward to Google Forms
If you'd rather keep your records in Google Forms, open Orders → Google Forms and turn on Submit to Google Forms. New orders then also reach the underlying Google Form, where you can link a sheet from its Responses tab. Most businesses don't need this.
If you imported a Google Form, Neartail works on a copy. Your original form doesn't get new orders.