Google Spreadsheet CLI Guide
Step 1 : Download an existing configuration
To get a template for the Google Spreadsheet connector configuration save the output of the describe --input-parameters
command as follows:
Step 2 : Update the parameters file
Modify the parameters (googlesheets.json) file with the below mandatory fields.
Example template for downloaded parameters file
- Sign into your google account and go to Google console for developers
- Click on create credentials > OAuth Client ID
- Under Application type choose 'web application'
- Add the below URI under Authorized redirect URIs and click create
- OAuth client gets created with Client ID and Client Secret. Please save these credentials on clipboard.
- Go to Google developers site and follow the steps here to create access token and refresh token
Step 3 : Add the connector
<connector-name>
Name of your connector. A schema with this name is automatically created in your warehouse<params-file>
File path to your input parameters file. Ex. googlesheets.jsonPlease make sure that the
<params-file>
adheres to the format shown in Step-2
Got a question? Interested?
Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.