title: Spreadsheet to automatically scan other sheets in a folder and import data from a specific range
body: <p>I'm looking for a script that I can use in a google sheets spreadsheet to have it scan through a folder containing multiple spreadsheets (1 added each week) and retrieve data from a specified range of cells into a new row from each spreadsheet, but only once per sheet in the folder.</p>
  
  <p>I found this answer:  <a href="https://stackoverflow.com/questions/56144667/google-sheets-import-folder-range-into-master-sheet">Google Sheets: Import folder range into Master Sheet</a></p>
  
  <p>Can it be modified into the script checking the already existing values not individually but rather as a range? Because some values are inevitably gonna be the same, but it is highly unlikely that the entire row would be the same.</p>