Exporting Mailmodo template submissions to your software stack via Zapier is quite simple. To do this, you need to first integrate your Zapier account with Mailmodo. Refer to the this guide to learn the same.
Let’s demonstrate this feature by exporting form submissions in Mailmodo to a Google Sheet.
1. Setting up the trigger
To do this, on the Zapier dashboard, click on 'Make a Zap'. You will be directed to select the Action Trigger
In the ‘App event’, search for Mailmodo and click on it (Mailmodo 1.2.0) to fill in the details for the trigger.
In the ‘Trigger Event’ select Template Submission and click on Continue
Next select the Mailmodo account. You will be asked to sign-in in the next step. Here, you need to paste the API key that you received in Mailmodo. You can access it anytime by going to the 'Integrations' tab in Mailmodo, and clicking on 'See details' under Zapier
Paste the API key in the box. Then click on 'Yes, Continue'.
Following screen will appear. Here, click on 'Continue' to set up the trigger.
In this step, you have to set up the trigger. Enter a name of your choice for the Zap, select the template for which the form submissions have to be exported, select the form in your template and continue.
The trigger is now set up and can be tested by clicking on 'Test trigger'
2. Setting up the action event
The next step involves connecting the workflow to the software stack you want to export the data to.
Since we are making this Zap to export our submissions to a Google Sheet, click on Google Sheets in the ‘App event’.
Select the action event (this is performed when the Zap runs) as ‘Create spreadsheet row’ and continue.
Now select the Google account you want to continue with.
Enter the Google Drive, Spreadsheet and Worksheet details. Now, map the Worksheet column headers to the respective form fields in the template chosen and click on 'Continue'.
Review the details and click on 'Test & Continue'
The form test data will be sent to your spreadsheet. At this point, you have successfully created the zap. Now just turn on the zap and you’re done!
The Zap will be created for the chosen template and all submissions henceforth on campaigns with this template will automatically be populated in the Google Sheet.
A sample submission sent to Google Sheets via Zapier is shown below.