Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello!

I'm new to using Zapier, and I'm attempting to automate the following process:

User orders a meal plan in Shopify

Shopify sends data to Zapier, then to Monday.com (a task/project management tool, glorified Excel)

Zapier should then look for a corresponding Pulse (Row) that matches the name of the person placing the order.


I have 2 steps that filter for either: New Customers or Returning Customers based on their order history, so it will either tell Zapier to create a new Pulse (this is done and tested, super easy) or find the already-existing record in Monday and update appropriate amounts/plan type/order date/etc...


I'm unable to figure out the "Search for user by Pulse ID" step, and would appreciate any insight in how I might go about finishing that part.


Thanks!


So @johnnyacroseed - the problem is, you'll need the ID of the pulse to update it, but Monday.com doesn't have any search steps to allow you to find the pulse and get that I'd.

A bummer, right?

To solve this, edit the zap that creates the new pulse for the new customer. One of the output values will be the pulse ID.

You then want to create a Google Sheet and add a step that writes that ID to the sheet in one column, alongside the customer's email address in another column.

Your existing customer zap will then search said Google Sheet by customer email address - then you'll have the pulse ID.


Seems to make sense to me!

I'll give this a try and see how it goes, thanks!


@johnnyacroseed try Lookup Table under Formatter -> Utilities. Zapier has a great article on how to use it – it's great. One less step, no need for Google Sheets and does the same thing.


@markymark what you are suggesting here won't work as @johnnyacroseed is trying to share the information between different zaps and dynamically add to the "look up table" so using a google sheet (or other spreadsheet/database like app) is the solution that would work.


Terms & Conditions