How to update specific columns in google sheet?

Greetings everyone.

I have a workflow that at the end it outputs the result to an existing google sheet.

That google sheet has 10 columns. My workflow output has only 8.

Every time I run the workflow it updates the values on the first 8 columns but it also removes the last 2 columns, which are comments, and should stay there.

I know that for excel you can specify the columns you want to be updated but I couldn't see that option for google sheets.

Does anyone have any ideas.

Accepted answers

grazitti_sapna

@soncoku ,there are only 2 options that will work on the sheet that is either append or overwrite. In case you will try the append option it will give you another row with the updated values which I guess you do not want. The only option is overwriting the file.

1) For example I have a sheet with already existing data as follows,

2) Now I want to Change the values in column A4 with Record ID 3 replacing FGVD with 1234 and ### with Test2 having new input as follows,

3)Then you need to Create 2 workflows one for updating the values then store the output into an excel sheet and the other one to overwrite the google sheet.

Workflow 1

Workflow 2

4) Final Output

This is what I tried and I hope this helps you.

All comments

grazitti_sapna

Hi @soncoku , I guess you can simply create two columns using a formula tool as the same name you have in the google sheet and implement it in your workflow keeping the values of those 2 columns as null making the number of columns to be 10 unless those comment columns that you specified in the google sheet are empty or null?

Does this solves the problem?

PS: Also when you are updating the sheet what option are you using from the Choose Write Option because this scenario usually occurs when you are overwriting the existing sheet?

soncoku

Some of the fields of the 2 columns (Comment1 and Comment2 ) are empty.

I'm using Overwrite Sheet.

Should I be using another one?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335