i want to use

tap-google-sheets

to extract data from multiple google sheets (with different sheet IDs). How do I configure meltano for this?

You should be able to use the

sheets

setting: • https://hub.meltano.com/extractors/tap-google-sheets/#sheets-setting • https://github.com/Matatika/tap-google-sheets/blob/master/README.md#per-sheet-config

If i use

meltano config tap-google-sheets set sheets

that will run all the sheets when running the command

meltano run tap-google-sheets target-jsonl

? What if I wanted to run the sheets at different times? Can a sheetid be passed to the run command?

> If i use `meltano config tap-google-sheets set sheet`s that will run all the sheets when running the command

meltano run tap-google-sheets target-jsonl

? > Correct. So if your use-case is specifying the sheet ID at runtime then the approach you linked works. > Can a sheetid be passed to the run command? > You can do

TAP_GOOGLE_SHEETS_SHEET_ID=123 meltano run tap-google-sheets target-jsonl

if you don't want multiple inheriting plugin definitions just for the sake of overriding

sheet_id

.