Send followers demographic data to a Google Sheets spreadsheet

Tags: "linkedin #googlesheets #gsheet #data #naas_drivers #demographics #content #snippet
Author: Asif Syed
Last update: 2023-05-29 (Created: 2022-07-11)
Description: This notebook allows users to easily export demographic data about their LinkedIn followers to a Google Sheets spreadsheet.
Disclaimer: This code is in no way affiliated with, authorized, maintained, sponsored or endorsed by Linkedin or any of its affiliates or subsidiaries. It uses an independent and unofficial API. Use at your own risk.
This project violates Linkedin's User Agreement Section 8.2, and because of this, Linkedin may (and will) temporarily or permanently ban your account. We are not responsible for your account being banned.


Import library

from naas_drivers import gsheet
from naas_drivers import linkedin
import pandas as pd
import numpy as np
import naas

Setup LinkedIn

# LinkedIn cookies
LI_AT = (
naas.secret.get("LI_AT") or "ENTER_YOUR_COOKIE_HERE"
) # EXAMPLE : "AQFAzQN_PLPR4wAAAXc-FCKmgiMit5FLdY1af3-2"
) # EXAMPLE : "ajax:8379907400220387585"

Setup Google Sheets

Share your spreadsheet with 🔗 [email protected]


Connect to LinkedIn

linkedin.connect(LI_AT, JSESSIONID)

Connect to gsheet


Get the profiles of last 'n' followers (n is the value assigned to limit parameter below)

The 'start' parameter below specifies the number of initial rows to be skipped.
These initial rows refer to the most recent profiles, hence it is by default maintained as 0, but it could be customized as per the need.
df =, limit=1)
profiles = df["PROFILE_URL"]

Get Industry name and country details for each profile

df_identity = pd.DataFrame()
df1 = pd.DataFrame()
for counter, profile in enumerate(profiles):
df1 = linkedin.profile.get_identity(profile_url=profile).loc[
df_identity = df_identity.append(df1)

Get work experience details for each profile

df_resume = pd.DataFrame()
df1 = pd.DataFrame()
for counter, profile in enumerate(profiles):
df1 = linkedin.profile.get_resume(profile_url=profile)
df_resume = df_resume.append(df1)
df_resume = df_resume[df_resume["CATEGORY"] == "Experience"].loc[

Merge two data frames.

df_final = pd.merge(df_identity, df_resume, how="inner", on="PROFILE_ID")


Send the data

gsheet.send(sheet_name=SHEET_NAME, data=df_final)