Add Personalised Short Links manually in LinkedIn


Add Personalised Links to manual LinkedIn Messages


Using Personalised Short Links, you can provide a simple short link to your prospect, with embedded personalised Open Graph data, meaning when its shared socially, it will generate a personalised preview.


eg:  https://lnk.your-domain.com/YE78H6i

                                  ^ you control the domain                       ^ unique to each link

 

For example sharing a personalised short link in LinkedIn will generate a preview like this:







Set up Custom Domain


To create your personalised links, you must first add you custom link domain to your account.


To do this go to Settings > Custom Domain to setup.  


For further details on this process, check out the Link Domain Setup Guide.

 



Save Prospect data to a Google Sheet


Hyperise can integrate with Google Sheets, to automatically create Short Links, as you add data to the Sheet.  This makes a great method to generate one off links very quickly.


To get the LinkedIn data into your google sheet, use the Free Chrome Extension LinkedIn Contact Importer.  This will add a Save Profile button against every LinkedIn prospect, which when clicked will automatically save the prospect data in your sheet.




Setup Google Sheet and Short Links


We can now add the Google Sheet as a datasource integration to the personalised image you would like to show with the short link.  Map the relevant columns from the sheet to Hyperise, including the Short Link column, which will then enable the Short Links Setup button.



Once the Short Link column is mapped, you can then define the short link settings.




Once added, click Save to finish the Google Sheet mapping and Short Links settings, now also Save the image.


This will now automatically populate your google's existing rows with short links.



Final Step to Automate new Data to the Sheet

The final step is to setup the process to automatically add new short links, as your add to the sheet from LinkedIn.


The example sheet linked below has already been setup with all the required columns and update procedure, so just grab a copy of the sheet below:


https://docs.google.com/spreadsheets/d/1r1clzhWnUiTT6UJBOQ3FH9WHE7TRJZhE9Oj4nnukMRc/copy


Now in your copy of the Sheet, add you Data Source Hash:


The Data Source Hash is available in the Google Sheet integration settings screen:



Add this to your copy of the example Sheet:



This will now setup your Sheet, so it will all work automatically, just like magic, one click of a button in LinkedIn and data will appear in your sheet and short link ready to copy and paste direct into your LinkedIn Messages.


LinkedIn will then do the rest of the work, and dynamically show your personalised image and description in your message.  The image and link will be clickable, and of course will take the prospect to the destination URL you've defined in the Short Links setup.


If this page has been personalised with Hyperise, then the prospect will see the personalisation when they land on the destination page.



IF YOU WANT TO USE YOUR OWN SHEET, RATHER THAN THE EXAMPLE ABOVE, YOU WILL NEED TO ADD THE WEBHOOK FUNCTION TO YOUR SHEET, BELOW ARE THE INSTRUCTIONS, ONLY IF YOU DIDNT USE THE EXAMPLE ABOVE.


Add webhook to Sheet with Script Editor


Now that you have a Hyperise Image connected to your Sheet and new lookup key defined, you can now add the webhook to the sheet.


WARNING: this isn't beginner level stuff 😉 


Open up the script editor from Tools -> Script Editor



Once the Script Editor has loaded paste the following code into the main editor.


function HR_KEY_CHANGED(row, dataSourceHash) {
 var options = {
   'method' : 'post',
   'payload': {data_source_hash: dataSourceHash}
 };
 
 UrlFetchApp.fetch('https://app.hyperise.io/api/v1/regular/data-sources/google-sheet-updated', options);
 return "UpdatedAt: "+ currentTime()
}


function currentTime() {
 var d = new Date();
 var currentTime = d.toLocaleTimeString()
 return currentTime;
}




Once you've added the code you can save the script.





Add Custom Function to the Sheet


Now that we've created the webhook function, we need to add the custom function to the sheet.


=HR_KEY_CHANGED(B:B; "Data-Source-Hash" )


The function example above has two parameters, the first B:B is the column being used as the lookup key and the second Data-Source-Hash is the value copied from step one.


Add this function to your Sheet, where it's out the way, this could even be on another tab, but be sure to reference the tab name, if having on different tabs.


The Data Source Hash is available in the Google Sheet integration settings screen:




Once the custom function has been added, you will notice that each time you update your lookup key column, the functions last change timestamp will update.  This also triggers the webhook, enabling Hyperise to reindex the lookup column ready for use.



Thats it you're done, each time you update the Sheet, the webhook will be called and Hyperise will reindex your lookup key, ready for your images to call.