Integromat Integration- Exporting Responses from the email sent to users to Google Sheets
Modified on: Thu, 9 Jun, 2022 at 12:35 AM
You can integrate Mailmodo with Integromat for the following use cases-
1. Export Responses from the email sent to users.
2. Send campaigns to particular contact IDs (guide)
3. Upload contact IDs in Mailmodo (guide)
Here is the step-by-step process to export responses from the email sent to users.
Step 1 - Log on to the Integromat Account Dashboard and click on the ‘Create New Scenario’ button to set up the link between Google Sheet and Mailmodo.
Step 2 - Click on skip in the next window. This will open the canvas where you can make the connection happen. Click on the ‘Ball’ with the question mark to add Mailmodo as the module as shown below.
Step 3 - Search for Mailmodo and add it by clicking on the Export Submission Option out of the three options showcased in the pop up.
Step 4 - Now you need to set the WEBHOOK by clicking on the Add option.
Step 5- Next click on the add button in Connection. Set the Connection name in ‘Create a connection’ pop-up.
Step 6 - Get the API Key of the campaign from Mailmodo to set the API Key here. For this you need create a transactional campaign with Integromat as the selected app. Once the campaign is enabled, click on 'Show API' from the Trigger Info page. Now, copy that API key and paste it in the Integromat’s API Key field.
Step 7 - After that, you have to select the specific template displayed in the drop down menu.
Step 8 - Select the form label showing in the form option. And Click on the Save button.
Step 9 - In the Select WEBHOOK option, choose the same WEBHOOK created before and click OK. And your Mailmodo setup would be ready to integrate to any application.
Step 10 - Now, you need to add a module by clicking on the ‘semi circle ball’ on the right side of the main ‘ball’. After clicking search for ‘Google Sheets’ to add it as the module.
Step 11 - In the list of options in the popup, choose the ‘Add a Row’ option and the right spreadsheet name from the list of spreadsheets, comes after you click in the text field.
Step 12 - Choose the right sheet in the ‘sheet’ field. This field is basically the name of the sheet you would be wanting to push your data under the main spreadsheet.
Step 13 - In the Values text fields, select the right labels as mentioned in the sheet to each of the value fields and click on OK to complete the setup.
Step 14 - Lastly, Click on RUN ONCE to do the test run of the integration.
Now you have the integration up and ready to export submissions when you send the template to users.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.