Square connection for LinkyFlow

LinkyFlow brings Square ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Business

Locations

The places your business sells from: each has its own orders, payments and currency.

Used as filter by

Orders · location_id

Payments · location_id

Read

Locations

The places your business sells from: each has its own orders, payments and currency.

Route: GET /locations

Excel formula: =LF.square.locations("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`business_name`	string	—	-
`status` default	string	—	-
`type`	string	—	-
`currency` default	string	—	-
`country` default	string	—	-
`timezone`	string	—	-
`language_code`	string	—	-
`address`	string	—	-
`locality`	string	—	-
`postal_code`	string	—	-
`merchant_id`	string	—	-
`created_at`	date	—	-

Catalog

Catalog Items

The items of your catalogue. Their SKUs and prices are on their variations.

Read

Catalog Items

The items of your catalogue. Their SKUs and prices are on their variations.

Route: GET /catalogItems

Excel formula: =LF.square.catalogItems("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`item_data`	string	—	-
`name` default	string	—	-
`description_plaintext`	string	—	-
`product_type` default	string	—	-
`is_archived` default	boolean	—	-
`is_taxable`	boolean	—	-
`is_deleted`	boolean	—	-
`present_at_all_locations`	boolean	—	-
`version`	number	—	-
`created_at`	date	—	-
`updated_at` default	date	—	-

Catalog Variations

The variations of your items: each SKU and its price.

Read

Catalog Variations

The variations of your items: each SKU and its price.

Route: GET /catalogVariations

Excel formula: =LF.square.catalogVariations("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`item_variation_data`	string	—	-
`item_id` default	string	→ catalogItems	-
`name` default	string	—	-
`sku` default	string	—	-
`upc`	string	—	-
`pricing_type`	string	—	-
`price_money`	string	—	-
`sellable`	boolean	—	-
`stockable`	boolean	—	-
`is_deleted`	boolean	—	-
`present_at_all_locations`	boolean	—	-
`version`	number	—	-
`created_at`	date	—	-
`updated_at` default	date	—	-

Sales

Orders

The orders of a location, latest updated first: their state, their totals and their lines.

Read

Orders

The orders of a location, latest updated first: their state, their totals and their lines.

Route: GET /orders

Excel formula: =LF.square.orders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`location_id`	id	Yes	The location whose records are read.
`state`	enum	No	Only the orders in this state. Values: OPEN, COMPLETED, CANCELED, DRAFT
`updated_from`	string	No	Updated at or after this moment (RFC 3339, 2026-01-31T00:00:00Z).
`updated_to`	string	No	Updated before this moment (RFC 3339, 2026-01-31T00:00:00Z).
`sort_order`	enum	No	Oldest first, or latest first. Values: ASC, DESC
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`location_id` default	string	→ locations	-
`state` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`updated_at` default	date	—	-

Payments

The payments of your business: their amount, status, card and order.

Read

Payments

The payments of your business: their amount, status, card and order.

Route: GET /payments

Excel formula: =LF.square.payments("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`location_id`	id	No	Only the records of this location.
`begin_time`	string	No	Created at or after this moment; a year ago when empty (RFC 3339, 2026-01-31T00:00:00Z).
`end_time`	string	No	Created before this moment; now when empty (RFC 3339, 2026-01-31T00:00:00Z).
`sort_order`	enum	No	Oldest first, or latest first. Values: ASC, DESC
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	string	—	-
`source_type` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`created_at` default	date	—	-