Shorthand way to copy range of cells in a Google sheet row to other worksheet?

[Lars]

I'm creating some workflows to copy data between worksheets in a Google sheet. The range option is great for defining where the data should go, and I'm wondering if there's a simple way to say "COPY A2:Z2 FROM SOURCE SHEET TO TARGET SHEET"?

Thanks,
Lars.

 

[ArshilAhmad]

Hi @Lars,

You can try using 'Copy Sheet Data' action step to achieve your use case.

 

[Lars]

Thanks - but ny the looks of it, this action only copies whole rows or columns, not so? What I need to do is copy a range of cells, i e A4:AE4, from a source sheet to a corresponding range in a target sheet.

Hi @Lars,

You can try using 'Copy Sheet Data' action step to achieve your use case.
View attachment 40070

 

[ArshilAhmad]

In that case, you have to use the 'Update Range Values' action step. That is the easiest method for updating a range.