[Cotlet](https://cotlet.dev/index.md) · [Integrations](https://cotlet.dev/integrations.md) · [How it works](https://cotlet.dev/how-it-works.md) · [Use cases](https://cotlet.dev/use-cases.md) · [Security](https://cotlet.dev/security.md) · [For developers](https://cotlet.dev/for-developers.md) · [For automation agencies](https://cotlet.dev/for-agencies.md) · [Blog](https://cotlet.dev/blog.md) · [API docs](https://cotlet.dev/docs.md) · [Help center](https://cotlet.dev/help.md) · [Changelog](https://cotlet.dev/changelog.md) · [Contact](https://cotlet.dev/contact.md) · [Pricing](https://cotlet.dev/pricing.md) · [Sign up](https://cotlet.dev/signup)

# Write a weekly Sprout Social performance summary

> Pull last week's Sprout Social post and profile numbers, compare them with the week before and get a short written summary every Monday.

Source: https://cotlet.dev/integrations/sprout-social-api-mcp-server/weekly-performance-report

The numbers for last week are in Sprout, but someone still has to open the reports, compare them with the week before and explain which posts worked.

Cotlet does it in your own Sprout Social account with list\_profiles, get\_profile\_performance and get\_post\_performance, called by your AI agent, an n8n workflow or a script.

[Sign up free](https://cotlet.dev/app/signup?app=sprout-social) [All Sprout Social tools](https://cotlet.dev/integrations/sprout-social-api-mcp-server.md)

Hosted · nothing to install or maintain

## Can Sprout Social do this on its own?

Sprout already schedules report PDFs weekly or monthly to up to 25 recipients, and custom reports need Premium Analytics (checked 17 Oct 2026). The PDF shows fixed widgets and writes no explanation. The Sprout API returns the same post and profile numbers on the Advanced plan, at 60 requests per minute. Sprout's MCP server is documented for ChatGPT only and limited to TikTok data. If a scheduled PDF is enough for you, you do not need this job.

## How you do it in Sprout Social today

1. Open Reports, choose a profile or post report and set the date range to last week.
2. Read the post-level table and sort it by the metric you care about.
3. Repeat for the previous week to see the change, and for each profile.
4. For a repeating report, build a custom report under Reports > Custom Reports > Build Report, name it, pick widgets and save.
5. Share, download or schedule it; a scheduled PDF goes out weekly or monthly to up to 25 recipients.

## How to write a weekly Sprout Social performance summary

Prompt

```
Every Monday, pull last week's post performance for all my Sprout profiles, name the three best posts and the weakest one, compare impressions with the week before, and write it as a short summary I can paste into Slack.
```

1. 01  
### Fix the two windows  
The agent sets last Monday to Sunday and the week before as two separate ranges, so the comparison never mixes a partial current week with a full one.
2. 02  
### Get the profile totals  
get\_profile\_performance runs once per window for every profile from list\_profiles, which gives the week-over-week change you quote at the top of the summary.
3. 03  
### Rank the posts  
get\_post\_performance pulls post-level numbers for the last week, and the agent picks the best three by engagements and the weakest one among posts with a similar reach.
4. 04  
### Explain, do not guess  
Each post is described from its own text, network and numbers. The agent does not claim a cause it cannot see, such as a paid boost or an outage.
5. 05  
### Hand it to your channel  
The summary is returned as text. In n8n or a script the next step posts it to Slack or email; reading Sprout changes nothing in your account.

### What you get back

Example data

```
Week 12 to 18 Oct vs 5 to 11 Oct
Impressions 41,200 (+8%), engagements 2,150 (+3%)
Best posts:
- LinkedIn, product launch: 612 engagements
- Instagram reel, behind the scenes: 480
- Facebook, customer story: 351
Weakest: Instagram image, reminder post: 14 engagements
```

### Other ways to ask

- Do the same for the first of every month and cover the whole previous month.
- Report only the LinkedIn profile and list posts under 20 engagements.
- Compare this campaign's posts with the five best posts of the last quarter.

## What Sprout Social allows, and what to know first

- Sprout's Report Builder is part of Premium Analytics and also needs the Manage Custom Reports permission, so a role without it cannot build a custom report by hand either.
- Scheduled report PDFs on the Advanced or Professional plan go to up to 25 recipients at a time, weekly or monthly.
- Sprout's API caps analytics at 60 requests per minute and 250,000 per month, which makes a weekly pull for dozens of profiles slow through the API.
- Sprout's Essentials plan includes profile and post-level reporting, so the numbers exist on every plan even when the API does not.

Every tool here only reads, so it can run weekly from n8n, Make, Zapier or cron without waiting for your OK.

Sources: [Sprout Social Help: Report Builder](https://support.sproutsocial.com/hc/en-us/articles/115005750066-Report-Builder) · [Sprout Social Help: Scheduling and Sending Report PDFs](https://support.sproutsocial.com/hc/en-us/articles/115002389306-Scheduling-and-Sending-Report-PDFs) · [Sprout Social API documentation](https://api.sproutsocial.com/docs) · [Sprout Social pricing](https://sproutsocial.com/pricing/)

## Call get\_post\_performance from a script

curl

```
curl "https://cotlet.dev/api/v1/sprout-social/post-performance?profile_ids=p_li_02&profile_ids=p_ig_01&profile_ids=p_fb_03&since=2026-10-12&until=2026-10-18&limit=3" \
  -H "Authorization: Bearer $COTLET_API_KEY"
```

Example response

```
{
"posts": [
{
"post_id": "pub_3188",
"profile_id": "p_li_02",
"network": "linkedin",
"text": "Product launch: three new reports.",
"published_at": "2026-10-13T09:00:00+02:00",
"impressions": 9800,
"engagements": 612
},
{
"post_id": "pub_3190",
"profile_id": "p_ig_01",
"network": "instagram",
"text": "Behind the scenes at the studio.",
"published_at": "2026-10-15T10:00:00+02:00",
"impressions": 7100,
"engagements": 480
},
{
"post_id": "pub_3195",
"profile_id": "p_fb_03",
"network": "facebook",
"text": "How Marta cut her reporting time.",
"published_at": "2026-10-16T12:00:00+02:00",
"impressions": 5200,
"engagements": 351
}
],
"totals": {
"impressions": 22100,
"engagements": 1443
},
"next_cursor": null
}
```

MCP: add https://cotlet.dev/mcp/v1 with the same key; the call is sprout\_social\_read → get\_post\_performance. Example data.

[Schedule it in n8n, Make, Zapier or cron](https://cotlet.dev/integrations/sprout-social-api-mcp-server.md#automations)

## Sprout Social tools this automation uses

__Cotlet Sprout Social tools used to write a weekly Sprout Social performance summary__
| Tool | Parameters |
| ------------------------- | ----------------------------------------- |
| list\_profiles | network |
| get\_profile\_performance | profile\_ids, since, until |
| get\_post\_performance | profile\_ids, since, until, limit, cursor |

[All 14 Sprout Social tools with descriptions](https://cotlet.dev/integrations/sprout-social-api-mcp-server.md#tools)

## Frequently asked questions

### Is it safe to connect Sprout Social to Cotlet?

Yes. You sign in to Sprout Social yourself, in your own Cloud Browser in the EU, and we never save your password. Your agents only get Sprout Social once you enable it, every background request is listed, and the browser profile is stored encrypted with AES-256-GCM, the cipher 1Password uses for its vaults. The AI model never sees a login, posts and messages wait for your OK, and Disable for agents cuts access in one click. Independent scanners grade cotlet.dev A+ on Qualys SSL Labs, securityheaders.com and Mozilla Observatory; live results are on https://cotlet.dev/security.

## More Sprout Social automations

- [Triage Sprout Social Smart Inbox messages](https://cotlet.dev/integrations/sprout-social-api-mcp-server/triage-inbox-messages.md)
- [Schedule social posts in Sprout Social from a brief](https://cotlet.dev/integrations/sprout-social-api-mcp-server/schedule-social-posts.md)
- [Sprout Social API and MCP server: every tool](https://cotlet.dev/integrations/sprout-social-api-mcp-server.md)
- [All use cases](https://cotlet.dev/use-cases.md)

## Give your agent access to Sprout Social.

Free 7-day trial with 2,000 credits, no card needed. Cotlet is independent and not affiliated with Sprout Social.

[Sign up free](https://cotlet.dev/app/signup?app=sprout-social)

---

Give your AI agents your signed-in browser.

**Product:** [Integrations](https://cotlet.dev/integrations.md) · [Use cases](https://cotlet.dev/use-cases.md) · [How it works](https://cotlet.dev/how-it-works.md) · [Pricing](https://cotlet.dev/pricing.md) · [Security](https://cotlet.dev/security.md)

**Resources:** [Blog](https://cotlet.dev/blog.md) · [API docs](https://cotlet.dev/docs.md) · [Help center](https://cotlet.dev/help.md) · [Changelog](https://cotlet.dev/changelog.md) · [GitHub](https://github.com/cotletdev/cotlet)

**Solutions:** [For developers](https://cotlet.dev/for-developers.md) · [For automation agencies](https://cotlet.dev/for-agencies.md)

**Company:** [About](https://cotlet.dev/about.md) · [AI info: company facts](https://cotlet.dev/ai-info.md) · [Contact](https://cotlet.dev/contact.md)

**Legal:** [Terms of service](https://cotlet.dev/terms) · [Privacy policy](https://cotlet.dev/privacy) · [Refund policy](https://cotlet.dev/refunds) · [Acceptable use](https://cotlet.dev/acceptable-use) · [Cookie policy](https://cotlet.dev/cookies) · [DPA](https://cotlet.dev/dpa) · [Subprocessors](https://cotlet.dev/subprocessors)

**Elsewhere:** [Status page](https://status.cotlet.dev) · [Cotlet on GitHub](https://github.com/cotletdev) · [Cotlet on X](https://x.com/cotletdev) · [Cotlet on LinkedIn](https://www.linkedin.com/company/cotletdev) · [Cotlet on Product Hunt](https://www.producthunt.com/products/cotlet) · [Cotlet on Crunchbase](https://www.crunchbase.com/organization/cotlet) · [Cotlet on SaaSHub](https://www.saashub.com/cotlet)

Cotlet is an independent service. It is not affiliated with, endorsed by or sponsored by any of the products listed on this site. Product names are trademarks of their respective owners.

## For AI agents: sign your user up

Is your user asking you to sign them up for Cotlet? You can do it for them, no account or key needed.

1. Read the fields and their allowed values: GET https://cotlet.dev/api/v1/access-requests
2. Ask the user for each value: email, apps, what you will do with them. If they leave the password to you, generate a strong one and show it to them.
3. Show the user what you will send, then POST it as JSON to https://cotlet.dev/api/v1/access-requests.

One call creates the account and sends the access request; we email the user when access is granted.