I have a Zap that triggers on a cell update in excel.
Today I noticed I had over 300 task on hold. I only updated around 16 cells. It appears that the Zap attempted to run on every subscriber in my Aweber List.
Anyone have any ideas why?
I have a Zap that triggers on a cell update in excel.
Today I noticed I had over 300 task on hold. I only updated around 16 cells. It appears that the Zap attempted to run on every subscriber in my Aweber List.
Anyone have any ideas why?
Hi
Good question.
Please post screenshots with how your Zap steps are configured to help give us context.
See (Step 1) details below
See (Step 2) details below. NOTE The next 2 photos show how I have it set up. Everything below what is shown are just Custom Fields and should have no impact on the reaction of the app.
See (Step 3) details below
This is what it is telling me. I have not run the Zap but maybe 10 or 12 times.
These should have never been run. Notice that there are 1680 of them.
The timestamps show the Zap Runs were triggered at the same time.
Usually that is a result of some sort of bulk update made to the trigger app.
That is why those Zap Runs are held as Zapier detected unusual activity.
You can delete those Held Runs or you can replay those Held Runs.
Zap runs can have a status of Held for one of four reasons:
Learn how to replay Zap runs that failed or were not successful.
The Zap runs page will not show activity if your Zap checks for new data and does not find any.
You can filter your Zap runs by status, date range, owner, folder, apps, or Zap name. You can also search your entire Zap history with the search bar in the upper right, which will search all the data that was sent to and received by each step in your Zaps.
Is there a way to prevent the bulk update and just update the records that are associated with rows that were changed?
Bulk update realy isn’t costing me anything but, I’m sure it puts Aweber’s servers under quite a load to cycle through each subscriber.
The Zap is triggered from Excel.
The Zap Runs show 0 Tasks used.
That means the AWeber Zap steps were not run yet for these triggered Zap Runs.
So, is that normal and something I don't need to worry about or is there something that I am missing and need to correct.
I have the trigger set for whenever a row is updated. Are you saying that having it set up in this manner that whenever I update 1 row the zap will ckeck every row for changes?
I generally advise users to use Airtable instead of Excel/GSheets as it’s better suited in many use cases for integrations and automations.
The Zap trigger you are using triggers when there is a NEW ROW added or when a ROW is UPDATED in the worksheet. (see screenshot)
So you may need to add a Filter as Step 2 to make sure only Rows that are updated in the Exp trigger column pass the filter conditions. (e.g. value exists)
That would make sure NEW rows don’t pass the Filter step.
Also, the issue may be a result of how your have your Excel file formatted. (we would need to see screenshots)
Help articles about using Excel in Zaps: https://zapier.com/apps/excel/help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.