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

Klaviyo connection for LinkyFlow

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

Resources

35

Read requests

25

Write actions

50

Documented fields

352

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.

Account

Account

The Klaviyo account this connection reaches: its organisation, sender defaults, address, timezone and currency.

Read

Account

The Klaviyo account this connection reaches: its organisation, sender defaults, address, timezone and currency.

Route: GET /accounts

Excel formula: =LF.klaviyo.accounts("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
page_sizenumberNoKlaviyo pages this list by a size of its own. Default: 10
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

test_account
default

boolean

—

-

contact_information

string

—

-

default_sender_name

string

—

-

default_sender_email

string

—

-

website_url

string

—

-

organization_name
default

string

—

-

street_address

string

—

-

industry

string

—

-

timezone
default

string

—

-

preferred_currency
default

string

—

-

public_api_key

string

—

-

locale

string

—

-

Analytics

Campaign Values Reports

What each campaign message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.

Read

Campaign Values Reports

What each campaign message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.

Route: GET /campaignValuesReports

Excel formula: =LF.klaviyo.campaignValuesReports("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
timeframeenumNoThe period summed, as Klaviyo names it. Ignored when Start and End are both given. Default: last_30_days Values: today, yesterday, this_week, last_7_days, last_week
startstringNoThe start of a period of your own, a year at most (ISO 8601, 2026-01-31T00:00:00Z).
endstringNoThe end of that period (ISO 8601, 2026-01-31T00:00:00Z).
conversion_metric_ididYesThe metric a conversion is counted on (Placed Order, say).
statisticsstringNoThe statistics to sum, separated by commas. Empty: recipients, delivered, opens_unique, open_rate, clicks_unique, click_rate, conversions, c...
channelenumNoThe campaigns sent on this channel only. Values: email, sms, push-notification, whatsapp
campaign_ididNoThis campaign only.
page_sizenumberNoKlaviyo pages this list by a size of its own. Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
campaign_id
default

id

→ campaigns

-

campaign_message_id
default

id

—

-

send_channel
default

string

—

-

click_rate
default

number

—

-

clicks_unique
default

number

—

-

conversion_value
default

number

—

-

conversions
default

number

—

-

delivered
default

number

—

-

open_rate
default

number

—

-

opens_unique
default

number

—

-

recipients
default

number

—

-

unsubscribes
default

number

—

-

Events

What the account’s profiles did, one event a row: its metric, its profile, its moment and its properties.

Read

Events

What the account’s profiles did, one event a row: its metric, its profile, its moment and its properties.

Route: GET /events

Excel formula: =LF.klaviyo.events("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
metric_ididNoThe events of this metric only.
profile_ididNoThe events of this profile only.
datetime_fromstringNoAt or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
datetime_tostringNoBefore this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: datetime, -datetime, timestamp, -timestamp
page_sizenumberNoRows per page (max 1000). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

timestamp

number

—

-

event_properties

string

—

-

datetime
default

date

—

-

uuid

string

—

-

metric_id
default

id

—

-

metric

string

—

-

name
default

string

—

-

profile_id
default

id

—

-

Create

Track Event

Track Event

Route: POST /mutation/events

Inputs you can set
NameTypeRequiredDescription
backfillbooleanNo-
emailstringNo-
external_idstringNo-
metric_namestringYes-
phone_numberstringNo-
profile_ididNo-
propertiesstringNo-
timestringNo-
unique_idstringNo-
valuenumberNo-
value_currencystringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Flow Values Reports

What each flow message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.

Read

Flow Values Reports

What each flow message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.

Route: GET /flowValuesReports

Excel formula: =LF.klaviyo.flowValuesReports("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
timeframeenumNoThe period summed, as Klaviyo names it. Ignored when Start and End are both given. Default: last_30_days Values: today, yesterday, this_week, last_7_days, last_week
startstringNoThe start of a period of your own, a year at most (ISO 8601, 2026-01-31T00:00:00Z).
endstringNoThe end of that period (ISO 8601, 2026-01-31T00:00:00Z).
conversion_metric_ididYesThe metric a conversion is counted on (Placed Order, say).
statisticsstringNoThe statistics to sum, separated by commas. Empty: recipients, delivered, opens_unique, open_rate, clicks_unique, click_rate, conversions, c...
channelenumNoThe flows sent on this channel only. Values: email, sms, push-notification, whatsapp
flow_ididNoThis flow only.
page_sizenumberNoKlaviyo pages this list by a size of its own. Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
flow_id
default

id

→ flows

-

flow_message_id
default

id

—

-

send_channel
default

string

—

-

click_rate
default

number

—

-

clicks_unique
default

number

—

-

conversion_value
default

number

—

-

conversions
default

number

—

-

delivered
default

number

—

-

open_rate
default

number

—

-

opens_unique
default

number

—

-

recipients
default

number

—

-

unsubscribes
default

number

—

-

Metrics

The kinds of event the account records — Placed Order, Opened Email… — and the integration each comes from.

Read

Metrics

The kinds of event the account records — Placed Order, Opened Email… — and the integration each comes from.

Route: GET /metrics

Excel formula: =LF.klaviyo.metrics("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
integration_namestringNoThe metrics of this integration only (Shopify, API…).
integration_categorystringNoThe metrics of this kind of integration only.
page_sizenumberNoKlaviyo pages this list by a size of its own. Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

created
default

date

—

-

updated

date

—

-

integration

string

—

-

name
default

string

—

-

category

string

—

-

Audience

Add Profiles to List

Puts existing profiles on this list, by their ids. It changes no one’s consent: to subscribe a person, subscribe them.

Create

Add Profiles to List

Add Profiles to List

Route: POST /mutation/listAddProfiles

Inputs you can set
NameTypeRequiredDescription
listIdidYes-
profile_idsstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

List Profiles

The profiles on one list, with when each joined it.

Read

List Profiles

The profiles on one list, with when each joined it.

Route: GET /listProfiles

Excel formula: =LF.klaviyo.listProfiles("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
listIdidYesThe list whose profiles to read.
emailstringNoThe profile with exactly this email address.
phone_numberstringNoThe profile with exactly this phone number, in E.164 format (+33612345678).
joined_afterstringNoJoined the group at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
joined_beforestringNoJoined the group before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: joined_group_at, -joined_group_at
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

email
default

string

—

-

phone_number
default

string

—

-

first_name
default

string

—

-

last_name
default

string

—

-

created
default

date

—

-

Lists

The account’s lists: the groups of profiles a campaign is sent to, each with its opt-in process.

Used as filter by

Read

Lists

The account’s lists: the groups of profiles a campaign is sent to, each with its opt-in process.

Route: GET /lists

Excel formula: =LF.klaviyo.lists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
namestringNoThe list of exactly this name.
idsstringNoThese lists, their ids separated by commas.
created_afterstringNoCreated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_afterstringNoUpdated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created, id, -id, name
page_sizenumberNoRows per page (max 10). Default: 10
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

created
default

date

—

-

updated

date

—

-

opt_in_process
default

enum

—

-

Create

Create List

Create List

Route: POST /mutation/lists

Inputs you can set
NameTypeRequiredDescription
namestringYes-
opt_in_processenumNoValues: double_opt_in, single_opt_in
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update List

Update List

Route: PATCH /mutation/lists

Inputs you can set
NameTypeRequiredDescription
namestringYes-
opt_in_processenumNoValues: double_opt_in, single_opt_in
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete List

Delete List

Route: DELETE /mutation/lists

Inputs you can set
NameTypeRequiredDescription
namestringYes-
opt_in_processenumNoValues: double_opt_in, single_opt_in
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Profiles

The account’s profiles — the people it knows —, their location, custom properties and email and SMS consent.

Read

Profiles

The account’s profiles — the people it knows —, their location, custom properties and email and SMS consent.

Route: GET /profiles

Excel formula: =LF.klaviyo.profiles("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
emailstringNoThe profile with exactly this email address.
phone_numberstringNoThe profile with exactly this phone number, in E.164 format (+33612345678).
external_idstringNoThe profile with exactly this external id.
idsstringNoThese profiles, their ids separated by commas.
created_afterstringNoCreated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
created_beforestringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_afterstringNoUpdated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_beforestringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created, email, -email, id
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

email
default

string

—

-

phone_number
default

string

—

-

first_name
default

string

—

-

last_name
default

string

—

-

created
default

date

—

-

Create

Create Profile

Create Profile

Route: POST /mutation/profiles

Inputs you can set
NameTypeRequiredDescription
emailstringNo-
external_idstringNo-
first_namestringNo-
imagestringNo-
last_namestringNo-
localestringNo-
location.address1stringNo-
location.address2stringNo-
location.citystringNo-
location.countrystringNo-
location.ipstringNo-
location.latitudestringNo-
location.longitudestringNo-
location.regionstringNo-
location.timezonestringNo-
location.zipstringNo-
organizationstringNo-
phone_numberstringNo-
propertiesstringNo-
titlestringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Profile

Update Profile

Route: PATCH /mutation/profiles

Inputs you can set
NameTypeRequiredDescription
emailstringNo-
external_idstringNo-
first_namestringNo-
imagestringNo-
last_namestringNo-
localestringNo-
location.address1stringNo-
location.address2stringNo-
location.citystringNo-
location.countrystringNo-
location.ipstringNo-
location.latitudestringNo-
location.longitudestringNo-
location.regionstringNo-
location.timezonestringNo-
location.zipstringNo-
organizationstringNo-
phone_numberstringNo-
propertiesstringNo-
titlestringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Remove Profiles from List

Takes profiles off a list: they stay in the account, and no one’s consent changes.

Create

Remove Profiles from List

Remove Profiles from List

Route: POST /mutation/listProfilesRemove

Inputs you can set
NameTypeRequiredDescription
listIdidYes-
profile_idsstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Segment Profiles

The profiles in one segment, with when each joined it.

Read

Segment Profiles

The profiles in one segment, with when each joined it.

Route: GET /segmentProfiles

Excel formula: =LF.klaviyo.segmentProfiles("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
segmentIdidYesThe segment whose profiles to read.
emailstringNoThe profile with exactly this email address.
phone_numberstringNoThe profile with exactly this phone number, in E.164 format (+33612345678).
joined_afterstringNoJoined the group at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
joined_beforestringNoJoined the group before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: joined_group_at, -joined_group_at
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

email
default

string

—

-

phone_number
default

string

—

-

first_name
default

string

—

-

last_name
default

string

—

-

created
default

date

—

-

Segments

The account’s segments: groups of profiles Klaviyo keeps up to date from the conditions that define them.

Read

Segments

The account’s segments: groups of profiles Klaviyo keeps up to date from the conditions that define them.

Route: GET /segments

Excel formula: =LF.klaviyo.segments("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
namestringNoThe segment of exactly this name.
idsstringNoThese segments, their ids separated by commas.
is_activebooleanNoActive segments only, or inactive ones only.
is_starredbooleanNoStarred segments only, or the others only.
created_afterstringNoCreated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_afterstringNoUpdated after this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created, id, -id, name
page_sizenumberNoRows per page (max 10). Default: 10
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

definition

string

—

-

condition_groups

string

—

-

created
default

date

—

-

updated

date

—

-

is_active
default

boolean

—

-

is_processing

boolean

—

-

is_starred

boolean

—

-

Create

Create Segment

Create Segment

Route: POST /mutation/segments

Inputs you can set
NameTypeRequiredDescription
definition.condition_groupsstringYes-
is_starredbooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Segment

Update Segment

Route: PATCH /mutation/segments

Inputs you can set
NameTypeRequiredDescription
definition.condition_groupsstringYes-
is_starredbooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Segment

Delete Segment

Route: DELETE /mutation/segments

Inputs you can set
NameTypeRequiredDescription
definition.condition_groupsstringYes-
is_starredbooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Campaigns

Assign Template

Gives this message a copy of a template: later changes to the template do not reach it.

Create

Assign Template

Assign Template

Route: POST /mutation/campaignMessageAssignTemplate

Inputs you can set
NameTypeRequiredDescription
messageIdidYes-
template_ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Campaign Messages

The messages of one campaign: their channel, label, content and template.

Read

Campaign Messages

The messages of one campaign: their channel, label, content and template.

Route: GET /campaignMessages

Excel formula: =LF.klaviyo.campaignMessages("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
campaignIdidYesThe campaign whose messages to read.
page_sizenumberNoKlaviyo pages this list by a size of its own. Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

campaign_id
default

id

—

-

definition

string

—

-

channel
default

string

—

-

label
default

string

—

-

content

string

—

-

template_id

id

—

-

template

string

—

-

name

string

—

-

send_times

string

—

-

created_at

date

—

-

updated_at

date

—

-

Campaigns

The account’s campaigns — one channel each, email by default —, their audiences, send strategy, status and send time.

Read

Campaigns

The account’s campaigns — one channel each, email by default —, their audiences, send strategy, status and send time.

Route: GET /campaigns

Excel formula: =LF.klaviyo.campaigns("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
channelenumNoThe campaigns of this channel: Klaviyo lists one channel at a time, email when none is named. Default: email Values: email, sms, mobile_push
name_containsstringNoThe campaigns whose name holds this text.
statusenumNoThe campaigns in this status. Values: Draft, Scheduled, Sending, Sent, Cancelled
archivedbooleanNoArchived campaigns only, or the others only.
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created_at, -created_at, id, -id, name
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

status
default

enum

—

-

archived

boolean

—

-

audiences

string

—

-

included

string[]

—

-

excluded

string[]

—

-

created_at
default

date

—

-

scheduled_at

date

—

-

updated_at

date

—

-

send_time
default

date

—

-

send_strategy

string

—

-

method

string

—

-

datetime

date

—

-

send_options

string

—

-

use_smart_sending

boolean

—

-

tracking_options

string

—

-

is_tracking_opens

boolean

—

-

is_tracking_clicks

boolean

—

-

campaign_message_ids

string[]

—

-

tag_ids

string[]

—

-

can_send

boolean

—

-

can_cancel

boolean

—

-

Create

Create Campaign

Create Campaign

Route: POST /mutation/campaigns

Inputs you can set
NameTypeRequiredDescription
audiences.excludedstringNo-
audiences.includedstringYes-
channelenumNoValues: email, sms
message.bodystringNo-
message.from_emailstringNo-
message.from_labelstringNo-
message.labelstringNo-
message.preview_textstringNo-
message.reply_to_emailstringNo-
message.subjectstringNo-
namestringYes-
send_options.use_smart_sendingbooleanNo-
send_strategy.datestringNo-
send_strategy.datetimestringNo-
send_strategy.methodenumNoValues: immediate, static, throttled, smart_send_time
send_strategy.throttle_percentagenumberNo-
tracking_options.is_tracking_clicksbooleanNo-
tracking_options.is_tracking_opensbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Campaign

Update Campaign

Route: PATCH /mutation/campaigns

Inputs you can set
NameTypeRequiredDescription
audiences.excludedstringNo-
audiences.includedstringYes-
channelenumNoValues: email, sms
message.bodystringNo-
message.from_emailstringNo-
message.from_labelstringNo-
message.labelstringNo-
message.preview_textstringNo-
message.reply_to_emailstringNo-
message.subjectstringNo-
namestringYes-
send_options.use_smart_sendingbooleanNo-
send_strategy.datestringNo-
send_strategy.datetimestringNo-
send_strategy.methodenumNoValues: immediate, static, throttled, smart_send_time
send_strategy.throttle_percentagenumberNo-
tracking_options.is_tracking_clicksbooleanNo-
tracking_options.is_tracking_opensbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Campaign

Delete Campaign

Route: DELETE /mutation/campaigns

Inputs you can set
NameTypeRequiredDescription
audiences.excludedstringNo-
audiences.includedstringYes-
channelenumNoValues: email, sms
message.bodystringNo-
message.from_emailstringNo-
message.from_labelstringNo-
message.labelstringNo-
message.preview_textstringNo-
message.reply_to_emailstringNo-
message.subjectstringNo-
namestringYes-
send_options.use_smart_sendingbooleanNo-
send_strategy.datestringNo-
send_strategy.datetimestringNo-
send_strategy.methodenumNoValues: immediate, static, throttled, smart_send_time
send_strategy.throttle_percentagenumberNo-
tracking_options.is_tracking_clicksbooleanNo-
tracking_options.is_tracking_opensbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Campaign Send

Stops a campaign whose send is under way: cancel stops it for good, revert puts it back to draft.

Create

Cancel Campaign Send

Cancel Campaign Send

Route: POST /mutation/campaignCancelSend

Inputs you can set
NameTypeRequiredDescription
actionenumYesValues: cancel, revert
campaignIdidYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Clone Campaign

Copies this campaign into a new draft.

Create

Clone Campaign

Clone Campaign

Route: POST /mutation/campaignClone

Inputs you can set
NameTypeRequiredDescription
campaignIdidYes-
new_namestringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Send Campaign

Sends this draft campaign by its send strategy — at once, or at the date it names — to every recipient of its audiences. It cannot be recalled.

Create

Send Campaign

Send Campaign

Route: POST /mutation/campaignSend

Inputs you can set
NameTypeRequiredDescription
campaignIdidYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Catalog

Catalog Categories

The categories of the account’s own catalog.

Read

Catalog Categories

The categories of the account’s own catalog.

Route: GET /catalogCategories

Excel formula: =LF.klaviyo.catalogCategories("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
idsstringNoThese categories, their ids separated by commas.
item_ididNoThe categories of this item only.
name_containsstringNoThe categories whose name holds this text.
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

external_id
default

string

—

-

name
default

string

—

-

updated
default

date

—

-

Create

Create Catalog Category

Create Catalog Category

Route: POST /mutation/catalogCategories

Inputs you can set
NameTypeRequiredDescription
external_idstringYes-
item_idsstringNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Catalog Category

Update Catalog Category

Route: PATCH /mutation/catalogCategories

Inputs you can set
NameTypeRequiredDescription
external_idstringYes-
item_idsstringNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Catalog Category

Delete Catalog Category

Route: DELETE /mutation/catalogCategories

Inputs you can set
NameTypeRequiredDescription
external_idstringYes-
item_idsstringNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Catalog Items

The items of the account’s own catalog ($custom), as its messages and product feeds show them. An item synced by a store’s integration is changed in the store.

Read

Catalog Items

The items of the account’s own catalog ($custom), as its messages and product feeds show them. An item synced by a store’s integration is changed in the store.

Route: GET /catalogItems

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

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
idsstringNoThese items, their ids separated by commas.
category_ididNoThe items of this category only.
title_containsstringNoThe items whose title holds this text.
publishedbooleanNoPublished items only, or the others only.
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

external_id
default

string

—

-

title
default

string

—

-

price
default

number

—

-

published
default

boolean

—

-

updated
default

date

—

-

Create

Create Catalog Item

Create Catalog Item

Route: POST /mutation/catalogItems

Inputs you can set
NameTypeRequiredDescription
category_idsstringNo-
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
pricenumberNo-
publishedbooleanNo-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Catalog Item

Update Catalog Item

Route: PATCH /mutation/catalogItems

Inputs you can set
NameTypeRequiredDescription
category_idsstringNo-
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
pricenumberNo-
publishedbooleanNo-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Catalog Item

Delete Catalog Item

Route: DELETE /mutation/catalogItems

Inputs you can set
NameTypeRequiredDescription
category_idsstringNo-
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
pricenumberNo-
publishedbooleanNo-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Catalog Variants

The variants of the account’s own catalog items: their SKU, price and stock, as its messages show them.

Read

Catalog Variants

The variants of the account’s own catalog items: their SKU, price and stock, as its messages show them.

Route: GET /catalogVariants

Excel formula: =LF.klaviyo.catalogVariants("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
idsstringNoThese variants, their ids separated by commas.
item_ididNoThe variants of this item only.
skustringNoThe variant of exactly this SKU.
title_containsstringNoThe variants whose title holds this text.
publishedbooleanNoPublished variants only, or the others only.
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

title
default

string

—

-

sku
default

string

—

-

inventory_quantity
default

number

—

-

price
default

number

—

-

updated
default

date

—

-

item_id
default

id

→ catalogItems

-

Create

Create Catalog Variant

Create Catalog Variant

Route: POST /mutation/catalogVariants

Inputs you can set
NameTypeRequiredDescription
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
inventory_policyenumNoValues: 0, 1, 2
inventory_quantitynumberYes-
item_ididYes-
pricenumberYes-
publishedbooleanNo-
skustringYes-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Catalog Variant

Update Catalog Variant

Route: PATCH /mutation/catalogVariants

Inputs you can set
NameTypeRequiredDescription
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
inventory_policyenumNoValues: 0, 1, 2
inventory_quantitynumberYes-
item_ididYes-
pricenumberYes-
publishedbooleanNo-
skustringYes-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Catalog Variant

Delete Catalog Variant

Route: DELETE /mutation/catalogVariants

Inputs you can set
NameTypeRequiredDescription
custom_metadatastringNo-
descriptionstringYes-
external_idstringYes-
image_full_urlstringNo-
image_thumbnail_urlstringNo-
imagesstringNo-
inventory_policyenumNoValues: 0, 1, 2
inventory_quantitynumberYes-
item_ididYes-
pricenumberYes-
publishedbooleanNo-
skustringYes-
titlestringYes-
urlstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Content

Clone Template

Copies this template into a new one.

Create

Clone Template

Clone Template

Route: POST /mutation/templateClone

Inputs you can set
NameTypeRequiredDescription
namestringNo-
templateIdidYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Forms

The account’s sign-up forms: their status and whether they run an A/B test. They are designed in Klaviyo.

Read

Forms

The account’s sign-up forms: their status and whether they run an A/B test. They are designed in Klaviyo.

Route: GET /forms

Excel formula: =LF.klaviyo.forms("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
name_containsstringNoThe forms whose name holds this text.
statusenumNoThe forms in this status. Values: draft, live
ab_testbooleanNoThe forms with an A/B test only, or the others only.
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created_at, -created_at, updated_at, -updated_at
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

status
default

enum

—

-

ab_test

boolean

—

-

created_at

date

—

-

updated_at
default

date

—

-

Templates

The account’s email templates: their name, editor and plain text. Their HTML is edited in Klaviyo, and never read into a row.

Read

Templates

The account’s email templates: their name, editor and plain text. Their HTML is edited in Klaviyo, and never read into a row.

Route: GET /templates

Excel formula: =LF.klaviyo.templates("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
namestringNoThe template of exactly this name.
name_containsstringNoThe templates whose name holds this text.
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created, id, -id, name
page_sizenumberNoRows per page (max 10). Default: 10
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

editor_type
default

string

—

-

text

string

—

-

created

date

—

-

updated
default

date

—

-

Create

Create Template

Create Template

Route: POST /mutation/templates

Inputs you can set
NameTypeRequiredDescription
editor_typeenumYesValues: CODE, USER_DRAGGABLE
htmlstringYes-
namestringYes-
textstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Template

Update Template

Route: PATCH /mutation/templates

Inputs you can set
NameTypeRequiredDescription
editor_typeenumYesValues: CODE, USER_DRAGGABLE
htmlstringYes-
namestringYes-
textstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Template

Delete Template

Route: DELETE /mutation/templates

Inputs you can set
NameTypeRequiredDescription
editor_typeenumYesValues: CODE, USER_DRAGGABLE
htmlstringYes-
namestringYes-
textstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Coupons

Coupon Codes

The codes of a coupon, or those handed to a profile: their status and expiry. Klaviyo lists them by coupon or by profile.

Read

Coupon Codes

The codes of a coupon, or those handed to a profile: their status and expiry. Klaviyo lists them by coupon or by profile.

Route: GET /couponCodes

Excel formula: =LF.klaviyo.couponCodes("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
coupon_ididNoThe codes of this coupon. Klaviyo needs a coupon or a profile.
profile_ididNoThe codes handed to this profile. Klaviyo needs a coupon or a profile.
statusenumNoThe codes in this status. Values: UNASSIGNED, PROCESSING, ASSIGNED_TO_PROFILE, VERSION_NOT_ACTIVE, DELETING
expires_fromstringNoExpiring at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
expires_tostringNoExpiring before this moment (ISO 8601, 2026-01-31T00:00:00Z).
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

unique_code
default

string

—

-

expires_at
default

date

—

-

status
default

enum

—

-

coupon_id
default

id

—

-

coupon

string

—

-

external_id

string

—

-

profile_id

id

—

-

Create

Create Coupon Code

Create Coupon Code

Route: POST /mutation/couponCodes

Inputs you can set
NameTypeRequiredDescription
coupon_ididYes-
expires_atstringNo-
unique_codestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Coupon Code

Update Coupon Code

Route: PATCH /mutation/couponCodes

Inputs you can set
NameTypeRequiredDescription
coupon_ididYes-
expires_atstringNo-
unique_codestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Coupon Code

Delete Coupon Code

Route: DELETE /mutation/couponCodes

Inputs you can set
NameTypeRequiredDescription
coupon_ididYes-
expires_atstringNo-
unique_codestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Coupons

The account’s coupons — each a discount of a store, by its id there —, and how Klaviyo hands out their codes.

Used as filter by

Read

Coupons

The account’s coupons — each a discount of a store, by its id there —, and how Klaviyo hands out their codes.

Route: GET /coupons

Excel formula: =LF.klaviyo.coupons("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
page_sizenumberNoRows per page (max 100). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

external_id
default

string

—

-

description
default

string

—

-

monitor_configuration

string

—

-

assigner_configuration

string

—

-

used

enum

—

-

unused_expired

enum

—

-

Create

Create Coupon

Create Coupon

Route: POST /mutation/coupons

Inputs you can set
NameTypeRequiredDescription
assigner_configuration.unused_expiredenumNoValues: ALWAYS_ASSIGN, NEVER_ASSIGN
assigner_configuration.usedenumNoValues: ALWAYS_ASSIGN, ASSIGN_IF_EXPIRED, NEVER_ASSIGN
descriptionstringNo-
external_idstringYes-
monitor_configurationstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Coupon

Update Coupon

Route: PATCH /mutation/coupons

Inputs you can set
NameTypeRequiredDescription
assigner_configuration.unused_expiredenumNoValues: ALWAYS_ASSIGN, NEVER_ASSIGN
assigner_configuration.usedenumNoValues: ALWAYS_ASSIGN, ASSIGN_IF_EXPIRED, NEVER_ASSIGN
descriptionstringNo-
external_idstringYes-
monitor_configurationstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Coupon

Delete Coupon

Route: DELETE /mutation/coupons

Inputs you can set
NameTypeRequiredDescription
assigner_configuration.unused_expiredenumNoValues: ALWAYS_ASSIGN, NEVER_ASSIGN
assigner_configuration.usedenumNoValues: ALWAYS_ASSIGN, ASSIGN_IF_EXPIRED, NEVER_ASSIGN
descriptionstringNo-
external_idstringYes-
monitor_configurationstringNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Flows

Flow Actions

The steps of one flow — a message sent, a delay, a split —, each as Klaviyo defines it.

Read

Flow Actions

The steps of one flow — a message sent, a delay, a split —, each as Klaviyo defines it.

Route: GET /flowActions

Excel formula: =LF.klaviyo.flowActions("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
flowIdidYesThe flow whose actions to read.
action_typestringNoThe actions of this type only (SEND_EMAIL, TIME_DELAY…).
statusstringNoThe actions in this status only.
page_sizenumberNoRows per page (max 50). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

flow_id
default

id

—

-

definition
default

string

—

-

flow_message_ids

string[]

—

-

created
default

date

—

-

updated

date

—

-

Flows

The account’s flows: the automations that message profiles on their own, from a trigger (a list joined, a metric, a date).

Read

Flows

The account’s flows: the automations that message profiles on their own, from a trigger (a list joined, a metric, a date).

Route: GET /flows

Excel formula: =LF.klaviyo.flows("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
name_containsstringNoThe flows whose name holds this text.
statusenumNoThe flows in this status. Values: draft, manual, live
archivedbooleanNoArchived flows only, or the others only.
trigger_typeenumNoThe flows of this trigger. Values: Added to List, Date Based, Low Inventory, Metric, Price Drop
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z).
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: created, -created, id, -id, name
page_sizenumberNoRows per page (max 50). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

status
default

string

—

-

archived

boolean

—

-

created

date

—

-

updated
default

date

—

-

trigger_type
default

enum

—

-

tag_ids

string[]

—

-

Edit

Change Flow Status

Change Flow Status

Route: PATCH /mutation/flows

Inputs you can set
NameTypeRequiredDescription
statusenumYesValues: draft, manual, live
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Flow

Delete Flow

Route: DELETE /mutation/flows

Inputs you can set
NameTypeRequiredDescription
statusenumYesValues: draft, manual, live
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tags

Tag Groups

The groups of tags: an exclusive group lets a record carry one of its tags at most.

Read

Tag Groups

The groups of tags: an exclusive group lets a record carry one of its tags at most.

Route: GET /tagGroups

Excel formula: =LF.klaviyo.tagGroups("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
name_containsstringNoThe groups whose name holds this text.
exclusivebooleanNoExclusive groups only, or the others only.
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: id, -id, name, -name
page_sizenumberNoRows per page (max 25). Default: 25
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

exclusive
default

boolean

—

-

default
default

boolean

—

-

Create

Create Tag Group

Create Tag Group

Route: POST /mutation/tagGroups

Inputs you can set
NameTypeRequiredDescription
exclusivebooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Tag Group

Update Tag Group

Route: PATCH /mutation/tagGroups

Inputs you can set
NameTypeRequiredDescription
exclusivebooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Tag Group

Delete Tag Group

Route: DELETE /mutation/tagGroups

Inputs you can set
NameTypeRequiredDescription
exclusivebooleanNo-
namestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tags

The tags that sort the account’s campaigns, flows, lists and segments, each in its tag group.

Read

Tags

The tags that sort the account’s campaigns, flows, lists and segments, each in its tag group.

Route: GET /tags

Excel formula: =LF.klaviyo.tags("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is Klaviyo’s refusal.
name_containsstringNoThe tags whose name holds this text.
sortenumNoThe order of the rows: a field, oldest or lowest first; - before it for the latest or highest first. Values: id, -id, name, -name
page_sizenumberNoRows per page (max 50). Default: 50
cursorstringNoThe cursor the previous page answered: empty for the first page.
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

tag_group_id
default

id

—

-

tag_group

string

—

-

name
default

string

—

-

Create

Create Tag

Create Tag

Route: POST /mutation/tags

Inputs you can set
NameTypeRequiredDescription
namestringYes-
tag_group_ididNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Tag

Update Tag

Route: PATCH /mutation/tags

Inputs you can set
NameTypeRequiredDescription
namestringYes-
tag_group_ididNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Tag

Delete Tag

Route: DELETE /mutation/tags

Inputs you can set
NameTypeRequiredDescription
namestringYes-
tag_group_ididNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.