Skip to main content
Best answer

Copy in value a worksheet into another Google Sheets

  • May 20, 2022
  • 2 replies
  • 631 views

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

 

Best answer by Satya09

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.

 

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

Satya09
Forum|alt.badge.img+7
  • Beginner
  • Answer
  • May 20, 2022

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.

 


jesse
Forum|alt.badge.img+9
  • Architect
  • May 24, 2022

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!