How do I export Facebook group posts to CSV or Google Sheets?
Updated on · Sources
Call GET /facebook/groups/posts for the group, page back with end_cursor (or set after_time / before_time for a date range), and write one row per post: details.post_id, details.post_link, values.text, reactions.total_reaction_count, details.comments_count, details.share_count. Save the rows as a CSV file, or append them to Google Sheets with an automation tool such as n8n, Make or Zapier.
Meta's official option
Meta has no export for a group's posts: the Groups API was removed on April 22, 2024, and Facebook's own download tool covers your own information, not a whole group.
How to do it with SocialAPIs
Each call returns 3 to 9 posts (limit) and data.page_info: while has_next is true, pass end_cursor to the next call. A group with 500 posts a month (number_of_posts_in_last_month from /facebook/groups/details) is about 56 calls at limit=9. Price per call: 1 credit; round(limit ÷ 3) credits when limit is set, up to 3.
Google Sheets without code, in n8n: Schedule Trigger → HTTP Request (header x-api-token) → Split Out data.posts → Remove Duplicates on details.post_id → Google Sheets (append a row). Make and Zapier do the same with their HTTP and Google Sheets steps.
In Python, csv.DictWriter with those six fields is enough; the monitoring tutorial shows the request and a real response.
Endpoints
GET /facebook/groups/posts1 credit; round(limit ÷ 3) credits when limit is set, up to 3
Fetch recent posts from a Facebook group, including text, media, reactions, and comments.
Params:
link(required),limit,end_cursor,timezoneFacebook Group Posts: docs and playgroundMCP:
facebook_group→postsGET /facebook/groups/details1 credit
Get detailed metadata and statistics about a Facebook group including member count, description, and rules.
Params:
link(required)Facebook Group Details: docs and playgroundMCP:
facebook_group→details
curl -G "https://api.socialapis.io/facebook/groups/posts" \
--max-time 100 \
--fail-with-body \
-H "x-api-token: $SOCIALAPIS_API_KEY" \
--data-urlencode "link=https://www.facebook.com/groups/gieldagryplanszowe" \
--data-urlencode "limit=9" \
--data-urlencode "timezone=UTC"import os
import requests
response = requests.get(
"https://api.socialapis.io/facebook/groups/posts",
headers={"x-api-token": os.environ["SOCIALAPIS_API_KEY"]},
params={
"link": "https://www.facebook.com/groups/gieldagryplanszowe",
"limit": "9",
"timezone": "UTC",
},
timeout=100,
)
response.raise_for_status()
print(response.json())// Node 18+, as an ES module (e.g. main.mjs)
async function get(url, params) {
const query = new URLSearchParams(params).toString();
const response = await fetch(query ? `${url}?${query}` : url, {
headers: { "x-api-token": process.env.SOCIALAPIS_API_KEY },
signal: AbortSignal.timeout(100000),
});
if (!response.ok) throw new Error(`HTTP ${response.status}: ${await response.text()}`);
return response.json();
}
const data = await get("https://api.socialapis.io/facebook/groups/posts", {
link: "https://www.facebook.com/groups/gieldagryplanszowe",
limit: "9",
timezone: "UTC",
});
console.log(data);import java.net.URI;
import java.net.URLEncoder;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.nio.charset.StandardCharsets;
import java.time.Duration;
import java.util.Map;
import java.util.stream.Collectors;
public class Main {
private static final HttpClient CLIENT = HttpClient.newBuilder()
.connectTimeout(Duration.ofSeconds(10))
.build();
public static void main(String[] args) throws Exception {
String body = get("https://api.socialapis.io/facebook/groups/posts", Map.of(
"link", "https://www.facebook.com/groups/gieldagryplanszowe",
"limit", "9",
"timezone", "UTC"));
System.out.println(body);
}
static String get(String url, Map<String, String> params) throws Exception {
String query = params.entrySet().stream()
.map(e -> URLEncoder.encode(e.getKey(), StandardCharsets.UTF_8) + "="
+ URLEncoder.encode(e.getValue(), StandardCharsets.UTF_8))
.collect(Collectors.joining("&"));
HttpRequest request = HttpRequest.newBuilder(URI.create(query.isEmpty() ? url : url + "?" + query))
.header("x-api-token", System.getenv("SOCIALAPIS_API_KEY"))
.timeout(Duration.ofSeconds(100))
.GET()
.build();
HttpResponse<String> response = CLIENT.send(request, HttpResponse.BodyHandlers.ofString());
if (response.statusCode() / 100 != 2) {
throw new RuntimeException("HTTP " + response.statusCode() + ": " + response.body());
}
return response.body();
}
}package main
import (
"fmt"
"io"
"log"
"net/http"
"net/url"
"os"
"time"
)
func main() {
body, err := get("https://api.socialapis.io/facebook/groups/posts", url.Values{
"link": {"https://www.facebook.com/groups/gieldagryplanszowe"},
"limit": {"9"},
"timezone": {"UTC"},
})
if err != nil {
log.Fatal(err)
}
fmt.Println(string(body))
}
func get(endpoint string, params url.Values) ([]byte, error) {
if len(params) > 0 {
endpoint += "?" + params.Encode()
}
req, err := http.NewRequest(http.MethodGet, endpoint, nil)
if err != nil {
return nil, err
}
req.Header.Set("x-api-token", os.Getenv("SOCIALAPIS_API_KEY"))
client := &http.Client{Timeout: 100 * time.Second}
resp, err := client.Do(req)
if err != nil {
return nil, err
}
defer resp.Body.Close()
body, err := io.ReadAll(resp.Body)
if err != nil {
return nil, err
}
if resp.StatusCode/100 != 2 {
return nil, fmt.Errorf("HTTP %d: %s", resp.StatusCode, body)
}
return body, nil
}# pip install socialapis-sdk
import os
from socialapis import Facebook
client = Facebook(api_token=os.environ["SOCIALAPIS_API_KEY"])
response = client.get_group_posts(
"https://www.facebook.com/groups/gieldagryplanszowe",
limit=9,
timezone="UTC",
)
print(response)// npm install socialapis-sdk
import { Facebook } from "socialapis-sdk";
const client = new Facebook({ apiToken: process.env.SOCIALAPIS_API_KEY });
const response = await client.getGroupPosts("https://www.facebook.com/groups/gieldagryplanszowe", {
limit: 9,
timezone: "UTC",
});
console.log(response);Your API key goes in the x-api-token header (here from the SOCIALAPIS_API_KEY environment variable). Get a free key.
Tutorial: Monitor a Facebook group's new posts automaticallyUse it from Claude, ChatGPT or Cursor (MCP)
Good to know
details.comments_countanddetails.share_countcome as strings ("0"): convert them before sorting.- Leave authors out of the sheet unless you need them:
user_details.nameis personal data (GDPR applies in the EU and UK). - Export for analysis or archiving, not to republish: the posts belong to their authors.
- Public groups only.
Sources
- Meta for Developers: Graph API v19.0 changelog (Groups API deprecated; removed for all versions on April 22, 2024) (2024-01-23)
Checked on 2026-11-16.