Send Cleaned Data to Mailshake's API

Send Cleaned Data to Mailshake's API
Description	Take the contacts that passed the filters and the passed the email verification and send them to Mailshake's API for email sequences.
Platform	Parabola
Workflow	Parvenu
Schedule/Trigger	0, 1, 2, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 19, 20, 21, 22, 23

We start with a Sheets Import on the Parvenu Data Cleaned Sheet. Then we use a Insert Row Numbers step and Row Filter to keep the first 80 rows in the Sheet. This is because of rate limits on the Mailshake API.

We use a List Contains step to remove the 80 rows from the Parvenu Data Cleaned Sheet and Sheets Export to send it back to the same Sheet since these contacts will be passed to Mailshake and we don't want to re-run them the next time we run this workflow.

On the 80 rows we use a Magic Cleaning step for formatting. Then we use a Sheets Import on the Email Campaign IDs tab of the Session Cookie Rotation Sheet. Then we use a Row Filter to keep rows where the Stage is Cold and Active is set to "yes". Then we Join the 80 rows with the Email Campaign ID tab and De-Dupe the results. Then we use a Find and Replace step to replace blank cells with "." because blank cells breaks the import to the Mailshake API.

Only one cold email campaign is supported. Update to add split testing. Campaigns can be split test within Mailshake now.

Then we use Row Filters on the Row Number column to keep 10 rows down each path. Ie, 1-10, 11-20, etc. This is to improve stability so that if one API Export fails because of a rate limit, the remaining API Exports are independent and can still work.

{
	"campaignID": {
		Campaign ID
	},
	"addAsNewList": false,
	"addresses": [{
		"emailAddress": "{Email}",
		"fullName": "{Full Name}",
		"fields": {
			"Company": "{Company}",
			"first_name": "{First Name}",
			"last_name": "{Last Name}",
			"job_title": "{Title}",
			"user_company_industry": "{Industry}",
			"user_company_domain": "{Domain}",
			"user_url": "{Linkedin}",
			"user_website": "{Website}",
			"company_name": "{Company}",
			"user_custom_sales_navigator": "{Sales Navigator Url}",
			"user_custom_full_name": "{Full Name}",
			"user_custom_company_location_area": "{Location}",
			"user_custom_linkedin_company_url": "{Company URL}",
			"user_custom_sales_navigator_query": "{Query}",
			"user_custom_linkedin_company_id": "{Company ID}",
			"user_custom_headcount_range": "{Headcount Range}",
			"user_custom_image_url": "{Image}",
			"user_custom_user": "{User}",
			"user_custom_seniority": "{Seniority}",
			"user_custom_company_description": "{Description}",
			"user_custom_vmid": "{VMID}"
		}
	}]
}

Finally we use API Export steps to send the contacts to the Mailshake Campaign using the Campaign ID from the Session Cookie Rotation Sheet.