LinkyFlow — autonomous agents and live business data in Excel or on the webLinkyFlow
Square connection for LinkyFlow

Square connection for LinkyFlow

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

Resources

7

Read requests

7

Write actions

4

Documented fields

124

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.

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
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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.

Used as filter by

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
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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

—

-

Edit

Update Item

Update Item

Route: PATCH /mutation/catalogItems

Inputs you can set
NameTypeRequiredDescription
ididYes-
item_data.is_archivedbooleanNo-
item_data.is_taxablebooleanNo-
item_data.namestringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

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
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
skustringNoOnly the variations of this whole SKU. Square ignores case here: mug-1 finds MUG-1.
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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

—

-

track_inventory

boolean

—

-

location_overrides

string

—

-

is_deleted

boolean

—

-

present_at_all_locations

boolean

—

-

present_at_location_ids

string

—

-

absent_at_location_ids

string

—

-

version

number

—

-

created_at

date

—

-

updated_at
default

date

—

-

Edit

Update Variation

Update Variation

Route: PATCH /mutation/catalogVariations

Inputs you can set
NameTypeRequiredDescription
ididYes-
item_variation_data.namestringNo-
item_variation_data.price_money.amountnumberNo-
item_variation_data.price_money.currencystringNo-
item_variation_data.skustringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Stock

How many of each variation are in stock at each location. Only variations with a tracked count have a row.

Read

Stock

How many of each variation are in stock at each location. Only variations with a tracked count have a row.

Route: GET /inventoryCounts

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

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
catalog_object_ididNoOnly the stock of these variations, their ids separated by commas.
location_ididNoOnly the records of this location.
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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

—

-

catalog_object_id
default

string

—

-

location_id
default

string

→ locations

-

state

string

—

-

quantity
default

string

—

-

calculated_at
default

date

—

-

Edit

Set Stock

Set Stock

Route: PATCH /mutation/inventoryCounts

Inputs you can set
NameTypeRequiredDescription
ididYes-
quantitystringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

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
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
location_ididYesThe location whose records are read.
stateenumNoOnly the orders in this state. Values: OPEN, COMPLETED, CANCELED, DRAFT
updated_fromstringNoUpdated at or after this moment (RFC 3339, 2026-01-31T00:00:00Z).
updated_tostringNoUpdated before this moment (RFC 3339, 2026-01-31T00:00:00Z).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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.

Used as filter by

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
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
location_ididNoOnly the records of this location.
begin_timestringNoCreated at or after this moment; a year ago when empty (RFC 3339, 2026-01-31T00:00:00Z).
end_timestringNoCreated before this moment; now when empty (RFC 3339, 2026-01-31T00:00:00Z).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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

—

-

Refunds

The refunds of your payments: their amount, status and payment.

Used as filter by

Read

Refunds

The refunds of your payments: their amount, status and payment.

Route: GET /refunds

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

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Square’s refusal.
location_ididNoOnly the records of this location.
begin_timestringNoCreated at or after this moment; a year ago when empty (RFC 3339, 2026-01-31T00:00:00Z).
end_timestringNoCreated before this moment; now when empty (RFC 3339, 2026-01-31T00:00:00Z).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
limitnumberNoRows per page (max 100). Default: 100
cursorstringNoThe 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

—

-

amount
default

number

—

-

currency
default

string

—

-

payment_id
default

string

→ payments

-

updated_at
default

date

—

-

Create

Refund a Payment

Refund a Payment

Route: POST /mutation/refunds

Inputs you can set
NameTypeRequiredDescription
amount_money.amountnumberYes-
amount_money.currencystringYes-
payment_ididYes-
reasonstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.