I want to copy all rows from a google spreadsheet and then I want to append those rows in another google spreadsheet, how can do this?
Trying using Copy Paste Range but getting error:
@Mamata_Shee , Try this
Read range of input sheet and write range of output sheet name
follow above link it might usefull
Hello, @Mamata_Shee - I believe Copy Paste Range can copy the rows of max 1000 and max columns 26. Try copying the chunks of data and see how it goes
Its May be limit set by google.
Try to download it in your machine loaction, then read it. then copy paste as per your requirement, finally upload the google sheets in your drive.
After upload successfully you can delete the loacal folder file using delete activity