To trigger transactional Campaign in Mailmodo through your software stack via Pipedream, follow these
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.
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.