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.

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 1 Proceed to create 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

1 Three tabs. 2 Line Items has a row for each product in each order.
TabOne row perColumnsUse it for
Order SummaryOrderId, Order Id, Date, Status, Payment, Paid with, the order amount and quantity, and your customer fields, such as Name, Phone, Email, and Delivery addressPayment checks, delivery lists, bookkeeping
Line ItemsProduct in an orderOrder Id, Item Id, SKU, Date, Email, Name, Product, Price, Quantity, Status, Amount, CategoryKitchen totals, per-customer lists, pivot tables
Order DetailsOrderId, Order Id, Date, Status, and one column per productSeeing 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.

Next steps