Save a ton of time by uploading a contact list using SilverPop API and SFTP

SilverPop APIUploading a contact list to Engage can be time consuming using their web interface.  Even when I focus on the task, it takes from 7-10 minutes.

SilverPop API

Most don’t know that SilverPop API is a decent API webservice.  Tie it in with a SFTP (secure file transfer) and suddenly your uploading lists in about 5 seconds!

While the video is a couple of minutes long, the actual work involved is only a few seconds. After uploading the list, the script launches a separate checker to see when the data job completes and then writes my confirmation email for me.

Uploading a contact list ot Engage via an API call

 

Screen Clipping w/built in email attachment, IMUGR upload, & saving

screen clippingI use this AutoHotKey screen clipping script at least a dozen times a day. I think most people SHOULD be using it that often but don’t realize how useful it can be.

The below video walks through a some examples of how I use it.  Trust me, after you start using it for a few days, you’ll wonder how you managed to get by all these years without having it!

screen clipping & built-in options

My version allows you to:

  1. have multiple clips on the main window
  2. automatically write a pretty email customized to the time/date and attach a .png file (easy to tweak to whatever format you want)
  3. upload to  IMUGUR
  4. save locally and paste path to file wherever needed (I use this for Facebook very frequently)
  5. save locally with a time-stamp

Here is the video demonstrating it’s usage

Screen clipping and various uses

and here is the AutoHotkey code (Be sure you create and swap out an IMUGR API key)

 

Use an API for Sales Prospecting- Automate finding sales leads

Sales ProspectingAPI for Sales Prospecting

I have a lot of friends that work in sales and spend an awful lot of time (manually) trying to find new sales leads.  There are a lot of sources out there (LinkedIn, Hoovers, InfoUSA, etc. ) which allow you to use a web browser for searching through their database.  Others open up access to their data by way of an webservice API.

The Clearbit prospect API allows you to find people and bring back demographics as well as email address.  The video demonstrates two examples where I of the Propector and Autocomplete Clearbit APIs.

Prospector and Autocomplete API

AutoHotKey GUI menu for API web service- Connecting to SilverPop via API

GUI menu for API web service

GUI menu for API web service

For years we have relied on using a browser for interacting with our client (SilverPop) servers.  I had heard that SilverPop had an API for doing much of the same thing but was always “too busy” to take the time to investigate.  At some point I started playing with it and was amazed at how much time could be saved.  After you get passed the “hand-shake” between your computer and the server, the rest is pretty easy.  You simply pass XML to tell the remote servers what action you want to achieve.

I then created an AutoHotKey GUI menu for API web service  which streamlined submitting the XML.

 

Here is the AutoHotkey script for GUI menu for API web service