Best answer

Copy in value a worksheet into another Google Sheets


Hi everybody, 

Do you know if the following process is feasable : 

  • copy in value a worksheet into another GS as soon as a there is a new spreadsheet row in a GS ? 
  • or copy the global GS when a new spreadsheet is create ? 
     

Thanks for your help

 

Anna

 

icon

Best answer by Satya09 20 May 2022, 17:07

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

Hey @AKU! Just checkin in here to see if Sataya’s suggestions helped you create the workflow you were asking about. Let us know either way - we want to make sure you’re good to go here!

Userlevel 4
Badge +6

Hello @AKU 

1.You can copy the values in a row from google sheet to another sheet using zapier.Just create a Trigger with connecting your first sheet and test the data from that sheet.

Later use an action step of create spreadsheet row and map the fields from the Test Trigger Output of First Sheet into the columns of second Google Sheet.

2.This is also possible to create a New Spreadsheet from an existing Spread Sheet whenever a new row is added in the first sheet by duplicating that in your gdrive.