I’ve got a google sheets with multilines. I need to send the data to Xero to create a sales invoice. The problem is that only one line will get sent to Xero. Invoices can be 5 lines, 1 lines, 10 lines. It all varies.
In Zapier this is dealt with by using a Line Itemizer which creates an array and in the Xero configuration you add the array values instead of the actual values from the Google Sheet.
My knowledge in this area is limited and I am not a coder so would appreciate a simple step by step walk through please.
Hi @harshil1712 thanks for your reply. I’m not a programmer so please excuse my lack of knowledge.
You’re suggesting > Get data from Google Sheets > use the Xero API to send the data via http request?
The actual end solution will be to get a Webhook from our e-commerce site with the different line items in JSON format and then send to Xero. I’m actually using Google Sheets as an experiment as the key objective with n8n is to get multiline working. If you have any insight in to doing this via webhook which ‘solves’ the problem that would be great.