Skip to main content
Best answer

How to remove old records from a Zapier table before importing new data

  • June 12, 2025
  • 6 replies
  • 77 views

Forum|alt.badge.img+1

I have a Zap process which uses EasyFTP to populate a Zapier table every week from a CSV file.

It uses the Looping by Zapier step to create each record.

At the moment the Zap keeps adding more and more records.

I would like to be able to purge all of the records prior to importing the new ones but am unsure how.

Best answer by Troy Tessalone

Hi ​@RyanForsythe1979 

You will do a similar process.

Zap steps:

  1. Trigger: [APP] - [EVENT]
  2. Action: Tables - Find Records
    1. MAX: 1000
  3. Action: Looping - Create Loop from Line Items
  4. Action: Tables - Delete Record

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34004 replies
  • Answer
  • June 12, 2025

Hi ​@RyanForsythe1979 

You will do a similar process.

Zap steps:

  1. Trigger: [APP] - [EVENT]
  2. Action: Tables - Find Records
    1. MAX: 1000
  3. Action: Looping - Create Loop from Line Items
  4. Action: Tables - Delete Record

 


Forum|alt.badge.img+1

Thanks for the reply Troy.

Does this need to be created as a separate Zap as I can only use the looping action once?

r


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34004 replies
  • June 12, 2025

@RyanForsythe1979 

You can have the 1 main Zap trigger 2 other Zaps via webhook chaining: 

 

For the Zap that ADDS records, add a Delay step, so the other Zap can first fetch the records to delete.

Help for Delay: https://zapier.com/apps/delay/integrations#help


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9662 replies
  • July 1, 2025

Hey ​@RyanForsythe1979, just checking in—did Troy’s replies help to point you in the right direction? 

Want to make sure you’re all set, so please keep us posted on how it’s going! 🙂


Forum|alt.badge.img+1

Hi ​@SamB. Yes, I got it working thanks. ​@Troy Tessalone thanks for your help.

I must admit that I couldn’t figure out how to setup the webhook so I just created 2 separate Zap runs. Works a treat :)


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9662 replies
  • July 2, 2025

Thanks so much for confirming that, ​@RyanForsythe1979. I’m so pleased you found a way to get it working without using webhooks—nice work! 🙌

And a big shoutout to ​@Troy Tessalone for helping out here! 🤗