Third Party API connectors (IPAAS) recomendations
I'm having a hard time finding a reliable third-party integration service. I have a master sheet with a dropdown menu that is used to order a product from another department in my company. When "request" is selected in the dropdown I need a new row added to another sheet with a few details from the original row. Then after the row is added I need it to go back to the original sheet and cheange the dropdown to say "Received". I've tried the following:
Azuqua - It is a perfect solution because they have column update webhooks and its easy to configure but the connection breaks about once a month and I have to rebuild the whole thing to make it work again. There's no explanation for why it breaks. It says the status of the connection is good but it just doesn't work. It also gets bogged down if more than 4 rows are updated and I have to go through the list of requests that didn't make the jump and click and unclick them until they show up. Plus Azuqua was bought out and they are shutting the service down.
Integromat- I've set up a couple scenarios but they either don't trigger or the the trigger doesn't return a Row ID which is needed to go back and update the original row.
Automate.io- Good options in a bloated interface to build my flows. It gets triggered and runs through the flows but it only adds a new row to the destination sheet about 30% of the time but it still goes back and changes the status of my dropdown.
MS Flow- Too limited in triggers and actions
Zapier- Seems a little convoluted and cheesy for a reliable business solution with multiple steps. Should I revisit?
I've read about so many and I feel like the few that I've tried have failed. Has anyone had success with any integration services? Mulesoft, Tray.io, Jitterbit, etc....