To trigger transactional Campaign in Mailmodo through your software stack via Pipedream, follow these

steps:

Prerequisites:- 


1. Designed an API triggered Campaign

2. An account on Pipedream


1. Creating a New Workflow to trigger the above campaign in Mailmodo whenever a row in appended in your Google Sheet


Step 1 - On the Pipedream dashboard, click on 'Workflows→New'



Step 2 - Since the trigger event will be addition of a row in your Google Sheets, in the trigger tab, choose Google Sheets

 


Step 3 - In the Trigger Event section, choose New Row Added (Instant).

 


Step 4 -  Select the Google Sheets account you want to use. If don’t have an account linked with Pipedream, click on ‘Connect new account’ and choose.


 


Step 5 -  Select the Spreadsheet and Worksheet to be used to create the trigger, and click on ‘Create Source’

 

Step 6 – Event section will display all rows in the Workbook as New Events. Select one of the Event and click ’Continue’


 

2. Add a Step to generate API trigger

Step 1 -  In the App tab, search/click on HTTP/API.

 


Step 2 -  select on the ‘Send POST request’ to send API trigger


 


Step 3 -  Configure the API URL,API Key and Body (get these details from Mailmodo dashboard: Transactional--> Select the campaign triggered by API--> Trigger Info). Map the body Key with the Value from Spreadsheet data.


Mailmodo dashboard:

Pipedream workflow:

Step 4 -  Click ‘Test’ to send a test Campaign on selected email ID.After getting the Success message for Test Campaign, click ‘Deploy’  to activate the workflow.