With Sheetgo, you can connect LinkedIn’s API to Google Sheets and automatically retrieve professional data such as Company Page analytics, Posts performance metrics, Follower statistics, and Ad campaign insights. This allows marketing and growth teams to centralize LinkedIn data into structured spreadsheets for reporting, KPI tracking, engagement analysis, and performance dashboards. Instead of manually exporting reports from LinkedIn Campaign Manager or Company Pages, Sheetgo automates data retrieval using secure OAuth authentication and scheduled updates, ensuring your LinkedIn data remains current inside Google Sheets.
Prerequisites
- A LinkedIn Developer account
- LinkedIn Developer Portal: https://www.linkedin.com/developers/
- LinkedIn Marketing Developer Platform documentation: https://learn.microsoft.com/en-us/linkedin/marketing/
- LinkedIn OAuth 2.0 documentation: https://learn.microsoft.com/en-us/linkedin/shared/authentication/authorization-code-flow
- A registered LinkedIn App with Client ID and Client Secret
- Required API permissions (e.g., r_organization_social, r_ads, rw_organization_admin depending on your use case)
- Your LinkedIn Organization ID (for company data endpoints)
- A Sheetgo account using the same email associated with your LinkedIn app
Step 1: Identify the Required API Endpoint
LinkedIn provides multiple APIs depending on whether you want to retrieve organic page data or advertising analytics. Review the LinkedIn Marketing API documentation linked in the Prerequisites to determine the correct endpoint for your reporting needs. All LinkedIn Marketing API requests are made to this base URL: https://api.linkedin.com/v2/. For example, to retrieve LinkedIn Organization Posts, you may use https://api.linkedin.com/v2/ugcPosts?q=authors&authors=List(urn:li:organization:ORGANIZATION_ID). If retrieving Ad Campaign data, you may use endpoints under the adAnalytics or adCampaigns resources as described in the documentation linked in the Prerequisites. Identify the endpoint that matches your data requirements before proceeding.
Step 2: Generate API Credentials
LinkedIn uses OAuth 2.0 for authentication. First, log in to the LinkedIn Developer Portal using the link in the Prerequisites. Create a new app and configure the required products such as Marketing Developer Platform. Once created, LinkedIn will generate a Client ID and Client Secret. Next, configure OAuth settings inside your LinkedIn app and define an authorized redirect URL. Follow the Authorization Code Flow documentation linked in the Prerequisites to generate an Authorization Code. Exchange this authorization code for an Access Token and Refresh Token using LinkedIn’s token endpoint. LinkedIn access tokens expire after a defined period, so you must store the Refresh Token to maintain automated access. You will use the Access Token, Client ID, Client Secret, and Refresh Token inside Sheetgo to enable automatic token renewal.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Log in to Sheetgo and create a new workflow. Select HTTP Request as your source. In the Request URL field, enter your selected LinkedIn endpoint, for example: https://api.linkedin.com/v2/ugcPosts?q=authors&authors=List(urn:li:organization:123456789). Then open the Headers section and insert the following JSON configuration:
{
"Authorization": "Bearer YOUR_ACCESS_TOKEN",
"Content-Type": "application/json",
"@auth": {
"auth_method": "oauth2",
"auth_type": "Bearer",
"refresh_url": "https://www.linkedin.com/oauth/v2/accessToken",
"refresh_params": {
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET",
"refresh_token": "YOUR_REFRESH_TOKEN",
"grant_type": "refresh_token"
}
},
"@pagination": {
"type": "cursor",
"cursor_param": "start",
"next_cursor_key": "paging.links"
}
}Replace all placeholder values with your real LinkedIn credentials. LinkedIn commonly uses cursor-based pagination through the start parameter and paging metadata returned in the response. Sheetgo will continue fetching records until no additional pages are available. If the API response nests records inside an elements object, you may define a data root using the @flags parameter with data_root set to elements.
Step 5: Choose the Destination Spreadsheet
After configuring the request, click Next in Sheetgo. Choose Google Sheets as your destination. You may either select an existing spreadsheet or create a new one. Sheetgo will automatically convert the LinkedIn JSON response into structured spreadsheet columns. If necessary, you can add a Filter by Condition processor before the destination step to refine your data set. Confirm the spreadsheet tab where the LinkedIn data will be stored.
Step 6: Execute the Sheetgo Connection
Click Finish and Save to activate the workflow. Run the connection to test the integration. Sheetgo will fetch data from LinkedIn and populate your Google Sheet. To keep LinkedIn analytics updated automatically, configure scheduled refreshes in the workflow settings. Since OAuth refresh tokens are configured inside the header JSON, Sheetgo will automatically request new access tokens when needed. This ensures your LinkedIn data remains continuously synced with Google Sheets.