title: expand or collapse grouped columns in google sheets using code
body: <p>Google sheets have finally added the useful grouping feature. I have a many columns grouped into 10 groups. let's say 1-10. I want group 1 and 5 expanded when I change one cell to one value and group 2 and 6 expanded and group 1,5 collapsed when I change the same cell to a different value. Is it possible to expand or collapse the groups with code?</p>
  
  <p>right now, I have to manually hit the plus and minus signs once I want the sheet to display a different set of data.</p>