Our customers of [Streak](www.streak.com) use zapier heavily to connect to all their other tools so we have a ton of experience with it. We're currently building an alternative for our users natively into our app (we think we can make a more optimized experience for our app).
I think we've stumbled onto a pretty key product insight - we're basing our automation tool on a spreadsheet. Zapier is clearly optimized for non-technical users so doing any logic, even basic if statements, is really cumbersome. On the other end of the spectrum, pipedream and tools like it rely on your users knowing how to code. We think spreadsheets are the perfect balance, most users (at least ours) know how to do basic formulas and understand references.
Spreadsheets are awesome:
- development environment is completely set up for you, no tooling needed
- editor, runtime, debugger are all the same tool
- by default you see the output of all your computation, its a secondary action to see the code
- you can preview the intermediate data results at every step of your computation making debugging a dream
Here's how we're thinking of applying it to the Zapier use case:
- a series of zapier like triggers and actions
- each step is just a 2 column spreadsheet (property name and property value)
- the value can be something hardcoded, a reference to a value in a previous step, or a complicated formula
Anyone tried something like this before?