Pricing

from $0.70 / 1,000 input rows

Try for free

Go to Apify Store

Dataset Aggregate, Group By & Pivot

Try for free

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Pricing

from $0.70 / 1,000 input rows

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

19 days ago

Last modified

Configure MCP server with Dataset Aggregate, Group By & Pivot - SQL GROUP BY on Apify

The configuration above connects to the hosted Apify MCP server with the Dataset Aggregate, Group By & Pivot - SQL GROUP BY on Apify Actor already loaded. It uses OAuth, so your client opens a browser window to sign you in to Apify on first use. No API token is needed. Clients without OAuth support can authenticate with an Authorization: Bearer header carrying an API token from API & Integrations in Apify Console.

Get a ready-to-use configuration for your MCP client with the Dataset Aggregate, Group By & Pivot - SQL GROUP BY on Apify Actor preconfigured at https://mcp.apify.com/?tools=fetch-actor-details,nerolabs/dataset-aggregate-pivot.

You can connect to the Apify MCP Server using clients like Tester MCP Client, or any other MCP client of your choice.

If you want to learn more about our Apify MCP implementation, check out our MCP documentation. To learn more about the Model Context Protocol in general, refer to the official MCP documentation or read our blog post.

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by URL, or JSON array, plus CSV and Excel files, named-dataset append and webhook delivery. Inputs: source, dedup keys, flatten, cleaning options. Agent-ready: pay per event (x402, MCP), per cleaned record.

Adam Pearce

Facebook Group Posts Scraper

khadinakbar/facebook-group-posts-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, reaction/comment/share counts, media URLs, top comments, and pagination cursors. No login or cookies required. MCP/API-ready.

Khadin Akbar

Dataset Filter & Transform

nerolabs/dataset-filter-transform

Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter rules (25 operators, AND/OR) after transforms (rename, cast, compute, regex, dates, replace, split, hash), then sort, dedupe, limit, export CSV/Excel or webhook. Agent-ready: pay per event (x402, MCP).

Adam Pearce

Send HTTP Requests in Bulk: Dataset, CSV or Sheet to REST API

nerolabs/dataset-to-rest-api

Sends every row of an Apify dataset, file or Google Sheet URL, or JSON array to any REST API as its own request. Templated URL, body and headers with {{field}} placeholders, auth presets, rate limits, retries. One result row per request. Charged per answered request. Agent-ready via x402 and MCP.

Adam Pearce

Facebook Group Posts Scraper

powerai/facebook-group-posts-scraper

Search Facebook group posts by keywords—optional group and date filters—with authors, text, reactions, and media in structured rows.

PowerAI

182

5.0

Facebook Groups Scraper

khadinakbar/facebook-groups-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, engagement counts, media URLs, top comments, and pagination cursors. MCP/API-ready.

Khadin Akbar

Facebook Group Posts

monumental_world/facebook-group-posts

Get Facebook group posts.

Raised Pro

Facebook Group Posts Scraper (no cookies)

data_direct/facebook-group-posts-scraper

Get posts from a Facebook group

Data Direct

Dataset Diff & Change Detector

nerolabs/dataset-diff-detector

Returns what was added, removed or changed between two Apify datasets, files or Google Sheets by URL, or JSON arrays, matched by key, field by field, or since its own last run (snapshot mode). CSV/Excel diff report, named-dataset change log, webhook delivery. Agent-ready: pay per event (x402, MCP).

Adam Pearce

Facebook Group Scraper | $0.90/1K Results | Pay Per Result

getanyapi/facebook-group-posts-scraper

Extract posts from any public Facebook group. Add a group URL and get ID, post URL, text, author name and ID, publish time, reactions, and comment count. Export to JSON or CSV. Free plans get 200 results a month. $0.90 per 1,000 results, pay per result. Served by AnyAPI.