How to Integrate Sprout Social with V0

1// app/api/sprout/overview/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const SPROUT_API_BASE = 'https://api.sproutsocial.com/v1';
5
6async function sproutPost(path: string, body: unknown): Promise<Response> {
7  const token = process.env.SPROUT_ACCESS_TOKEN;
8  const customerId = process.env.SPROUT_CUSTOMER_ID;
9
10  if (!token || !customerId) {
11    throw new Error('Sprout Social credentials not configured');
12  }
13
14  return fetch(`${SPROUT_API_BASE}/${customerId}${path}`, {
15    method: 'POST',
16    headers: {
17      Authorization: `Bearer ${token}`,
18      'Content-Type': 'application/json',
19    },
20    body: JSON.stringify(body),
21    cache: 'no-store',
22  });
23}
24
25export async function GET(request: NextRequest) {
26  const { searchParams } = new URL(request.url);
27  const days = parseInt(searchParams.get('days') || '30');
28
29  const endDate = Math.floor(Date.now() / 1000);
30  const startDate = endDate - days * 24 * 60 * 60;
31
32  try {
33    const analyticsRes = await sproutPost('/analytics/profiles', {
34      start_time: startDate,
35      end_time: endDate,
36      metrics: [
37        'impressions',
38        'engagements',
39        'engagement_rate_by_impressions_percent',
40        'followers_gained',
41        'link_clicks',
42      ],
43    });
44
45    if (!analyticsRes.ok) {
46      const error = await analyticsRes.text();
47      console.error('Sprout analytics error:', analyticsRes.status, error);
48      return NextResponse.json(
49        { error: `Sprout Social API error: ${analyticsRes.status}` },
50        { status: analyticsRes.status }
51      );
52    }
53
54    const data = await analyticsRes.json();
55    const items = data.data?.items || [];
56
57    // Aggregate metrics across all profiles
58    const totals = items.reduce(
59      (acc: Record<string, number>, item: Record<string, unknown>) => {
60        const metrics = item.metrics as Record<string, number[]>;
61        acc.impressions += metrics.impressions?.[0] || 0;
62        acc.engagements += metrics.engagements?.[0] || 0;
63        acc.followersGained += metrics.followers_gained?.[0] || 0;
64        acc.linkClicks += metrics.link_clicks?.[0] || 0;
65        return acc;
66      },
67      { impressions: 0, engagements: 0, followersGained: 0, linkClicks: 0 }
68    );
69
70    const engagementRate =
71      totals.impressions > 0
72        ? ((totals.engagements / totals.impressions) * 100).toFixed(2)
73        : '0.00';
74
75    // Build per-profile breakdown
76    const profiles = items.map((item: Record<string, unknown>) => {
77      const metrics = item.metrics as Record<string, number[]>;
78      return {
79        profileId: item.dimensions,
80        impressions: metrics.impressions?.[0] || 0,
81        engagements: metrics.engagements?.[0] || 0,
82        followersGained: metrics.followers_gained?.[0] || 0,
83      };
84    });
85
86    return NextResponse.json({
87      dateRange: { days, startDate, endDate },
88      totals: { ...totals, engagementRate },
89      profiles,
90    });
91  } catch (error) {
92    console.error('Sprout overview error:', error);
93    return NextResponse.json(
94      { error: 'Failed to fetch Sprout Social data' },
95      { status: 500 }
96    );
97  }
98}

1// app/api/sprout/posts/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const SPROUT_API_BASE = 'https://api.sproutsocial.com/v1';
5
6export async function GET(request: NextRequest) {
7  const token = process.env.SPROUT_ACCESS_TOKEN;
8  const customerId = process.env.SPROUT_CUSTOMER_ID;
9
10  if (!token || !customerId) {
11    return NextResponse.json({ error: 'Sprout Social not configured' }, { status: 500 });
12  }
13
14  const { searchParams } = new URL(request.url);
15  const days = parseInt(searchParams.get('days') || '30');
16  const limit = Math.min(parseInt(searchParams.get('limit') || '20'), 50);
17
18  const endDate = Math.floor(Date.now() / 1000);
19  const startDate = endDate - days * 24 * 60 * 60;
20
21  try {
22    const response = await fetch(
23      `${SPROUT_API_BASE}/${customerId}/analytics/posts`,
24      {
25        method: 'POST',
26        headers: {
27          Authorization: `Bearer ${token}`,
28          'Content-Type': 'application/json',
29        },
30        body: JSON.stringify({
31          start_time: startDate,
32          end_time: endDate,
33          limit,
34          order_by: 'engagements',
35          order: 'desc',
36          metrics: ['impressions', 'engagements', 'link_clicks'],
37        }),
38        cache: 'no-store',
39      }
40    );
41
42    if (!response.ok) {
43      return NextResponse.json(
44        { error: `Sprout API error: ${response.status}` },
45        { status: response.status }
46      );
47    }
48
49    const data = await response.json();
50    const posts = (data.data?.items || []).map((item: Record<string, unknown>) => {
51      const metrics = item.metrics as Record<string, number[]>;
52      const impressions = metrics.impressions?.[0] || 0;
53      const engagements = metrics.engagements?.[0] || 0;
54
55      return {
56        id: item.post_id,
57        network: item.network_type,
58        text: (item.text as string)?.substring(0, 150) || '',
59        publishedAt: item.sent_time,
60        permalink: item.permalink,
61        impressions,
62        engagements,
63        linkClicks: metrics.link_clicks?.[0] || 0,
64        engagementRate:
65          impressions > 0 ? ((engagements / impressions) * 100).toFixed(2) : '0.00',
66      };
67    });
68
69    return NextResponse.json({ posts, total: data.data?.total_count || posts.length });
70  } catch (error) {
71    console.error('Sprout posts error:', error);
72    return NextResponse.json({ error: 'Failed to fetch posts' }, { status: 500 });
73  }
74}