Visit to open the script editor. (You'll need to be signed in to your Google account.) If this is the first time you've been to, you'll be redirected to a page that introduces Apps Script. Click Start Scripting to proceed to the script editor. A welcome screen will ask what kind of script you want to create. Apr 18, 2019 · If you use Google Apps, then chances are you’re not using them to their full extent. With Google Apps Script, you can add custom menus and dialogs, write custom functions and macros, and build add-ons to extend Google Docs, Sheets, and Slides.

This Script will copy the range specified by getRange() to the end of your destination Sheet [getRange(getLastRow())]. To learn more, please visit the Google Apps Script online documentation for Developers. Hope this helps! Please let me know if I can assist you further with this!