Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

University
Clay live events

Powered by Tightknit

Fixing Column Analysis for B2B and B2C in Spreadsheet Automation

·

·

Hey guys I have a column that analyzes companies and organizes them as either B2B or B2C. The issue is it doesn't run in batches, only when I click on individual cells. I tried duplicating this enrichment column and enabling auto update but still the same issue. Even running the first 10 rows doesn't work

Fixing Column Analysis for B2B and B2C in Spreadsheet Automation | Clay

3 comments

· Sorted by Oldest

Channeled
APP
·
·
This issue could be happening due to a few reasons: 1. If you're using AI-based enrichment (like Anthropic), you may be hitting API tier limits. With lower API tiers, you'll need to process data in smaller batches of around 50 rows at a time. To resolve this, you can try: 1. Processing smaller batches of around 50 rows at a time 2. Creating a new column by duplicating the current one and running it only on the empty rows: • Filter for rows where the current column "is empty" • Run the AI on those filtered rows • Use the "merge columns" feature to combine the results To optimize your enrichment runs, you can also use conditional runs by: 1. Going to the Run Settings of your enrichment column 2. Adding a conditional formula in the "Only run if" box to specify when the enrichment should run
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Hi O J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: