How to Integrate Replit with Hootsuite

1// Node.js — install required packages
2// Run in Replit Shell:
3// npm install express axios dotenv
4
5// Verify packages
6const deps = ['express', 'axios'];
7for (const dep of deps) {
8  try {
9    require.resolve(dep);
10    console.log(`OK: ${dep} available`);
11  } catch {
12    console.error(`MISSING: ${dep} — run npm install ${dep}`);
13  }
14}

1# Python — Hootsuite OAuth 2.0 flow (oauth.py)
2from flask import Flask, request, redirect
3import requests
4import os
5import json
6
7app = Flask(__name__)
8
9CLIENT_ID = os.environ['HOOTSUITE_CLIENT_ID']
10CLIENT_SECRET = os.environ['HOOTSUITE_CLIENT_SECRET']
11REDIRECT_URI = os.environ.get('REPLIT_URL', 'http://localhost:3000') + '/oauth/callback'
12SCOPES = 'offline post read_messages analytics'
13
14@app.route('/oauth/start')
15def oauth_start():
16    auth_url = (
17        f'https://platform.hootsuite.com/oauth2/auth'
18        f'?response_type=code&client_id={CLIENT_ID}'
19        f'&redirect_uri={REDIRECT_URI}&scope={SCOPES}'
20    )
21    return redirect(auth_url)
22
23@app.route('/oauth/callback')
24def oauth_callback():
25    code = request.args.get('code')
26    resp = requests.post(
27        'https://platform.hootsuite.com/oauth2/token',
28        data={
29            'grant_type': 'authorization_code',
30            'code': code,
31            'redirect_uri': REDIRECT_URI,
32            'client_id': CLIENT_ID,
33            'client_secret': CLIENT_SECRET
34        }
35    )
36    tokens = resp.json()
37    # Copy these values to Replit Secrets
38    print(f"ACCESS TOKEN: {tokens.get('access_token')}")
39    print(f"REFRESH TOKEN: {tokens.get('refresh_token')}")
40    return f"Tokens obtained. Copy to Replit Secrets. Access token expires in {tokens.get('expires_in')} seconds."
41
42if __name__ == '__main__':
43    app.run(host='0.0.0.0', port=3000)

1// Node.js — fetch profiles and schedule a post (scheduler.js)
2const axios = require('axios');
3
4const BASE_URL = 'https://platform.hootsuite.com/v1';
5const ACCESS_TOKEN = process.env.HOOTSUITE_ACCESS_TOKEN;
6
7const api = axios.create({
8  baseURL: BASE_URL,
9  headers: { Authorization: `Bearer ${ACCESS_TOKEN}` }
10});
11
12async function getSocialProfiles() {
13  const res = await api.get('/socialProfiles');
14  return res.data.data;
15}
16
17async function schedulePost(profileIds, text, scheduledTime) {
18  const payload = {
19    text,
20    socialProfileIds: profileIds,
21    scheduledSendTime: scheduledTime  // ISO 8601 UTC string
22  };
23  const res = await api.post('/messages', payload);
24  return res.data.data;
25}
26
27(async () => {
28  const profiles = await getSocialProfiles();
29  console.log('Connected profiles:');
30  profiles.forEach(p => console.log(`  ${p.type}: ${p.socialNetworkUsername} (ID: ${p.id})`));
31
32  // Schedule a post 1 hour from now
33  const in1Hour = new Date(Date.now() + 3600000).toISOString();
34  const profileIds = profiles.slice(0, 1).map(p => p.id);  // First profile only
35  const msg = await schedulePost(profileIds, 'Hello from Replit! #automation', in1Hour);
36  console.log('Scheduled message ID:', msg.id);
37})();

1# Python — fetch post analytics (analytics.py)
2import requests
3import os
4from datetime import datetime, timedelta
5
6ACCESS_TOKEN = os.environ['HOOTSUITE_ACCESS_TOKEN']
7BASE_URL = 'https://platform.hootsuite.com/v1'
8
9headers = {'Authorization': f'Bearer {ACCESS_TOKEN}', 'Content-Type': 'application/json'}
10
11def get_post_analytics(profile_id, start_date, end_date):
12    """
13    Fetch analytics for a social profile over a date range.
14    Dates should be ISO 8601 strings like '2026-03-01T00:00:00Z'
15    """
16    payload = {
17        'socialProfileIds': [profile_id],
18        'startDate': start_date,
19        'endDate': end_date,
20        'metrics': ['IMPRESSIONS', 'ENGAGEMENTS', 'CLICKS'],
21        'granularity': 'TOTAL'
22    }
23    response = requests.post(
24        f'{BASE_URL}/analytics/posts',
25        json=payload,
26        headers=headers
27    )
28    if response.status_code == 200:
29        return response.json().get('data', [])
30    else:
31        print(f'Analytics error {response.status_code}: {response.text}')
32        return []
33
34# Fetch last 7 days analytics (exclude last 2 days for data completeness)
35end = datetime.utcnow() - timedelta(days=2)
36start = end - timedelta(days=7)
37profile_id = os.environ.get('HOOTSUITE_PROFILE_ID', '')
38if profile_id:
39    results = get_post_analytics(profile_id, start.isoformat() + 'Z', end.isoformat() + 'Z')
40    for item in results:
41        print(item)