Bulk Enriching Leads: Fixing Column Errors in Spreadsheet Automation

Hello Team, I am currently trying to enrich people on a table with ~ 150 leads to enrich. However when I try to run the column, every cell outputs an error. However if I run the cells one by one, they run correctly. Is there a way to avoid having to click on each one ?

14 comments

· Sorted by Oldest

Clay Support
APP
·
·
Try using Force Run to resolve this issue:
1.
Right-click the column header
2.
Hover over Run Column
3.
Select Force Run All Rows [1]
This helps recover cells experiencing performance issues and won't charge you extra credits for re-running.
If the issue persists after forcing the run, request human assistance by clicking on Talk to a person.
Clay Support
APP
·
·
Did that answer your question?
Hadrien
·
·
So i tested your resolution. I had to pay for every cell that already ran and I still have almost the same number of errors
Loading attachments
Clay Support
APP
·
·
I apologize for the confusion about Force Run. You're right that it shouldn't have charged credits for cells that already ran successfully.
The error message you're seeing ("The integration failed to run - Error. Please reach out to Clay support") indicates a deeper integration issue that requires human investigation.
Since you're experiencing persistent errors after trying the suggested solution and were unexpectedly charged, please request human assistance by clicking on Talk to a person so our team can investigate why the integration is failing and address the credit charges.
Clay Support
APP
·
·
Did that answer your question?
Hadrien
·
·
What/Where is the button Talk to a person
Clay Support
APP
·
·
I understand the confusion about the "Talk to a person" button. Would you like me to connect you with a human agent? Or if you want, I can continue helping you here with more details about your issue.
Hadrien
·
·
connect me with a human
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Andrew Q.
·
·
Hey Hadrien - Do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Hadrien
·
·
https://app.clay.com/workspaces/49478/workbooks/wb_0t47y3oxsozFk3aDqSZ/tables/t_0t47ycjZxQAv6oXpZVG/views/gv_0t47ycjnKeh4Q8DsiGH
Hadrien
·
·
column enrich person
Bo (.
·
·
Hey,
I re-ran the table and everything worked correctly. Sorry about that — one of the providers had issues yesterday, but it’s been fixed now. You should be able to run all rows at once without any problem.

Clay Support
APP
·
·
Try using Force Run to resolve this issue:
1.
Right-click the column header
2.
Hover over Run Column
3.
Select Force Run All Rows [1]
This helps recover cells experiencing performance issues and won't charge you extra credits for re-running.
If the issue persists after forcing the run, request human assistance by clicking on Talk to a person.
Clay Support
APP
·
·
Did that answer your question?
Hadrien
·
·
So i tested your resolution. I had to pay for every cell that already ran and I still have almost the same number of errors
Loading attachments
Clay Support
APP
·
·
I apologize for the confusion about Force Run. You're right that it shouldn't have charged credits for cells that already ran successfully.
The error message you're seeing ("The integration failed to run - Error. Please reach out to Clay support") indicates a deeper integration issue that requires human investigation.
Since you're experiencing persistent errors after trying the suggested solution and were unexpectedly charged, please request human assistance by clicking on Talk to a person so our team can investigate why the integration is failing and address the credit charges.
Clay Support
APP
·
·
Did that answer your question?
Hadrien
·
·
What/Where is the button Talk to a person
Clay Support
APP
·
·
I understand the confusion about the "Talk to a person" button. Would you like me to connect you with a human agent? Or if you want, I can continue helping you here with more details about your issue.
Hadrien
·
·
connect me with a human
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Andrew Q.
·
·
Hey Hadrien - Do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Hadrien
·
·
https://app.clay.com/workspaces/49478/workbooks/wb_0t47y3oxsozFk3aDqSZ/tables/t_0t47ycjZxQAv6oXpZVG/views/gv_0t47ycjnKeh4Q8DsiGH
Hadrien
·
·
column enrich person
Bo (.
·
·
Hey,
I re-ran the table and everything worked correctly. Sorry about that — one of the providers had issues yesterday, but it’s been fixed now. You should be able to run all rows at once without any problem.