The Operattion "Add a Row" adds new rows on Top of locked Rows, instead of Bottom on Google Sheets

Hi guys, I am building a simple CRM on Google Sheets and I have a problem with the “Add a Row” Operation.

I have locked the first row containing all my headers, but when the automation runs, the new row is added to the top of the headers, instead of at bottom, and the rows get locked together.

This is what I’m getting.

The Table contains headers option is set to Yes and all parameters are pretty well set.

I know that there are similar questions in the community, but their answers can’t work for my case.

Can anyone help me, please?

This is actually a very common mistake.

Simply put something in cell A1 so that Make doesn’t think that row is empty.

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

2 Likes

Thank you so much man.

2 Likes

No problem, glad I could help!

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

4. Do join the unofficial Make Discord server for live chat and video assistance

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like