Before Monday.com, we used to use Zapier to import our Shopify orders into Google Sheets (as individual rows). Then we used Zapier to lookup that order number (row) to update the tracking column when an order is marked as shipped from Shipstation.
Recently, we made the switch over from Google Sheets to Monday.com to try out some of the new features that Sheets couldn’t do. Only problem is, the Monday.com integration/features on Zapier is sooooo limited!!
Our current (and HUGE) pain point is the lack of Monday integration features on Zapier. As of right now, we have to create a new Zapier “action/task” for each column that we want to populate on our Monday pulse. This can quickly use up at least 9 “actions/tasks” to add just one new order/pulse! I’ve quickly maxed out my Zapier tasks because of this.
As opposed to my Sheets integration, which only required 4 tasks per new order/row.
Second, being able to “lookup” a pulse (on Zapier) would be useful to find an existing pulse, so we can update the status of a particular column. For example, I would use Zapier to lookup a pulse, then update the tracking number once the item is marked shipped from Shipstation.
Third, please update the status column feature on Zapier! Right now, I can only update my status columns by number values (ex: 1, 2, 3, etc.) I have no idea what color represents what number, so I haven’t been able to use this feature! It would be helpful to see my own custom statuses instead (Need Label, Packed, Shipped, etc).
I’ve been anxious to know if anybody else agrees with me on this and if Monday.com is already working on a solution to this!! I would love to have more capabilities between my three favorite apps!!