Google sheets append in same row

Describe the issue/error/question

i have a google sheet im updating with append, and the new data is being added to the right one row below, is there a way to make it add to the next column on the same row?

What is the error message (if any)?

Please share the workflow

figured it out, just needed to match column values


## Share the output returned by the last node
<!-- If you need help with transforming the data, please also share the expected output -->

## Information on your n8n setup
- **n8n version:**0.219.1
- **Database you're using  SQLite):**
- **Running n8n with the execution process [own(default), main]:** not sure 
- **Running n8n via ]:**docker

Hey @adielas,

Welcome to the community :raised_hands:

Can you share the full workflow and complete the template so we can see what n8n version you are running and how it is setup.

Hi @adielas, welcome to the community. To my knowledge the Google Sheets node always adds it’s data below your last content in the sheet when using append.

There might be two ways to fix that:

  1. Use the Append and Update mode and make sure that you’re working with a unique key you could use
  2. Separate the data into two different sheets. One that contains data that you read and one that contains data that you write.

As Jon mentioned it would be nice to know a little more about your use case to provide even better help. Hope that helps :slight_smile: