Is it possible to create arrays from Google sheet entries? I want to group data by either date or contact to create an invoice in Xero. How do I group these information into an array.
Hey there,
use the Search module to get the rows you need from the google sheet, followed by an Aggregator module to combine them in an array. In the configuration of the module, you will have several options on what to include in the array from the incoming data.
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of two modules:
Use the “Group by” field in the Array Aggregator to insert the Date or Contact that you want to group by. If you use this option, you might need to use another Aggregator after.
This is just an example. Your final solution may or may not look like this depending on your requirements.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.