Not adding new data into same raw where some data exist in Google Sheet?

Questions
1

For example, there are three columns (name, age, country), so here the country column is filled with a default, and I want to add the name and age from n8n forms when anyone submits. So, let’s say someone filled in the name and age in the form, it’s starting from “at the end” of the row where the country default listed is ended(for example, in 50 number its ended and the data starts from 51). But I want it should normally start from the beginning!

I tried all the options in Google Sheets(append,update raw)

Please tell me the solution

2

Please include a workflow or test case to replicate the issue. Without this, it is challenging to diagnose the problem.

3

So, I didn’t find any solution for that! Could you please help me with how to do that?

Simply, when execute the workflow from n8n form data to google sheet, the information should start from first raw.

For example,

Column 1 Column 2 Column 3 Column 4
Name Age Country
US
US
US
James 30
Henry 20

So, it’s just a basic example of my problem in n8n. So, here the workflaw should start from the first raw (here name and age) but it’s sharting from the end where the existing raw ended.

I hope you understand my concern and please give me a solution.

4

why did you fill your sheet with data? remove all data in country column and send it from your workflow

5

add a google sheet node and set its operation to Append row and use expressions for name and age columns but for country set it to US (literal text)

6

thanks for your clarification. If its fixed (ex: US) then its work perfect using workflow. But what if the “Countries” are different given in a sheet! then how to used fixed (literal text)? or maybe in future the google sheet have some information which I can’t change, instead I have to just add information (in a order ex, raw 1,2,3,….) via workflow?

I hope you now understand my concern.

7

@Sahedul_Islam_Ovi

you should not do that. you should have only one source of truth, all data within your sheet should come from a single source that is your workflow. in your workflow you decide that in a particular sheet, what should be the country value.

if you want to add some data to your sheet beside workflow, you should create another sheet and reference data from first sheet

but you can also set a default value for your column in sheet, so it is always fill with particular value, for example add the below formula in the header row instead of “country”

=ARRAYFORMULA(IF(ROW(B:B)=1, "country", IF(not(ISBLANK(A:A)), "us", A:A)))
8

So, in simple words, if any cell exist something in a raw, the workflow started from the new raw right? So, is it better to keep the raw clean and only fill up to the raw via workflow? Actually, as I don’t have such technical expertise and also no coding background(as you gave a formula). I want to know what’s the easy solution for it?

I mean, If any cell exists something in a row, the workflow started from the new row right?
So, is it better to keep the row clean and only fill up to the row via workflow?

9

Yes. create an empty sheet for your workflow and fill it only through your workflow

if you put data in a row and append data to sheet, a new row will be added at the end of the sheet

The formula that i posted in my previous post is google sheet formula. you should paste it in a column in the sheet. with that formula, your country cell will be filled automatically and sheet don’t count any row in the sheet as filled

1 Like
10

Thanks so much for your help Ramin

1 Like
11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.