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

3 comments

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: