Comment on page
Send comments from post to gsheet
Tags: #linkedin #post #comments #gsheet #naas_drivers #content #snippet #googlesheets
Last update: 2023-05-29 (Created: 2022-03-17)
Description: This notebook allows users to automatically send comments from a LinkedIn post to a Google Sheet.
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.
from naas_drivers import linkedin, gsheet
import random
import time
import pandas as pd
from datetime import datetime
# Lindekin cookies
LI_AT = "AQEDARCNSioDe6wmAAABfqF-HR4AAAF-xYqhHlYAtSu7EZZEpFer0UZF-GLuz2DNSz4asOOyCRxPGFjenv37irMObYYgxxxxxxx"
JSESSIONID = "ajax:12XXXXXXXXXXXXXXXXX"
# Post url
POST_URL = "POST_URL"
👉 Get your spreadsheet id => it is located in your gsheet url after "https://docs.google.com/spreadsheets/d/" and before "/edit"
👉 Share your gsheet with our service account to connect : [email protected]
👉 Create your sheet before sending data into it
# Spreadsheet id
SPREADSHEET_ID = "SPREADSHEET_ID"
# Sheet names
SHEET_POST_COMMENTS = "POST_COMMENTS"
SHEET_MY_NETWORK = "MY_NETWORK"
SHEET_NOT_MY_NETWORK = "NOT_MY_NETWORK"
DATETIME_FORMAT = "%Y-%m-%d %H:%M:%S"
df_posts = linkedin.connect(LI_AT, JSESSIONID).post.get_comments(POST_URL)
df_posts["DATE_EXTRACT"] = datetime.now().strftime(DATETIME_FORMAT)
df_network = pd.DataFrame()
for _, row in df_posts.iterrows():
profile_id = row.PROFILE_ID
# Get network information to know distance between you and people who likes the post
tmp_network = linkedin.connect(LI_AT, JSESSIONID).profile.get_network(profile_id)
# Concat dataframe
df_network = pd.concat([df_network, tmp_network], axis=0)
# Time sleep in made to mimic human behavior, here it is randomly done between 2 and 5 seconds
time.sleep(random.randint(2, 5))
df_network.head(5)
df_all = pd.merge(df_posts, df_network, on=["PROFILE_URN", "PROFILE_ID"], how="left")
df_all = df_all.sort_values(by=["FOLLOWERS_COUNT"], ascending=False)
df_all = df_all[df_all["DISTANCE"] != "SELF"].reset_index(drop=True)
df_all.head(5)
# My network
my_network = df_all[df_all["DISTANCE"] == "DISTANCE_1"].reset_index(drop=True)
my_network["DATE_EXTRACT"] = datetime.now().strftime(DATETIME_FORMAT)
my_network.head(5)
# Not in my network
not_my_network = df_all[df_all["DISTANCE"] != "DISTANCE_1"].reset_index(drop=True)
not_my_network["DATE_EXTRACT"] = datetime.now().strftime(DATETIME_FORMAT)
not_my_network.head(5)
gsheet.connect(SPREADSHEET_ID).send(
df_posts, sheet_name=SHEET_POST_COMMENTS, append=False
)
gsheet.connect(SPREADSHEET_ID).send(
my_network, sheet_name=SHEET_MY_NETWORK, append=False
)
gsheet.connect(SPREADSHEET_ID).send(
not_my_network, sheet_name=SHEET_NOT_MY_NETWORK, append=False
)
Last modified 3mo ago