+1
Inside my google sheet document I might upload 10 new products at a time.
Inside zapier the zap will run everytime a new row is added to google sheets.(trigger)
It will then post to social media every row.
Because I add 10 rows at a time, it will batch run 10 posts.
I want to delay each post by 2 hours so I dont end up spamming my facebook group.
Post 1 - SEND
Post 2 - Delay 2 hours
Post 3 - Delay 4 hours
Post 4 - Delay 6 hours
etc...
+14
Hi
Good question.
Try adding this Zap action: Delay - After Queue
https://zapier.com/help/create/customize/add-delays-to-zaps#delay-after-queue
+14
As an alternative, you can use Airtable instead of GSheets.
In Airtable you can use Date/Time field types to set a date & time.
You can use a Formula field to detect if the Date & Time have passed from NOW().
You can use a View with Filter conditions to trigger Zaps.
+1
Hi
Good question.
Try adding this Zap action: Delay - After Queue
https://zapier.com/help/create/customize/add-delays-to-zaps#delay-after-queue
Thanks for your response.
I’ve tried this a few times but it does not seem to function in that way as the trigger has already loaded the batch of new rows.
No matter where I put that delay, its delaying the batch and not the individual post.
Currently its
If I place the delay queue it’s unclear where it should go, altho I’ve tried numerous different ways
+1
As an alternative, you can use Airtable instead of GSheets.
In Airtable you can use Date/Time field types to set a date & time.
You can use a Formula field to detect if the Date & Time have passed from NOW().
You can use a View with Filter conditions to trigger Zaps.
Im sure its a good workaround, one I may consider down the road but for now Its anothe expense in time and learning Id prefer to avoid if possible.
+14
The Delay would be Step 2.
+14
The Delay After Queue option allows you to create a queue of actions to run at a later time. When a Zap is triggered, it adds actions to the queue. The queue then plays the actions one at a time in the order that they were added to the queue. There is a delay between each set of actions for a Zap. The Zap will be delayed for a set time after the last delay in the queue.
This can be useful if you are running into limits with too many requests to an app, or if you have multiple Zaps that may try to update a record at the same time.
To use Delay After Queue:
TipMultiple Zaps can share the same queue if they use the same queue name. Zapier recommends you enter a static value for the queue title instead of mapping a field from a previous step.
NoteThe Delay After Queue action does not guarantee that the steps following it will never run simultaneously. Slowdowns in Zapier’s infrastructure and auto or manual Zap run replays after errors may cause some steps to still run at the same time.
After setting up your delay, click Test & Review and check if the date matches the delay conditions you’ve set up.
TipIf you want your action(s) to run based on a recurring event that doesn't occur at fixed intervals, you can create a recurring event in Google Calendar and add a Google Calendar action to schedule your action(s).
+1
The Delay After Queue option allows you to create a queue of actions to run at a later time. When a Zap is triggered, it adds actions to the queue. The queue then plays the actions one at a time in the order that they were added to the queue. There is a delay between each set of actions for a Zap. The Zap will be delayed for a set time after the last delay in the queue.
Thank you, I have read this previously, but, as mentioned it’s not functioning this way and regards to the order of actions, I have set up this way and the other ways still resulting in the same problem.
+14
We would need to see detailed screenshots with how your Zap steps are configured.
+1
This is only the information you need:
Perhaps you can send a detailed guide on how you would configure these 3 steps.
+14
Can you please provide screenshots as proof of how your Zap steps are configured?
That would not require showing any personal info and can be redacted in screenshots.
+1
Can you please provide screenshots as proof of how your Zap steps are configured?
This is only the information you need:
Perhaps you can send a detailed guide on how you would configure these 3 steps.
+14
Ok, if you are unable to provide screenshots with how your Zap steps are configured, then I’m limited in my ability to evaluate and advise on whether your Zap steps are configured correctly.
+1
Ok, if you are unable to provide screenshots with how your Zap steps are configured, then I’m limited in my ability to evaluate and advise on whether you Zap steps are configured correctly.
Cool 👍
+11
Hi there,
I wonder if you could get around this by just adding a column to the Google Sheet where you add the product details to state how many minutes or hours you want to set the delay for? Then you’d set the Delay by Zapier action to use the Delay For rather than the Delay After Queue. And in the Time Delayed For (value) field (on the Delay action) you’d select the value from the extra column that was added in Google Sheets.
Do you think that sort of approach could work?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
