Any experience shares with setting up multi line items for accounting platform (Xero) integration
Sorry, I have nothing to share but this is of interest to me. I’m not familiar with doing such things with Zapier or Integromat but maybe others have.
I’m somewhat familiar with the Xero API and connecting it via Google sheets but haven’t done any integration (for accounting) with AppSheet yet.
Thanks Bellave appreciated , maybe I can use GoogleSheets or Excel (Onedrive) as the direct link to Xero via API ?
Xero API requires authentication to access the clients’ account data.
There are multiple options including:
- writing a cloud function (in your favorite language) that is set up as a webhook within AppSheet
- writing a cloud function (with a scheduled trigger) outside AppSheet
- writing a Google app script web app that is set up as a webhook within AppSheet
- writing a Google app script web app (with a scheduled trigger) outside AppSheet
- using Zapier or Integromat with Google Sheets or Excel
If I were to do it, I would choose option 1.
thanks again appreciated