How to sync data between two google sheets using m...
# getting-startedf
Feroze Ahmad
06/05/2024, 9:43 AMHow to sync data between two google sheets using meltano?
r
Reuben (Matatika)
06/05/2024, 4:33 PM Copy code
meltano add extractor tap-google-sheets
meltano add loader target-gsheet
meltano run tap-google-sheets target-gsheetReuben (Matatika)
06/05/2024, 4:35 PMWe test the tap everyday. Your mileage may vary with that target (hasn't been updated in a while and doesn't seem to have settings for auth).
f
Feroze Ahmad
07/01/2024, 10:51 AMI tried this and configured the tap-google-sheets settings. But when i run test command (
meltano config tap-google-sheets test Copy code
Plugin configuration is invalid
Catalog discovery failed: command ['D:\\meltano\\my-meltano-project\\.meltano\\extractors\\tap-google-sheets\\venv\\Scripts\\tap-google-sheets.exe', '--config', 'D:\\meltano\\my-meltano-project\\.meltano\\run\\tap-google-sheets\\tap.9e6a92ce-6a9a-4950-8f0b-8c16282b1c31.config.json', '--discover'] returned 1 with stderr:
2024-07-01 15:48:43,254 | INFO | tap-google-sheets.config | OAuth authorization attempt was successful.
2024-07-01 15:48:43,756 | INFO | singer_sdk.metrics | METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.496374, "tags": {"stream": "config", "endpoint": "<https://www.googleapis.com/drive/v2/files/1PCVwpJVnXkK5RiqW6qT6HPI1jw1_13UTfNhXT5Htsro>", "http_status_code": 403, "status": "failed"}}
Traceback (most recent call last):
File "<frozen runpy>", line 198, in _run_module_as_main
File "<frozen runpy>", line 88, in _run_code
File "D:\meltano\my-meltano-project\.meltano\extractors\tap-google-sheets\venv\Scripts\tap-google-sheets.exe\__main__.py", line 7, in <module>
File "D:\meltano\my-meltano-project\.meltano\extractors\tap-google-sheets\venv\Lib\site-packages\click\core.py", line 1137, in __call__
return self.main(*args, **kwargs)Feroze Ahmad
07/01/2024, 10:52 AMIs there any help on how to setup googole oauth configurations?
r
Reuben (Matatika)
07/01/2024, 11:32 AM3 Views