Landing page with a COD order form that sends orders to Google Sheets

LandEmpire never asks for your Google password or for access to your Drive. Instead, you put a small script inside the spreadsheet itself and give LandEmpire the address of that script. Our server sends each new order to that address, and the script writes it into the sheet it is attached to.

The script carries a private token for your account. A Google Apps Script web app has to be open to receive data, so the token is what tells your sheet that a request really came from LandEmpire: anything without it is rejected. Setup takes a few minutes:

On the first order the script creates a sheet called Leads with a bold, frozen header row. Column names are in English for international accounts. Each order becomes one row:

Values are written as plain text, so a phone number keeps its leading + and a form entry that starts with = never turns into a formula. The script finds columns by their header, not by position, so you can add your own columns (Status, Courier, Tracking, Notes), sort and color rows and move columns around. New orders still land under the right headers, and if LandEmpire adds a column later, it goes at the end.

The connection only writes. It does not read the sheet back, so a status you type in the sheet stays in the sheet and does not change the order in LandEmpire.

Connected the sheet after orders started coming in? Run the export of old orders: LandEmpire sends your existing orders oldest first, in batches of 50, up to 5,000 orders. Exporting twice is safe, because the script skips any row whose Lead ID is already in the sheet. Orders hidden by the monthly limit of the Free or Start plan are not exported, just as they are not shown in the dashboard.

If Google does not answer or returns a server error, LandEmpire retries once after a few seconds. A send that still fails is shown in the integration settings with the reason, for example access not set to Anyone, and you can send that order again. A failed send does not lose the order: it is already saved in your dashboard and goes to your email or Telegram notifications, if you turned them on, whether or not the sheet accepted it.

The sheet is only as clean as the form. Every LandEmpire order form has name and phone, plus up to 8 fields of your own (short text, long text or a dropdown). Set the buyer's country in the page settings and the form checks phone numbers in that country's format; one click in the form block adds the address fields couriers need there. There are presets for 77 countries.

Phone numbers are checked before the order is sent, and obvious junk such as too few digits or one repeated digit is rejected. A double tap does not create two rows: the same name and phone on the same page within five minutes count as one order. You can add a consent checkbox and a Confirm in WhatsApp button that opens a chat with you after the order. Try the form on a real product page on the demo, no account needed.

If all you need is rows in a sheet, there are several options. The difference is whether you also get a product page that sells, and whether you need a Shopify store. Tool - needs Shopify? - COD order form? - price: