How to Integrate Lovable with LinkedIn Ads

Navigate to developer.linkedin.com and sign in with your LinkedIn account. Click 'Create app'. Fill in the app name, your company's LinkedIn page (required for business applications), and app logo. After creating the app, go to the Products tab and click 'Request Access' next to 'Marketing Developer Platform'. LinkedIn's Marketing Developer Platform includes Campaign Manager, Reporting, Lead Gen Forms, and other marketing-specific products. LinkedIn reviews Marketing Developer Platform requests — this can take 2-7 business days. You will receive a notification when your application is approved. Until then, your application can use the API in a limited capacity but will receive permission errors on most Marketing API endpoints. Once approved, go to the Auth tab in your LinkedIn developer application. Note the Client ID and Client Secret. You will also need to configure the OAuth 2.0 redirect URLs — add your deployed Lovable app URL plus a callback path, such as https://your-app.lovable.app/auth/linkedin/callback. To generate an access token with the required r_ads and r_ads_reporting scopes, you use the OAuth2 authorization code flow. Go to the OAuth 2.0 tools section in the LinkedIn developer portal and use the token generator to create an access token for your LinkedIn account that includes the required scopes. This generates a token valid for 60 days. For production, you need to implement token refresh — LinkedIn provides refresh tokens that are valid for 365 days.

