Google Apps Script For Sheets - How to Copy, Clean and Insert Data in Sheets

Sdílet
Vložit
  • čas přidán 14. 07. 2024
  • In this Google Apps Script for Sheets Tutorial for beginners. We explore how to get data from sheets and how to copy data to new sheets.
    There are three Google Apps Script Functions covered which cover three methods of copying and setting data.
    1. How to copy data from a sheet to a sheet within the same spreadsheet.
    2. How to copy a selection of data from a spreadsheet and insert in to a new sheet.
    3. How to select a sheet by id and copy its data in to your sheet.
    The Code used in the video is avaliable here: github.com/analyticswithadam/...
    Any questions feel free to ask below.
  • Jak na to + styl

Komentáře • 2

  • @98cactus
    @98cactus Před 4 dny

    great video! can you dive a little deeper into how can we can create a script that copies only the last row from a given sheet (general sheet) and then filter it for it to land into an specific sheet depending on a specific value and date? is that even posible?