Linkedin to Integromat

This workflow takes replies from any Linkedin account and sends it to Front, so that you can easily respond messages from multiple accounts in one place.

Network Booster Enrichment

We start with a Sheets Import on the Session Cookie Rotation Sheet. Then we use a Row Filter to segment by Row and use the Network Booster CSV Header Pivot workflow.

Inbox Scraper Enrichment

From the Session Cookie Rotation Sheet we use an API Enrichment step on the Inbox Scraper CSV. Then we use a Combine Columns step to merge api.1 (Linkedin (written)) and api.2 (Message) with a space a delimiter to create a new column Filter that serves as a unique identifier for each message received. This is necessary to De-Dupe by in the next step, as De-Duping by Linkedin (written) would exclude multiple messages received from one person and De-Duping by message would cut off people who received the same message (such as two people who have the same first name or a message that doesn't have a name). This way gives us one row for each message of each person.

Join and Standardize

Next we'll Join the Network Booster table and the Inbox Scraper table by the equivalent of Linkedin (written). Next we will use a Row Filter to remove rows where the equivalent of Message is blank or where the equivalent of Is Last Message From Me is true. Then we'll use a Column Filter to keep the columns we want.

We'll use a Rename step to standardize the column headers and use the Personal and Business Email Split workflow to separate business and personal emails. Then we'll use a Column Filter to remove mail and De-Dupe by Filter.

Export to Inbox Scraper Sheet

We'll use a Sheets Import on the Parvenu Inbox Scraper. Then we'll use Stack Tables to merge the main table with the new data and old data we just imported.

On the new data we'll use a List Contains step to find where contacts are the same as on the Parvenu Inbox Scraper. Then we'll use two Row Filters to segment whether or not Done is blank. Done references whether that specific Linkedin message has already been sent to Front.

Where Done is not blank, we merge it with the Stack Tables step. When Done is blank, we use a Column Filter to remove Done. Then we Insert Column to add Done with an "X" as the default value. Then we merge that with the Stack Tables.

Then we'll De-Dupe by Filter after the Stack Tables, use a Sort step to sort in descending order so that newer data is on top, and a Sheets Export to send the results back to the Parvenu Inbox Scraper.

Send to Front via Integromat

We start using a Front Import step to import the contacts. Then we'll use a Row Filter on the Parvenu Inbox Scraper column to keep the columns that are not Done. After that we'll Join the Front import results with the Parvenu Inbox Scraper, so we get the Front ID if it exists. Then we'll use an API Export to send to Integromat to create a message if the Front ID exists and create a contact and a message if the Front ID doesn't exist.

Update Front Handle in Follow Up Rotation Sheet

After that we'll use a Sheets Import to bring in the Parvenu Linkedin Message Follow Up Rotation and use two List Contains steps to find matching and not matching rows by Full Name. Then a Column Filter to remove Linkedin (written) and Front Handle on the matching path and use an Approximate Match Join on the Full Name by 70% to append the Front Handle. Then we'll use a Stack Tables step, De-Dupe and Sheets Export back to Parvenu Linkedin Message Follow Up Rotation.