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

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.

Hi @Lars,

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

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.

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