Want to send contacts from Wiza to a Clay table? This article will show you how!
Make sure you have API access enabled in your Wiza account. Contact our Support team today via our live chat (bottom right corner)
1. Log in to Clay and click 'Create new', then click 'Table'
2. Click 'Import Data from Webhook'
3. Click 'New blank table'
4. In the right menu, copy the Webhook URL
5. Go to your Wiza API Settings, and paste the Webhook URL, then click 'Save'
6. Return to your Clay Table, and click 'Add column', then click 'Add enrichment'
7. Click 'HTTP API'
8. In the right menu, click 'GET' in the Method dropdown
9. For Endpoint, paste "https://wiza.co/api/lists/#ID/contacts?segment=people"
10. Replace '#ID' with / and select 'id' from the dropdown menu
11. Click 'Add a new Key and Value pair'
12. Enter 'Content-Type' as the Key and 'application/json' as the Value
13. Enter 'Authorization' as the Key and 'Bearer "WizaAPI"' as the Value. Then click 'Save and run'
See step 5 to get your Wiza API key
14. Your Wiza Data will not be pulled into the clay table. You can view it by clicking '200'
200: Success – Data retrieved successfully
15. Click 'Add column', then click 'Add enrichment'
16. Click 'Write to Other Table'
17. Click on Your Name, then click 'Settings'
18. Click the 'API key' tab, then copy your Clay API key
19. Return to your Clay Table, and click 'Add account'
20. Paste in your Clay API Key, then click 'Save'
21. Click 'New table'
22. Click on 'Write from: Pull in data from a Webhook Table' to open your new Clay Table
23. Add Columns for all the data fields you would like extracted from the Wiza data output
24. In this example, I created columns for Full Name, Email, Job Title, Company Name, City, Region, and Country
You can add as many fields as you wish
25. Return to your original Clay Table, and click 'data' from the 'Select a list from a column' dropdown menu
26. Click on Add, and map all of the Wiza fields to the appropriate columns in your 2nd Clay Table
27. Once all columns have been mapped, click 'Save and run'
28. Your data has been successfully pushed to your 2nd Clay Table
29. Return to your 2nd Clay Table to view your data
