Update linkedinbio from google

​​
​

Template request | Bug report​
Tags: #hubspot #crm #sales #contact #naas_drivers #googlesearch #scheduler #naas #automation
Author: Florent Ravenel​
Description: This notebook update HubSpot linkedin URL based on Google Search with firstname and lastname.
Input
Import libraries
from naas_drivers import hubspot
import naas
import pandas as pd
from googlesearch import search
import time
import re
Setup HubSpot
👉 Starting November 30, 2022, HubSpot API keys no longer enable access to HubSpot APIs, so in Naas version 2.8.3 and above, you need create a private app and use the access token.
# Enter Your Access Token
HS_ACCESS_TOKEN = naas.secret.get("HS_ACCESS_TOKEN") or "YOUR_HS_ACCESS_TOKEN"
Setup Naas
naas.scheduler.add(cron="0 8 * * *")
​
# -> Uncomment the line below (by removing the hashtag) and execute this cell to remove your scheduler
# naas.scheduler.delete()
Model
Get all contacts in Hubspot
properties_list = [
    "hs_object_id",
    "firstname",
    "lastname",
    "linkedinbio",
]
hubspot_contacts = hubspot.connect(HS_ACCESS_TOKEN).contacts.get_all(properties_list)
hubspot_contacts
Filter to get linkedinbio "Not Defined" and "firstname" and "lastname" defined
df_to_update = hubspot_contacts.copy()
​
# Cleaning
df_to_update = df_to_update.fillna("Not Defined")
​
# Filter on "Not defined"
df_to_update = df_to_update[(df_to_update.firstname != "Not Defined") & 
                            (df_to_update.lastname != "Not Defined") &
                            (df_to_update.linkedinbio == "Not Defined")].reset_index(drop=True)
​
df_to_update
Search bio in Google with firstname and lastname
def get_bio(firstname, lastname):
    # Init linkedinbio
    linkedinbio = None
    
    # Create query
    query = f"{firstname}+{lastname}+Linkedin"
    print("Google query: ", query)
    
    # Search in Google
    for i in search(query, tld="com", num=10, stop=10, pause=2):
        pattern = "https:\/\/.+.linkedin.com\/in\/.([^?])+"
        result = re.search(pattern, i)
​
        # Return value if result is not None
        if result != None:
            linkedinbio = result.group(0).replace(" ", "")
            return linkedinbio
        else:
            time.sleep(2)
    return linkedinbio
for _, row in df_to_update.iterrows():
    firstname = row.firstname
    lastname = row.lastname
    
    # Get linkedinbio
    linkedinbio = get_bio(firstname, lastname)
    df_to_update.loc[_, "linkedinbio"] = linkedinbio
    
df_to_update
Output
Update linkedinbio in Hubspot
for _, row in df_to_update.iterrows():
    # Init data
    data = {}
    
    # Get data
    hs_object_id = row.hs_object_id
    linkedinbio = row.linkedinbio
​
    # Update LK Bio
    if linkedinbio != None:
        data = {"properties": {"linkedinbio": linkedinbio}}
    hubspot.connect(HS_ACCESS_TOKEN).contacts.patch(hs_object_id, data)
Get notes from contact
Send closed deals weekly
Last modified 7d ago