Meltano

image.png

Hi <@U06CASRQ0H0>
When I am trying to set the google sheet value (name) facing issue
 meltano config tap-google-sheets set sheets '[{"stock-wpp"}]'
Is this correct way of setting?

Can you share what your `meltano.yml`  looks like for google sheets?

The tap expects a list of objects with these keys: <https://github.com/Matatika/tap-google-sheets?tab=readme-ov-file#per-sheet-config>

Do you want to ingest just a single sheet, or more than one?

oauth client id, secret, refresh token are stored in .env

Try the below?:

```
plugins:
extractors:
- name: tap-google-sheets
variant: matatika
pip_url: git+<https://github.com/Matatika/tap-google-sheets.git>
config:
  sheets:
     - output_name: stock_analysis
       sheet_id: $YOURSHEETIDGOESHERE```


You can find the sheet ID following instructions here: <https://github.com/Matatika/tap-google-sheets?tab=readme-ov-file#per-sheet-config>