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: Trigger--> Select the campaign triggered by API--> Setup steps). 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.