How do I pull All data in one Google Sheet to another Google Sheet Tab using Google App Script?

57
February 13, 2020, at 01:40 AM

My manager and I are stuck!

What we are trying to do is pull all of the data from one google sheet to the first tab on another google sheet using google App Script. They are located in 2 separate folders as well.

We don't want to use =importrange() basic because it doesn't actively update the sheet! We are trying to automate our systems!

we tried using this and it was a no go.

function CopyRange() { var sss = SpreadsheetApp.openById('1vuqVDFLYc0pee0qITCQoL6ZXAOlzVl5Efg88F8mA39I'); //replace with source ID var ss = sss.getSheetByName('Bob Swope - Flow'); //replace with source Sheet tab name var range = ss.getRange('A2:AL1000'); //assign the range you want to copy var data = range.getValues(); var tss = SpreadsheetApp.openById('17SZH2yKWuD1fonf-hOV1bpUumuOf5S24NI_V2Q0ITWo'); //replace with destination ID var ts = tss.getSheetByName('input'); //replace with destination Sheet tab name

}

READ ALSO
Pass parameter to javascript function in Go template

Pass parameter to javascript function in Go template

I have the following in my Go's template

65
Load More data jumps up after loading data AngluarJS with fireFox

Load More data jumps up after loading data AngluarJS with fireFox

When I load dynamic data into my page using AngularJS, the page jumps to the top (The containing element) if I use EnablePromise functionThis happens with Firefox but not with Chrome

40
My Angular App works locally, but it gets an error on Heroku. Source Map URL: index.js.map

My Angular App works locally, but it gets an error on Heroku. Source Map URL: index.js.map

I can pull data from the JSON locally (when using ng serve) and modify the DOM with it, but not on Heroku

62
Can this script be used to create multiple SVG elements?

Can this script be used to create multiple SVG elements?

I have the following JavaScript that creates a graph using snap SVG

76