Skip to main content

I am trying to do a Google Sheet Lookup Spreadsheet Rows, from a Xero Trigger. The Xero value is the Item Code of the item(s) sold, and usually there’s more than one at once. 

How do I lookup multiple values at once so that I can adjust each product inventory quantity?

Hi @jackallen 

To lookup multiple values at once you would likely need to use the GSheets API via one of these advanced actions:

  • Custom Action
  • API Request