Insert variable amount of rows into middle rows of Google Sheet

I have an app that needs to fill out the attached form. I can pass the data into Make to fill out the information, no problem. My challenge is how to insert data into rows 25-38, keeping the headers and footers unchanged and also how add a page (with the headers and footers) when the data requires another page. Any ideas on how to produce this form unchanged except for the detail data starting in row 25? Thanks!

May peace be upon you @Kathy_Higgins

You can use " Update a Row " module to update/add data to specific rows but then you may need to some how dynamically define the row number according to the use case if it’s not static.

P.N. I think you can generate this report/form submission in a less complex way by either using a Doc Template in Google Docs or using form builders such as Jotform or Platoforms.

2 Likes

Thanks so much for the suggestions. I will look into Update a Row as well as Jotform or Platoforms. I’ve not used either but they might be a better fit.

1 Like

@Kathy_Higgins Great, let us know if it worked for your.

If you need further assistance, feel free to contact

1 Like