Automate data collection in Google Sheets using the Sheet ID

[@flyerplanet]

Your tutorials are great and very helpful. Thank you I have gone crazy many nights with your tutorials that work perfectly on the first try when I write them but no longer work when I reopen "Drive" and reload them to continue learning. After rewriting them many times I finally understood that the source "example data file" needs to be opened at the same time as the destination file. Is it possible to take data from the source file that is on the network or on the PC but not yet open on the desktop?

[@mattbrigidi]

i’m glad you’ve found the videos helpful but i’m sorry to hear that you’ve also had challenges. you shouldn’t have to have the files open unless you’re referencing them using the “SpreadsheetApp.getActiveSpreadsheet()” method. if you’re using that logic and only have the script file open then i could see the issues arising. please feel free to email me with some sample code and i’ll gladly take a look

[@igalbendavid4614]

Thank you for this great tutorial. How do you pull specific rows and columns instead of the entire sheet automation?

[@mattbrigidi]

you can change the function by modifying the .getRow() method .getRow has four inputs: 1. start row 2. start column 3. end row 4. end column so if you only want data from A1:B2 then you would enter: .getRow(1, 1, 2, 2)

[@jonadolfcaballero3495]

Hi @Matt Brigidi is it possible to automate data to display by browsing/selecting google sheet file from the google drive, and display it to another google sheet?

[@mattbrigidi]

hi - i’m not sure i understand. what would you like to do?

[@EliPatinoAve]

Thank you! this is excellent! the trigger should be for the 'dataCollector' function and not the 'opener' function, yes?

[@mattbrigidi]

i believe that's correct! (apologies - it's been some time since I recorded this video)

[@leidysunday5990]

Can you please explain what happens if I change the source data? For example, bank statements.

[@mattbrigidi]

I'd be happy to explain more - can you elaborate more on what your question is? are you asking if the code can be used with any data source and dynamically react to it?

[@leidysunday5990]

@@mattbrigidi what I meant is if I create the code to extract data from a bank statement from January to March, then I want to be able to replace the data using the same sheet. For example, replace to bank statement April to June.

[@lafamillecarrington]

I always wondered how a Google Form knew which Sheet to use when you can alter the Sheet name. Is it something similar that allows you to change the headings in row1 as well as the column order?

[@mattbrigidi]

Yes I believe so - when you reference IDs instead of values then you establish a dynamic environment

[@jijeeshpadmanabhan350]

Really helpful

[@mattbrigidi]

I'm so glad to hear that - thank you for reaching out