Open your Lovable project, click the '+' icon next to the Preview label, and navigate to the Secrets tab. Add the following secrets: - Name: LINKEDIN_ADS_ACCESS_TOKEN — Value: your 60-day access token - Name: LINKEDIN_ADS_REFRESH_TOKEN — Value: your 365-day refresh token - Name: LINKEDIN_ADS_CLIENT_ID — Value: your LinkedIn application Client ID - Name: LINKEDIN_ADS_CLIENT_SECRET — Value: your LinkedIn application Client Secret - Name: LINKEDIN_ADS_ACCOUNT_ID — Value: your LinkedIn ad account ID (the numeric ID from Campaign Manager's URL) The access token authorizes all advertising data retrieval and lead gen form access. The refresh token allows your Edge Function to automatically obtain a new access token when the current one expires, without user intervention. Your LinkedIn ad account ID is the numeric identifier in LinkedIn Campaign Manager's URL. When viewing your campaigns, the URL contains act=urn:li:sponsoredAccount:XXXXXXX — the number at the end is your account ID. Store it without the urn:li:sponsoredAccount: prefix — just the numeric portion. LinkedIn advertising credentials have access to billing data and lead contact information. Apply the same security discipline as for payment processor credentials: always use Cloud → Secrets, never paste in chat.

Create a Supabase Edge Function that proxies LinkedIn Marketing API calls. LinkedIn's Marketing API base URL is https://api.linkedin.com/v2/ for newer endpoints or https://api.linkedin.com/rest/ for the REST API. The function includes automatic token refresh logic — before making each API call, it checks if the access token has expired (by attempting the call and catching 401s) and refreshes it using the stored refresh token. The function handles four core actions: campaigns (list campaigns for the ad account), analytics (fetch performance metrics for campaigns, ad groups, or creatives), lead_forms (list lead gen forms and their submissions), and update_campaign (change campaign status or budget). LinkedIn's API uses the X-Restli-Protocol-Version: 2.0.0 header — include this on all requests. LinkedIn also encodes some resource identifiers as URNs (like urn:li:sponsoredCampaign:123456) — the Edge Function handles converting between numeric IDs and URN formats.

1// supabase/functions/linkedin-ads/index.ts
2const LINKEDIN_API = 'https://api.linkedin.com';
3const TOKEN_URL = 'https://www.linkedin.com/oauth/v2/accessToken';
4
5async function refreshAccessToken(): Promise<string> {
6  const response = await fetch(TOKEN_URL, {
7    method: 'POST',
8    headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
9    body: new URLSearchParams({
10      grant_type: 'refresh_token',
11      refresh_token: Deno.env.get('LINKEDIN_ADS_REFRESH_TOKEN')!,
12      client_id: Deno.env.get('LINKEDIN_ADS_CLIENT_ID')!,
13      client_secret: Deno.env.get('LINKEDIN_ADS_CLIENT_SECRET')!,
14    }),
15  });
16  const data = await response.json();
17  if (!data.access_token) throw new Error('Token refresh failed');
18  return data.access_token;
19}
20
21async function callLinkedIn(url: string, options: RequestInit, retried = false): Promise<Response> {
22  const token = Deno.env.get('LINKEDIN_ADS_ACCESS_TOKEN');
23  const response = await fetch(url, {
24    ...options,
25    headers: {
26      ...options.headers as Record<string, string>,
27      'Authorization': `Bearer ${token}`,
28      'X-Restli-Protocol-Version': '2.0.0',
29    },
30  });
31  if (response.status === 401 && !retried) {
32    await refreshAccessToken(); // In production: update the secret
33    return callLinkedIn(url, options, true);
34  }
35  return response;
36}
37
38Deno.serve(async (req) => {
39  if (req.method === 'OPTIONS') {
40    return new Response(null, {
41      headers: {
42        'Access-Control-Allow-Origin': '*',
43        'Access-Control-Allow-Methods': 'POST, OPTIONS',
44        'Access-Control-Allow-Headers': 'Content-Type, Authorization',
45      },
46    });
47  }
48
49  const { action, params } = await req.json();
50  const accountId = Deno.env.get('LINKEDIN_ADS_ACCOUNT_ID');
51  const accountUrn = `urn:li:sponsoredAccount:${accountId}`;
52
53  let url: string;
54  let fetchOptions: RequestInit = { method: 'GET', headers: {} };
55
56  if (action === 'campaigns') {
57    url = `${LINKEDIN_API}/rest/adCampaigns?q=search&search.account.values[0]=${encodeURIComponent(accountUrn)}&count=100`;
58  } else if (action === 'analytics') {
59    url = `${LINKEDIN_API}/rest/adAnalytics?q=analytics&pivot=${params.pivot || 'CAMPAIGN'}&dateRange.start.day=${params.start_day}&dateRange.start.month=${params.start_month}&dateRange.start.year=${params.start_year}&dateRange.end.day=${params.end_day}&dateRange.end.month=${params.end_month}&dateRange.end.year=${params.end_year}&accounts[0]=${encodeURIComponent(accountUrn)}&fields=impressions,clicks,costInLocalCurrency,totalEngagements,leadGenerationMailContactInfoShares`;
60  } else if (action === 'lead_forms') {
61    url = `${LINKEDIN_API}/rest/leadGenForms?q=owner&owner=${encodeURIComponent(accountUrn)}`;
62  } else {
63    return new Response(JSON.stringify({ error: 'Invalid action' }), { status: 400, headers: { 'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*' } });
64  }
65
66  const response = await callLinkedIn(url, fetchOptions);
67  const data = await response.json();
68
69  return new Response(JSON.stringify(data), {
70    status: response.ok ? 200 : response.status,
71    headers: { 'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*' },
72  });
73});

With the Edge Function in place, use Lovable's chat to build the campaign analytics and lead generation dashboard. LinkedIn's advertising data is particularly valuable for B2B teams because of the available demographic breakdown — you can see impressions and clicks by job title, seniority, company, and industry. For the campaign dashboard, show the standard performance metrics (impressions, clicks, CTR, spend, leads, CPL) with a date range picker. LinkedIn's analytics endpoint supports pivoting by CAMPAIGN, CREATIVE, CONVERSION, MEMBER_COMPANY, MEMBER_JOB_TITLE, and MEMBER_SENIORITY — use the member-level pivots to power the ABM account engagement view. For the lead gen form integration, fetch lead form responses and display them in a table with the lead's first name, last name, email, company, and job title. Add a button to export leads as CSV or sync them to a Supabase table that feeds your CRM workflow. LinkedIn's API returns cost in local currency as costInLocalCurrency (a decimal). Divide by 100 if your account uses cents, or display it directly if it is already in dollar/euro units — LinkedIn's currency handling varies by account region. For enterprise-scale B2B dashboards with Salesforce CRM sync, Marketo lead routing, and multi-account agency reporting, RapidDev's team can help design the full data pipeline.