How to preserve header rows - Create a spreadsheet from template ->Add a Row

[Kathryn_Jones]

I am building a scenario where a webhook receives data from an online form, creates a spreadsheet from a template and then adds the data from the form to the new spreadsheet via the add a row module.

my new spreadsheet has a header row. But when i manually map the new spreadsheet’s ID# to the Add a Row module, I don’t have the “Table contains headers” option.

As i look at the Create A Spreadsheets from Template output i can kind of understand why - the header rows are not part of the output (although they do populate on the google sheet)

What do i need to do/add to make the Add a Row module recognize that the spreadsheet has headers?

[samliew]

Welcome to the Make community!

The “Table contains headers” option is only used to get the column values to assist you in mapping the values.

Without it, you still can map the values into the respective fields in the right order, just without table header names — but this form is exactly the same with or without!

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.

[Kathryn_Jones]

i think that might totally help! thank you! will try!