Zapier Integration

The final description is updated: https://treepl.co/public-backlog-state/request/zappier-integration
The approximate quote will be provided shortly (after the closest grooming session that is scheduled for today).
Then the backlog item will be transferred to the reviewed section and will be opened for voting.

1 Like

Hi Shannon. Have you been able to get this to work? I have a similiar member site that will need a set of follow up reminders.

Is there any ETA on this, or is it possible to get access to a beta version or something? We need this to send one of our clients live; certain form submissions get sent via Zapier to Salesforce.

Not sure on ETA but it is in the ā€œIn progressā€ schedule on the backlog, so hopefully not too far away.

For form submission workflows in particular, Iā€™ve managed to do Zapier integrations using the Zapier email parser ( https://parser.zapier.com/ ). It can be a little fiddly to set up but could be a temporary workaround for you.

1 Like

You are a legend Adam, thank you. Looks like that solution will work for us.

1 Like

Could something like this be set up for an order to get it into ShipStation and create a shipping label? Iā€™m looking for a solution to create shipping labels, but Treepl doesnā€™t offer this. Any suggestions would be great. Thanks.

Sure. We have access to all the data within a workflow email, so you can therefore parse it with Zapier.
The trick will be laying out the email so that Zapier accurately and consistently parses it. The more bits of data, the more fiddly itā€™s going to be, but it should certainly be possible.

Ok, thank you. I will test it out.

Weā€™ve done something similar to this using a custom Gmail address thatā€™s added to the workflow. A Gmail extension copies the email to Google Drive triggering Zapier to collect the data. Happy to share the finer details if needed.

1 Like

Thanks, yes it would be nice to hear how you worked this out. I donā€™t want to have to rely on Zapier too much, but if it can help for some additional functionality, that would be great.

Hello, It would be great to hear how youā€™ve made the Zaps work. Iā€™m trying to get a Zap to parse an email that sends the order json to Parser > Javascript > Shipstation. It looks like the email is sent correctly, as Parser gets the data, but Iā€™m not sure why the javascript fails (SyntaxError: Unexpected token u in JSON at position 0). Could it be that some of the values in the json are null? The javascript Iā€™m using is:

let myjson = JSON.parse(inputData.mydata);
output = [{value: myjson}];

Iā€™m using the ā€œEmail Body Plainā€ object to pull the data into the javascript. The workflow email that goes to EmailParser is:

{
	"Customer": {
		"FirstName": "{{this.Customer.Firstname}}",
		"LastName": "{{this.Customer.Lastname}}"
	},

	"Order":{{this.order}}
}

Any ideas on how to get the data to work when imported would be great. Thank you.

The way Iā€™d approach this is to use an app like mailparser.io to parse the data. i.eā€¦

  1. Send order data via workflow notification to mailparser (use the mailparser wizard to identify the fields you want). Can be read from any format but basic comma separated text is prob easiest.
  2. Have mailparser write the data to a google sheet. A new row will be added to the sheet for every new order workflow notification.
  3. Connect Zapier to trigger when a new row is added in Sheets.
  4. Modify Zapiers existing ā€˜Sheets to Shipstationā€™ Zap for your specific purpose.
    Hope that helps
1 Like