In this article, you will learn how to export your contacts’ data through:
Data Collection node
The fastest and easiest way to export specific contacts’ data is through the Data Collection node. It works great if you need to gather the answers to a specific question quickly.
You can set up a data collection block to collect the contact’s replies and send it in an automation. After the collecting part is done, you can download the spreadsheet with all responses directly from the corresponding message block.
1. Find the Respondents button in the message block or the Show Responses button in its overview. Either of these buttons will take you to the list of responses.
2. The responses will appear in a spreadsheet-type view. In the upper right corner of the page, you'll see the Export .csv option. Click it to download the file with all of the listed responses.
Google Sheets integration
To export all of your contacts' data, you can use Google Sheets Integration.
💡 Note that connecting this integration does not start the export. To export the data, you need to set up a specific action and send it to your contacts through automation. Below is a step-by-step guide.
1. Create a new automation.
2. Add an action node as the first message of the automation.
3. Choose the Insert row Google Sheets action.
4. In the Google Sheets wizard, you can select the spreadsheet where you want to export the contact’s data, set the worksheet, and choose the Custom or System Fields you’d like to export. You can also transfer the Tags' data, but they will be passed as a True/False value depending on whether the contact has the tag or not.
For everything you want to export, you will need to create an individual column in the spreadsheet:
5. Once the action is set up, you can save the changes and close the setup window.
6. Don’t forget to set the automation live when you finish setting up the action. Otherwise, you won’t be able to select it for the broadcasting.
7. When the automation is set live, we can send it as a broadcast. To do so, head to the Broadcasting tab, press the Broadcast From Automation button, and select the automation you’ve just created.
8. By default, the broadcast will be sent to all the available contacts. You can use conditions in the Target Audience tab to split the audience into smaller groups if you need to:
💡 As the broadcast only contains an action, no actual message will be sent to the contacts. Thus, there’s no need to worry about the contact’s channel or the last interaction time.
9. Once you set up the audience, press the Send Now button to send the broadcast:
As the broadcast is sent, the data you’ve set up in the Google Sheets action will be passed to the spreadsheet:
⚠️ You can trigger only 250 requests to Google Sheets in 100 seconds, meaning you can send only 250 contacts into that sheet per 100 seconds. If you send more, Google might reject your request, and all of the following data will be lost. We recommend splitting your audience into small groups to get it done.
External Request
Last but not least, you can export complete contact data to your server using our Dev Tools: External Request.
To do so, create an External Request that would pass the variable Full Contact Data to the specified server.
This variable contains all the information in JSON format. External Request doesn't have any limit for the number of triggers, but you need programming skills to set it up and the external server to send the data to: