I have the same problem.
- Run once every day.
- Find all contacts in HubSpot with Birthday = Today’s Date. (Sometimes more than one).
- Send congratulatory emails to each contact.
I have this working for one contact.
But, the first problem is that the HubSpot find method only returns one contact, even if there are multiple.
The second problem is the loop or “for each”, that is missing.
There should be a “for each" block that will start a sub-zap or branch for each record found, and then possibly continue with the main thread.
Any suggestions welcome.
Thomas.
Moving this to “Ask the Community” for better coverage.
Hi @thm22
Unfortunately, ‘find all’ operations just aren’t possible with Zapier.
The closest you could get is to export a CSV of members + birthdays daily and use a method like this to run on all of them.
Hello, Troy!
Thank you for the link, interesting.
This question is about Zapier and how it can handle such scenario. Trello was mentioned simply as an example as it might be more familiar to understand use-case
You’d likely have to use the app’s API to GET results then create a looping Zap to processes all the applicable records.
In terms of Zapier actions what can be used for that?
- use the app’s API to GET results ← Do you suggest using Code action? But what about auth for making such call to service? Search action provides out of the box and here it is not clear how to use it
- looping Zap ← I was unable to find any relevant action with word “Loop” in it, what do you mean?
Thank you for your help!
Hi @Ilya Tsuryev
Not sure if you were able to get this sorted. As Troy has demonstrated, Zapier isn’t best suited to ‘find+action’ all type operations - it’s doable, but you’ll need to use webhooks and coding to achieve it.
[advanced]
Webhook action step can be used to make a GET request and can handle authentication.
I suggest reading up on the help documentation here: https://zapier.com/apps/webhook/help
Looping Zaps can be done in a few ways:
- Code step using custom Javascript or Python
- Combo of steps involving these apps Webhook, Code, Filter
I suggest reading up on the help documentation here: https://zapier.com/apps/code/help