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.