Hey everyone — hoping someone can help crack this.
I’ve got a Make scenario that:
- Uses a webhook to trigger creation of a Google Sheet from a template
- Populates the second tab with line-item data via Make (iterator + aggregator, working fine)
- I then need to push that data into the `first tab, starting at cell B27
- The number of items varies (1 to 10), so the row count must be dynamic
What I need:
- A clean way for Make to populate the first tab starting at B27, dynamically adding rows (or unhiding them if this way is easier, but it seems that I need to start diving deep into app script if I do it this way), based on how many items come through
- All of this must happen on the copied sheets from the template, not the original template - I have dipped my toes into the Ap Script to try and fix this, but the App Script doesn’t like making the same changes to a copied sheet.
What I’ve tried:
- ARRAYFORMULA – clean but doesn’t unhide rows or add space for PDF export
- Update Row, Add Row, Update Cell, Bulk Add & Update Rows modules in Make – none allow row-level targeting starting at B27 - it forever adds the data into row 1 or 2
- Google Apps Script injection – blocked by OAuth and token issues
- Hiding rows below B27 in the template – but Make doesn’t unhide them when populating
- Can’t use empty pre-exposed rows because the document gets exported to PDF and must look clean
Happy to share screenshots or links — just desperate to get this solved. Any help would be amazing as I have been stuck on this for days now.