is there a way for me to run an enrichment column that pushes people into a sequencer on a weekly basis with a set number of rows each week
Yes, you can set up scheduled enrichments that run weekly and push people to our native email sequencing feature.
To schedule weekly enrichments:
1. Click the ⛭
icon in your table
2. Select "On a schedule"
3. Choose "Week" frequency
4. Select specific columns or entire table
To push to sequencer:
Use "Send Table Data" to transfer enriched leads to a campaign, or use "Send Leads to a clay email campaign" for automatic setup.
However, the sources don't specify controlling the exact number of rows per weekly run - scheduled columns run all qualifying rows each time.
i only want one column to be weekly
Yes, you can schedule just one specific column to run weekly. When setting up the schedule: 1. Click the ⛭ icon in your table 2. Select "On a schedule" 3. Choose "Week" frequency 4. Select "Only selected columns" instead of "All columns" 5. Choose the specific column you want to run weekly This way only your chosen column will run on the weekly schedule, not the entire table.
Hey - Josephine V. Add Formula Column FLOOR (ROW_NUMBER - 1) / 25) + 1 creates a "Week Number" for batching Add Filter Column: IF(week_number == 1, "Yes", "No") marks rows to send this week Filter Table: Show only rows where "Send This Week" = Yes Connect to Sequencer (e.g. Lemlist) Only filtered rows will be sent Next Week: Change the condition to == 2, == 3, etc. Let me know if it's works.
Yes, that approach works well! You can create formula columns to batch rows weekly:
1. Add Formula Column with FLOOR((ROW_NUMBER - 1) / 25) + 1
to create week numbers
2. Add Filter Column using IF(week_number == 1, "Yes", "No")
to mark current week's rows
3. Filter your table to show only "Send This Week" = Yes rows
4. Connect to sequencer - use "Send Table Data" to transfer filtered leads to campaigns
5. Next week: Update the condition to == 2
, == 3
, etc.
You can also use conditional runs in enrichment columns with the "Only run if" setting to process only filtered rows, which saves credits
Hello Josephine! Thanks for reaching out! Do you mind giving me some more context and also share the table link URL of the table in question? What is the flow you are imagining specifically? We can find a way to filter by week without having to manually change things.