Spreadsheet destinations
Spreadsheet destinations
Open Settings → Integrations → Destinations → Add a destination → Google Sheet. An Excel workbook (.xlsx) kept in
Google Drive works the same way: Sheets opens it with an XLSX badge, and
Twelfth writes into it as an Excel file, so your formatting, merged cells and
other tabs stay as they are.
- Pick the spreadsheet. The step lists every spreadsheet someone in your
workspace has already shared with Twelfth (owned or shared by an eligible active, verified member), newest share first, each marked
Editor or Viewer. Pick one. - Not listed? Open the spreadsheet, click Share, and add the Twelfth
address shown under the list (Copy address copies it) as Editor.
Come back to the tab and it appears. Or paste the link: a pasted link is
checked at once. Twelfth shows the title, who shared it and whether the
share is Editor; a Viewer share is refused and the step shows the address
again with Check again. - Choose where rows land:
Tabs Twelfth creates: one tab, a tab per supplier, per buyer scope or
per decision kind. Every tab Twelfth makes ends with Tab name ends
with (Twelfthby default, so a supplier’s tab reads
Mattel - Twelfth), is coloured plum and is added after your last tab.
Rename a tab if you like: Twelfth remembers what each tab is for and
keeps writing to it under your name. In this mode Twelfth writes only to tabs it
created and stamps each one; existing tabs are left alone. Delete a stamped tab and
Deliver now brings its rows back on a fresh one.A tab you already use: pick one of the spreadsheet’s tabs. Twelfth
finds its header row (row 10 in the Retail Express order and
product templates, row 1 in the transfer template), then reads samples
and proposes what each header
reads as, and shows the table: their header (with sample values), reads
as, filled by. A warning sits inline on a header it concerns, such as a column
that holds mixed values or a header that repeats. Change any row; the
Columns step shows the same table again without a preset chooser. Twelfth
writes into that tab’s columns and adds a Twelfth line ID column if the
tab has none. Instructions, outlet and supplier cells, and type notes
above the header stay as they are. Check outlet and supplier in the
spreadsheet before uploading a purchase order to Retail Express.Tick Keep this tab’s columns exactly as they are for a tab you upload
as it stands, such as a Retail Express mass-upload template. Twelfth then
fills only the tab’s own columns and adds none: no Twelfth line ID, no
Reference or Raised at. Each line goes on the next empty row, and a line
that changes is rewritten on its own row as long as that row still holds
what Twelfth wrote there. A row you cleared after uploading it is left
alone, never refilled. Nothing is read back.A tab per supplier from a template (set up by Twelfth): the Retail
Express order workbook with one tab per supplier, each named by the
supplier’s Retail Express code (AID,360). A supplier’s lines go to
its tab; a supplier without a tab gets a copy of the template tab with
its outlet and supplier code filled in. Codes come from your warehouse
sync. A line whose supplier has no code is held back and the card says
which supplier.
Each linked tab holds up to 5,000 decision rows and 80 columns. The Product
Master template has 53 columns; the added Twelfth line ID is the 54th. A full
catch-up reads at most 5,000 ledger lines. If the working tab has added tracking columns, for a manual Retail Express upload
copy only the template’s import columns into the upload file: A:G for order
details, A:BA for Product Master, or A:D for the four-column transfer sheet.
The extra Twelfth line ID column stays in Google Sheets so later syncs update
the same row.
Columns your team fills in
Exact upload tabs have no added tracking or read-back columns. The following
applies to working tabs with those columns in their mapping.
Working-sheet presets include four columns that are yours: Reference, Raised at,
Status and Notes. Twelfth reads them back nightly and never
overwrites them. A filled-in Reference marks the line acknowledged; a
filled-in Raised at marks it executed.
Check the share first
Destinations need Editor access. The file must belong to this workspace
under Google file sharing rules.
A company email domain alone is not proof. Another workspace needs a separate
copy, even if the original file was unlinked.
Mapping and preview
The mapping decides which fields go, in which order, under which names. Start
from a preset and change anything. The Retail Express presets are offered only
where Twelfth already reads the workspace’s Retail Express; everywhere else the
mapping starts from Twelfth columns and there is no preset to choose.
| Preset | What it is for |
|---|---|
| Twelfth columns | Every identifier, the decision, and the four columns you fill in. The default. |
| Retail Express purchase orders | The MassUploadPurchaseOrders headers first — ProductId, ManufacturerSKU, SupplierSKU, SupplierSKU2, Qty, SupplierBuy — then the canonical columns. |
| Retail Express products | The MassUploadProducts price headers first — ProductId, POSPrice, WebPrice, DiscountPrice, DiscountEnd, SupplierBuy, BuyPriceEx, RRP — one price decision setting POS and web alike, then the canonical columns. |
Each row names the column, what it reads as (a field of the line, a fixed
value, or a template such as {{source.sku}} — {{decision.quantity}}) and who
fills it in. Columns you fill are read back and never overwritten. The
Twelfth line ID column cannot be removed, because it is how a changed line
finds its own row.
Preview shows how many lines the filter matches, how they fall across tabs,
and the first rows in the destination’s shape, before anything is delivered.
Before you start delivery
Preview the rows and their supplier tabs, confirm the filter and triggers, then
choose Link and deliver. This starts real delivery in the background.
Deliver now runs the filter again; already delivered unchanged lines are
skipped. Review errors on the card rather than assuming every previewed line
was sent.
An upload workbook prepares the file your team imports into Rex. It does not
raise the purchase order or transfer itself. Check the supplier and outlet
before uploading. See Rex writeback for
the native actions and upload path.