Facebook connection for LinkyFlow
LinkyFlow brings Facebook ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.
Resources
10
Read requests
7
Write actions
14
Documented fields
86
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.
Engagement
Comments
The comments on a Page’s posts — by people and by the Page —, with who wrote each, its likes and replies, whether it is hidden, and what the Page may do with it.
Comments
The comments on a Page’s posts — by people and by the Page —, with who wrote each, its likes and replies, whether it is hidden, and what the Page may do with it.
Route: GET /comments
Excel formula: =LF.facebook.comments("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
messagedefault | string | — | - |
from_namedefault | string | — | - |
created_timedefault | date | — | - |
like_countdefault | number | — | - |
is_hiddendefault | boolean | — | - |
Create Comment
Create Comment
Route: POST /mutation/comments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Comment
Update Comment
Route: PATCH /mutation/comments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Comment
Delete Comment
Route: DELETE /mutation/comments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Hide Comment
Hides this comment from everyone but its author and their friends, who are not told. Undone by Unhide Comment.
Hide Comment
Hide Comment
Route: POST /mutation/commentHide
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Reply to Comment
Replies to this comment as the Page, under it, for everyone who can see the post.
Reply to Comment
Reply to Comment
Route: POST /mutation/commentReply
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Unhide Comment
Shows this hidden comment again to everyone who can see the post.
Unhide Comment
Unhide Comment
Route: POST /mutation/commentUnhide
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Insights
Page Insights
What Facebook counts on a Page, metric by metric and period by period: views, reach, engagement, follows, video views. One row per metric and period end.
Page Insights
What Facebook counts on a Page, metric by metric and period by period: views, reach, engagement, follows, video views. One row per metric and period end.
Route: GET /pageInsights
Excel formula: =LF.facebook.pageInsights("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
id | id | — | - |
metricdefault | string | — | - |
perioddefault | string | — | - |
end_timedefault | date | — | - |
valuedefault | number | — | - |
breakdown | string | — | - |
title | string | — | - |
description | string | — | - |
page_id | id | — | - |
Post Insights
What Facebook counts on a post over its lifetime: views, people reached, clicks, reactions by kind. One row per metric.
Post Insights
What Facebook counts on a post over its lifetime: views, people reached, clicks, reactions by kind. One row per metric.
Route: GET /postInsights
Excel formula: =LF.facebook.postInsights("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
id | id | — | - |
metricdefault | string | — | - |
perioddefault | string | — | - |
end_timedefault | date | — | - |
valuedefault | number | — | - |
breakdown | string | — | - |
title | string | — | - |
description | string | — | - |
post_iddefault | id | — | - |
page_id | id | — | - |
Pages
Pages
The Facebook Pages the person granted LinkyFlow: each one’s profile, audience, what the person may do on it (tasks) and whether its access still works.
Used as filter by
Pages
The Facebook Pages the person granted LinkyFlow: each one’s profile, audience, what the person may do on it (tasks) and whether its access still works.
Route: GET /pages
Excel formula: =LF.facebook.pages("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
categorydefault | string | — | - |
followers_countdefault | number | — | - |
tasksdefault | string | — | - |
token_statusdefault | enum | — | - |
Publishing
Photos
The photos a Page uploaded, newest first: each one’s caption, size and address.
Photos
The photos a Page uploaded, newest first: each one’s caption, size and address.
Route: GET /photos
Excel formula: =LF.facebook.photos("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
created_timedefault | date | — | - |
updated_time | date | — | - |
urldefault | string | — | - |
picture | string | — | - |
width | number | — | - |
height | number | — | - |
page_id | id | — | - |
Create Photo
Create Photo
Route: POST /mutation/photos
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Photo
Delete Photo
Route: DELETE /mutation/photos
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Posts
The posts a Page published — text, links, photos, videos —, newest first, with how many reactions, comments and shares each received.
Used as filter by
Posts
The posts a Page published — text, links, photos, videos —, newest first, with how many reactions, comments and shares each received.
Route: GET /posts
Excel formula: =LF.facebook.posts("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
messagedefault | string | — | - |
created_timedefault | date | — | - |
urldefault | string | — | - |
reactions_countdefault | number | — | - |
comments_countdefault | number | — | - |
shares_countdefault | number | — | - |
Create Post
Create Post
Route: POST /mutation/posts
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Post
Update Post
Route: PATCH /mutation/posts
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Post
Delete Post
Route: DELETE /mutation/posts
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Videos
The videos a Page published, newest first: title, length, and where Facebook is with each (processing until it can be watched, ready, error).
Videos
The videos a Page published, newest first: title, length, and where Facebook is with each (processing until it can be watched, ready, error).
Route: GET /videos
Excel formula: =LF.facebook.videos("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
titledefault | string | — | - |
description | string | — | - |
created_timedefault | date | — | - |
updated_time | date | — | - |
urldefault | string | — | - |
length | number | — | - |
statusdefault | string | — | - |
published | boolean | — | - |
picture | string | — | - |
page_id | id | — | - |
Create Video
Create Video
Route: POST /mutation/videos
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Video
Update Video
Route: PATCH /mutation/videos
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Video
Delete Video
Route: DELETE /mutation/videos
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.