"CSV" takes input data in the form of JSON array and transforms them into a CSV format as output.
We will create a flow: "When contacts are imported from HubSpot, fetch contacts from Sendinblue."
Sendinblue doesn’t support the creation of multiple contacts through a JSON input. So, we will convert the query output into a CSV format file using "CSV."
- Go to the Flows tab from the top menu.
- Create a new flow.
- Search and select Setup.
- Setup acts as a trigger in this flow and runs all the child steps.
- Setup doesn't require any configuration. Click Done.
- Setup acts as a trigger in this flow and runs all the child steps.
- Add HubSpot in the child step.
- Add "Get Contacts" query.
- Connect your account.
- Enter the number of records you want to import.
- The records will be imported page-by-page, and the number you provide will be rounded to the nearest page.
- Leave this field empty, if you want to import all records.
- Select the List from which you want to import the contacts. Click Continue.
- Click Test.
- You will receive a success message when Integry fetches all HubSpot contacts. Click Done.
- Click on the three-dots menu on the far right of the query step and then click "Add Child Step."
- Search and select CSV.
- Add "JSON to CSV" action.
- Provide a 'CSV Delimiter' that separates the values in the CSV file (mostly the comma (,) character).
- Provide the input JSON array in the 'JSON Text' field.
- Click on the '+' sign, then Get Contacts, and "Add to Field" in front of 'Obj' to add a dynamic tag to the field. Click Continue.
- Click on the '+' sign, then Get Contacts, and "Add to Field" in front of 'Obj' to add a dynamic tag to the field. Click Continue.
- Click Test.
- You will receive a success message when the JSON array of the records fetched by the query step has been converted into CSV format.
- Click on Test Result to view the converted records.
- All the contacts imported by the HubSpot query have been converted into CSV format and are separated by a (,).
- All the contacts imported by the HubSpot query have been converted into CSV format and are separated by a (,).
- Click on the three-dots menu on the right of the CSV step and the click 'Add Step.'
- Add "File Append."
- Add the Append File action.
- Enter the File Name, File Extension and Data to be appended to the file.
- Click on the '+' sign, then click on JSON to CSV, then 'Out', and "Add to Field" in front of 'output' to add the tag for the data coming in from CSV step.
- Click on the '+' sign, then click on JSON to CSV, then 'Out', and "Add to Field" in front of 'output' to add the tag for the data coming in from CSV step.
- Click Continue.
- Click Test.
- You will see a success message when the data from CSV step has been appended into a file.
- The File Append step will provide a URL of the file containing CSV data of all imported contacts from HubSpot. Click Done.
- Click on the three-dots menu on the right of the File Append step and the click 'Add Step.'
- Add Sendinblue action "Import Contacts."
- Connect your account.
- Enter the File URL.
- You can either enter a value or use tags to add the URL we got in output of the File Append step.
- Click on the '+' sign on the right of the List field, then click Append File, Out, and then click "Add to Field" to add the tag for 'file_url' to the List field.
- Select the List in which you want to import the contacts.
- You can either enter the List name or use tags to add the URL of the List.
- You can either enter the List name or use tags to add the URL of the List.
- Click Continue and the click Test.
- You will see a success message when all contacts fetched from HubSpot have been imported into Sendinblue.
- Save and publish your flow.
Comments
0 comments
Please sign in to leave a comment.