Remove from Message Sender

Remove from Message Sender
Description	Removes sent messages from the message sender to prevent duplicate messages from being sent
Platform	Parabola
Workflow	Parvenu
Schedule	11, 19

Since the Linkedin Message Sender's file settings are "Delete all files at launch," it will start on line 1 of a Sheet instead of picking back up at line 11 after sending 10 messages.

This allows us to send multiple messages to a contact with a single Message Sender on Phantombuster, as it doesn't remember to skip over contacts and starts at the top of the Sheet every time it runs.

This creates an issue of duplicate messages. To avoid this, we will remove contacts from the Message Sender Sheets after we send them a message with Phantombuster.

To do this we will use a Sheets Import on the Session Cookie Rotation Sheet and Join the "Session Cookie," "Phantombuster IDs," and "Schedule" tabs of the Sheet using a Common Join.

Then we use a Row Filter to make sure the Username is not blank.

We then use an Insert Date and Time step followed by an Extract Text step to extract only the hour without the date or seconds called Hour.

Then we use an If/Else step to create the Clear Message Sender Filter with a value of "X" if Clear Message Sender Schedule contains Hour. Then we use a Row Filter to keep rows where Clear Message Sender Filter contains "X." Then we use a Column Filter to keep Username and Messages Per Launch.

Then we use a Sheets Import on each of the Message Senders and use a Stack Tables step to merge them and De-Dupe on Full Name. Then we'll use an Insert Column to add Common with a default value of "X."

Next we'll use a Join step to combine the Message Sender table with the Messages Per Launch table. Then we'll use Row Filters to split the table by Row that indicates the sales person.

After that for each path we'll use an Insert Row Numbers step, followed by an If/Else step that creates a new column called Filter and fills in an "X" if the value in Row Number is less than or equal to Messages Per Launch.

Then we'll add a Row Filter that removes contacts that do not contain "X" in the Filter column. Then we'll use an Add Row step to add the default sales people's profiles back to their Message Sender Sheet to ensure the Sheet is never blank for error handling.

Finally we'll use the Maintaining the Format of One Table, While Needing the Opposite Table to be Stacked First workflow to keep the original structure of the Message Sender Sheets we imported, De-Dupe by Full Name, and Sheets Export back to the Message Sender Sheets.