LinkyFlow for Klaviyo
The Klaviyo connection brings one Klaviyo account into Excel and the LinkyFlow web app: what each campaign and flow achieved, its profiles with their email and SMS consent, its lists and segments, its metrics and events, its campaigns, flows, templates and sign-up forms, its tags, catalog and coupons. You connect with a private API key of the account. Load them as structured tables, next to your store and payment data in the same workbook, and analyse them with your formulas. It writes only what you ask, from the Actions pane, each change confirmed before it runs.
Key capabilities
Campaign and flow results
Campaign Values Reports and Flow Values Reports read what each campaign message or flow message achieved over a period, as Klaviyo sums it: recipients, deliveries, opens, clicks, conversions, conversion value, unsubscribes and any other statistic Klaviyo offers. Pick a Time Frame Klaviyo names (the last 30 days by default) or a Start and End of your own, and the Conversion Metric a conversion is counted on — Placed Order, say. A rate is a fraction of 1.
Profiles and consent
Profiles reads the people the account knows: their email, phone number, location, custom properties, and their email and SMS marketing consent with when and how it was given. Filter by email, phone number, your own id for them, or a creation or update date. Profile Suppressions and Profile Unsuppressions read the jobs that suppressed profiles — a suppressed profile receives no email marketing, whatever its consent — or lifted a suppression.
Lists and segments
Lists reads the groups of profiles a campaign is sent to, and List Profiles the members of one list with when each joined. Segments reads the groups Klaviyo keeps up to date from their conditions, and Segment Profiles the members of one segment.
Metrics and events
Metrics reads the kinds of event the account records — Placed Order, Opened Email… — and the integration each comes from. Events reads what the profiles did, one event a row, with its metric, profile, moment and properties.
Campaigns, flows and content
Campaigns reads the campaigns with their channel, audiences, send strategy, status and send time; Campaign Messages the messages of one campaign. Flows reads the automations that message profiles on their own, and Flow Actions the steps of one flow. Templates reads the email templates with their name, editor and plain text — their HTML is edited in Klaviyo and never read into a row. Forms reads the sign-up forms, designed in Klaviyo; Tags and Tag Groups the tags that sort campaigns, flows, lists and segments.
Catalog and coupons
Catalog Items, Catalog Variants and Catalog Categories read the account's own catalog, as its messages and product feeds show it. Coupons and Coupon Codes read the coupons the account hands out and their codes, with their status and expiry.
Edits published back to Klaviyo
From the Actions pane of Excel or the web app, one record at a time, each change confirmed before it runs:
- Profiles: create or update a profile.
- Lists and segments: create, rename or delete a list; Add Profiles to List and Remove Profiles from List by their ids, without changing anyone's consent; create, update or delete a segment.
- Campaigns: create a draft email or SMS campaign and update it; Send Campaign sends a draft — LinkyFlow reads the campaign first and refuses anything but a draft; Cancel Campaign Send stops a send under way for good or puts it back to draft; Clone Campaign copies it into a new draft; Assign Template gives a campaign message a copy of a template.
- Flows: Change Flow Status to draft, manual or live, or delete a flow.
- Content: create, update, delete or clone a template; create, rename or delete tags and tag groups.
- Catalog and coupons: create, update or delete catalog items, variants and categories, coupons and coupon codes.
- Consent: Subscribe Profile and Unsubscribe Profile, with the person's consent; Suppress Profile and Unsuppress Profile; Request Profile Deletion, a person's erasure at their request (GDPR); Track Event records an event on a profile.
What you can do:
- Load campaign and flow results next to your Shopify orders or Stripe payouts, and compute your own return per campaign
- Clean up lists and segments from a sheet: read their members, add or remove profiles in one action
- Prepare a draft campaign in the sheet and send it only once you decide
- Read a table in a cell with the
=LF.klaviyofunctions - Read the same account from ChatGPT or Claude through MCP
How lists are read
Klaviyo pages through a list with a cursor, and each list has its own page size, from 10 to 1,000 rows. All results walks at most 200 pages and says so when the answer is incomplete. List Profiles, Segment Profiles, Campaign Messages and Flow Actions read one list, segment, campaign or flow at a time: give its id.
Values reports
Klaviyo answers Campaign Values Reports and Flow Values Reports 2 times a minute and 225 times a day. Ask for the period and the statistics you need in one report rather than in several.
Agents
The Inventory Stock Sync, Price Sync and Omnichannel Sales agents work on stores: Klaviyo holds no stock and no sales channel of its own, so it is not one of their connections.
ChatGPT and Claude
Through MCP, an assistant reads every table with the same connection and can prepare a draft campaign. Send Campaign, Cancel Campaign Send, a flow made live, a deletion, a person's profile changed and profiles put on a list are previewed first and run only once you confirm. Consent changes (subscribe, unsubscribe, suppress), Request Profile Deletion, Track Event and the catalog and coupon writes are never offered to an assistant: a person does them in the Actions pane.
What is not done
No campaign is sent unless it is a draft and you confirm it. A template's HTML is never read into a row. A catalog item synced by a store's integration is changed in the store, not here. No customer data is logged beyond what a read returns to you.
Next steps: