How do I automate the following with Monday.com, Typeform and Calendly?

Hi @Troy Tessalone , thank you for the insight! I’m struggling with Zap 2, step 3!

That’s what I have below and I get an error message “Invalid value for undefined on undefined. Item not found”. It’s probably related to the item ID?

@SarahC 

The Item ID fields expects the Monday Board Item ID which is a number as indicated by the 123 icon.

You would map that from the previous Zap step where you found the Monday Item.

Hi @SarahC we are a monday.com implementation business and help clients like yourself set up their monday.com accounts. If you need any support feel free to book a call here. 

Hi @Troy Tessalone,

My calendly is set up as a “round robin”. I wonder if there’s a way to create an automation, so the right sales rep is assigned as the owner in Monday.com depending on who the lead booked with on Calendly.

I tried the same process as you mentioned earlier “Monday - Change Multiple Columns Value”, but on Monday.com, the Sales rep is identified by their first name and last name, and in Calendly, there are identified by their email address. Also in the “Column to Receive”, I don’t have the “owner” field from Monday

Thanks!

@SarahCC 

Try adding a Lookup Table to translate the values from what Calendly provides to what Monday expects.

Hi @SarahCC 

Attached is how we set it up for our crm with round robin calendly. I would recommend having the person column and if you don’t have that then add a status. Let me know if you need any additional support. 

Hi @WorkflowMagic 

The Paths approach does work as a solution.

However, in this case it creates avoidable redundancies that a lookup table prevents.

For example, say you have 5 Paths with the same steps expect for 1 field value.

Now consider you want to add/remove/adjust a step, that change has to be done across all the impacted Paths, which creates more maintenance and possible error being introduced.

Using an external lookup table (e.g. Airtable, GSheets), allows the Zap to not only be dynamic, but also to scale (up/down) from a single source of truth by managing the data outside the Zap.

Have you tried the lookup table approach in your Zaps?

Both solutions seem difficult for me to achieve lol. I might have to hire someone to teach me

@SarahCC 

If you need help, consider hiring a Certified Zapier Expert.