Playing with Pipedream
Context: I use email to keep meeting notes but I want them to exist in google sheets as well.
App: Automatically create an entry for my email notes in sheets
Phase 1: Email subject + body → Sheet
If you start with the email trigger they give you an email you can send your mails to invoke a trigger
Then you link a sheet, specify which sheet the output goes to
Deploy
Things I liked:
Very easy to get started with.
They queue the triggered events, so I didn’t have to keep sending emails over and over. (Integromat’s flow was much worse)
Asked for permission to drive and sheet only when I needed it
The colors are friendly. Integromat’s UI felt very busy for some reason
OMG they have just so many integrations, I am so so jealous! They have done things right!
Phase 2: Extract Date
Trying the node step now
I can run any node code. Just import the library, no install, it’s so awesome!
The debugging process is cumbersome here, edited the name of the node step and I missed changing the name in the next step which was giving error, took some time to figure it out.
Generally it’s designed well, I like the naming schema and testing of variables as well.
The node function always takes “steps” as input and give out some data. I think that might make reusability a trouble. Not the biggest concern, but a side note.
Phase 3: Extract Person’s Name
Using the compromise nlp library to extract the name from the subject and put it in another column
Here’s an example script. Side note: I don’t like JS shell, it took me quite some time to get the example working
Cool, this is working, next I need to setup auto forwarding and the pipeline is done!
Closing thoughts
Pipedream is awesome, I wonder how will the platform evolve and how will it integrate with the regular coding workflows and tools