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.

Google BigQuery is a fast, scalable, and easy-to-use data warehouse. Main advantages of Google BiqQuery are:

• Serverless architecture.
• Pay-as-you go

Jitsu can stream and batch data to Google BigQuery. Streaming will get data to BQ immediately, however Google charges for each streamed record, while batching is free. Streaming is the fastest way to get started, but batching will be cheaper for large volumes.