How it works

1. A schedule starts the template every hour. 2. Google Sheets reads the range you choose from the source spreadsheet (for example Data!A:G). 3. The values are written into the same range of the first destination spreadsheet. 4. The same values are written into the second destination spreadsheet.