Zappier transfers
Budget: £20 – £250 GBP
I would like to create a zap to convert csv date from a google sheet into a draft invoices in xero.
I have attached an example of the CSV file with data to be transferred into xero
The zap should create a draft invoice in xero for each customer containing all the product lines from multiple records on the csv. The customer is determined by the channel eg Shopify: pollardscoffee.myshopify.com is customer Pollards Wholesale Ltd and the product line description on the xero draft invoice should be the Order ID ( column A) + the Lineitem name (Colum K) and the quantity should be the Lineitem quantity from the csv file.
I have included an example of the output I would like for one customer - Black Bag Coffee.
We have Zappier Pro Account
I have attached an example of the CSV file with data to be transferred into xero
The zap should create a draft invoice in xero for each customer containing all the product lines from multiple records on the csv. The customer is determined by the channel eg Shopify: pollardscoffee.myshopify.com is customer Pollards Wholesale Ltd and the product line description on the xero draft invoice should be the Order ID ( column A) + the Lineitem name (Colum K) and the quantity should be the Lineitem quantity from the csv file.
I have included an example of the output I would like for one customer - Black Bag Coffee.
We have Zappier Pro Account