The Smartsheet Source is written to pull data from a single Smartsheet spreadsheet. Unlike Google Sheets, Smartsheets only allows one sheet per Smartsheet - so a given connector instance can sync only one sheet at a time. To replicate multiple spreadsheets, you can create multiple instances of the Smartsheet Source, reusing the API token for all your sheets that you need to sync.

RedShift is a fast and scalable data warehouse provided by AWS. Jitsu can send data to RedShift in both stream, and batch mode. For batch mode you'll need to provide access to S3 bucket where Jitsu will store temporary data batches.