I need a Google Apps Script that does the following.
From any number of external spreadsheets. It will go out and grab cells from various spreadsheets (around 10) and then post them into a single line in another spreadsheet. This should happen every hour on the hour. The timing part I know is a part of app script so this need not coded.
What I'm looking for is the script so I can copy and paste it into my script editor. However is should be laid out in such a way that I can see how it works with 10 source spreadsheets.