Google Sheet Script to Copy one row from one sheet to another sheet

Here is a simple project for those who master javascript and google spreadsheet! We are looking for someone with skills in google sheet for different script we are building for our project so if you are good on this one we will have plenty of contracts for you!

So here is the challenge. We use a script below to erease the old row in the "archive" sheet but we want to copy thoses same row on a new sheet that we name "target" ant that it add the row at the end of the target spreadsheet

So we want a version of the script below that allow to copy a row form googlesheet1 (Archive) to googlesheet2 (target)

here is the script:

function myFunction() {

var ss = [url removed, login to view]();

var sheet = [url removed, login to view]("Archive");

var datarange = [url removed, login to view]();

var lastrow = [url removed, login to view]();

var values = [url removed, login to view]();// get all data in a 2D array

var currentDate = new Date();

var oneweekago = new Date();

[url removed, login to view]([url removed, login to view]() - 2);

for (i=lastrow;i>=2;i--) {

var tempdate = values[i-1][1];// arrays are 0 indexed so row1 = values[0] and col2 = [1]

if(tempdate < oneweekago)


[url removed, login to view](i);




Skills: Excel, Javascript

See more: google sheets copy row to another sheet based on cell value, google script copy data from one sheet to another, google spreadsheet script copy paste values, google script copy row, target range and source range must be on the same spreadsheet, google script copyto, google script copy range to another spreadsheet, google spreadsheet copy row to another sheet, Google Sheet Script, copy format sheet script task, google sheet script print, script task copy excel sheet, excel script copy sheet, script copy excel sheet, function copy picture sheet anather sheet vba excel, copy columns sheet, simple visual basic script copy contents cell, vba script read column sheet, vba excel copy content sheet, copy spread sheet

About the Employer:
( 62 reviews ) Quebec, Canada

Project ID: #15880385

Awarded to:


Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$30 USD in 1 day
(174 Reviews)

8 freelancers are bidding on average $43 for this job


Greeting, I have understood your Google Sheet Script to Copy one row from one sheet to another sheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years o More

$30 USD in 1 day
(217 Reviews)

Hi I can solve the issue that you mentioned. Please accept the bid and create the milestone.

$30 USD in 1 day
(96 Reviews)

Hi there, I will be happy to help you with that. I have checked your attached script. RIght now, you are trying to delete the rows that have a timestamp older than 2 days "from the script runtime moment" from the "A More

$30 USD in 0 days
(22 Reviews)

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Thank you fo More

$19 USD in 4 days
(23 Reviews)

I can solve it. But can you please tell me about the next task. I will do the other task too for the current price. let us discuss. added 3rd party api to googlesheets [login to view URL] More

$166 USD in 3 days
(4 Reviews)

Hello, Message me so that I can understand​ your requirements in detail. Thanks

$15 USD in 1 day
(10 Reviews)

I have worked on many google sheet script and used below features of sheet. 1) Email Sending 2) Calendar Integration 3) MYSQL Database Connection. 4) Automation 5) Manipulating Various Google Sheet based on Busi More

$25 USD in 1 day
(1 Review)