Screenshot 1 at below is the google sheet that represent our source of data. Bundle 1 to Bundle 5 are the line items that I need to create Xero Invoice for. However, Bundle 6 data to Bundle 10 data are the line items that I need to create another separate Xero Invoice For.
Here’s my requirement and any great suggestion over the function available in Make.com can be recommended?
Requirement: I need to create Xero invoice which the account code varies according to the description on each data bundle.
- Bundle 6 data’s account code in Xero Invoice suppose to depends on Bundle 1 Data description. If the description comes with “Shell V-Power 97 BULK”, the account code is “9O00/S01”.
- Bundle 7 data’s account code in Xero Invoice suppose to depends on Bundle 2 Data description. If the description comes with “Shell FuelSave Unleaded 95 BULK”, the account code is “9O00/S02”.
- Bundle 8 data’s account code in Xero Invoice suppose to depends on Bundle 3 Data description. If the description comes with “Shell FuelSave Unleaded 95 BULK”, the account code is “9O00/S02”.
- follows the rule at the above.
In such a case, any function or modules in make.com that i can apply in order to achive the above requirement?