Integrating Clay with Phantombuster: Troubleshooting Data Issues

Hello Clay Team- i integrated a clay table with phantombuster api to push leads to clay. I have a row 1 with "150 entries pulled." I created 5 columns from the phantombuster data. I attempted to run the column with 150 entries but am only able to run 1 row. here's the table https://app.clay.com/workspaces/507736/workbooks/wb_0svvp1kHwmtCaU8mQU7/tables/t_0svvp3w2wUAToWfUmPv/views/gv_0svvp3wZk62A6oT92sg what do i need to do to get the table to populate all 150 entries?

9 comments

Channeled
APP
·
·
To populate all 150 entries from your Phantombuster API integration, you need to adjust the row settings in your Clay table. Here's how: 1. Click on the "Rows 🔽" button at the top of your table. 2. In the settings, set the "Starting Row" to 1. 3. Set the "Row Limit" to 150 (or a higher number to show all entries). 4. Click "Save Changes". This should display all 150 entries pulled from Phantombuster. If you're still having issues, make sure you've correctly set up the PhantomBuster integration: 1. In the Source panel, select the correct PhantomBuster account. 2. Specify the correct Agent ID. 3. Run your enrichment to pull data from PhantomBuster. If you need further assistance, please request human support by clicking on "Talk to a person".
Sources: Format Rows Phantombuster integration | Documentation | Clay University
Adam G.
·
·
That doesn't solve the problem of the table not running 150 rows
Adam G.
·
·
help- https://app.clay.com/workspaces/507736/workbooks/wb_0svvp1kHwmtCaU8mQU7/tables/t_0svvp3w2wUAToWfUmPv/views/gv_0svvp3wZk62A6oT92sg
Bo (.
·
·
Hey, to get all 150 entries into individual rows, you’ll want to use Write to Other Table. This will split the batch data and send each entry into its own row in a new table. Here’s a quick guide to help: Write to Table – Clay University Let me know if you’d like help setting it up!
Adam G.
·
·
deleted message
Adam G.
·
·
Bo (. Hi Bo. Here's a better example of challenges in writing to table. I've done a work around to accomplish what I needed but in that work around I also lost the first name of each person. So i still need to write to table and still not getting it done. This seems like a very simple write to table scenario. here's the table with the first name https://app.clay.com/workspaces/507736/workbooks/wb_0svv2viqquwKVMfXW8p/tables/t_0svv2viarrSGsgFe3QC/views/gv_0svv2viMj6KHbwo2Sks and here's the table I need to send to https://app.clay.com/workspaces/507736/workbooks/wb_0sw07106J6esa6U3if7/tables/t_0sw0710vsXF47nbcNKG/views/gv_0sw07108TXJBN82BYMq i did the write to table enrichment and not getting any results in the new table. what am i doing wrong?
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/BcxYWJZ6 Let me know if you have any follow-up questions!
Adam G.
·
·
Thank you Bo (. Why don't the first names column populate the whole column? I attempted to lookup multiple rows to get all first names in the table and nothing imports. "X 0 Records Found." The 10 names that you did move over were duplicates in the 75 row list so i deleted them. The columns are mapped between the 2 tables. I've selected the right table to get the data from. What am i doing wrong? https://app.clay.com/workspaces/507736/workbooks/wb_0sw07106J6esa6U3if7/tables/t_0sw0710vsXF47nbcNKG/views/gv_0sw07108TXJBN82BYMq
Bo (.
·
·
Hey, The reason the first names weren’t populating is because that data doesn’t actually exist in the table you were trying to look up from. Also, the lookup didn’t work because the reference format was missing a forward slash. Here’s how to fix it: ** Use the forward slash to reference the correct field—for example, /email instead of just email. ** Once you do that, the lookup will start showing values. ** When you see “1 record found,” click into the row to preview and match the values. ** You can also click the column header, select Edit Column, and double-check that everything is mapped correctly. Let me know if you’d like help walking through it.