How to display new google sheets row at top?

Questions
1

Hi , i’m new here, the question is, when i execute new data with n8n in the Google Sheets, how do I set it up so that new data is always shown at the top?

Currently, new data is always shown at the bottom of the sheets.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
1 Like
2

Hi @Maxine

n8n’s native Google Sheets node doesn’t actually have an “insert at top” feature. it only appends to the very bottom of your data.

a quick workaround right inside google sheets:

just let n8n keep appending new rows to the bottom of your main sheet (like “Sheet1”). then create a second tab in that same document. in cell A1 of the new tab, drop a sort formula like =SORT(Sheet1!A:Z, 1, FALSE).
that formula automatically pulls everything from your first sheet and flips it upside down.

Hope this will help you!

3

Hi @Maxine Welcome to the community!
although traditionally you can only insert in the bottom part of the rows, the usual workaround is just to read all the rows with return all, and prepare your new row in a set node or code node and the write the whole range back with the update operation , this would be effective although this might require more computation but this is a scalable and permanent fix.