CS Tools Google Sheets Syncer Error

[leonliflipp]

Hi,

I was trying to use the Google Sheets syncer on CS tools but I'm running into an issue.
The command I'm running is: cs_tools tools searchable bi-server --syncer gsheets:///$HOME/Documents/TS_CS_Tools/google-sheets-definition.toml --compact.

My definition.toml file is:
[configuration]
spreadsheet = 'test'
mode = 'overwrite'
credentials_file = '/Users/leonli/Documents/TS_CS_Tools/google-sheets-creds.json'

This is a screenshot of the error.

And this is the log report:
2024-03-12T10_35_29.log

Thanks!

[leonliflipp]

I also have some additional questions:

1. Since we are specifying one google sheet in the definition file, what's the expected behaviour when searchable gather is ran? Does it dump all the metadata into one google sheet?
2. Does the google sheet just have to live somewhere on my drive or e.g. can it be in a folder?

Thanks again!

[boonhapus]

1. The gsheet is the file itself in your Google Drive. It'll dump metadata into separate tabs in the sheet. Google confusingly calls these both "spreadsheets". 🫠
2. I believe it can live anywhere. I believe the scoping happens based on sharing the file to your service account user. I am not sure how Google behaves if you've shared 2 google sheets with the same name.

[boonhapus]

Hey @leonliflipp , can you switch the order of mode and credentials_file ? This should be fixed in 1.5.0 .

[configuration]
spreadsheet = 'ThoughtSpot Data Sink'
credentials_file = 'C:\Users\boonhapus\Downloads\syncers\cs-tools-user-sync-02cf6ee39e60.json'
mode = 'overwrite'

[boonhapus]

Hmmmm okay, try one last thing @leonliflipp ... remove mode altogether (its default is to overwrite).

[leonliflipp]

@boonhapus Still doesn't work 😔 (giving same error)

[boonhapus]

Gotcha. I confirmed this does work in the upcoming new version, to be released in the next couple of weeks. Do you need this functionality now? Or can you wait until the new version is released?

[leonliflipp]

I can wait until the new version is released. Does next couple of weeks mean around the end of the month? Also when it is released, can you let me know? Thank you again for looking into this, much appreciated!!

[boonhapus]

Yep! Exactly. My goal is before April to finish documentation and release it. Will set a reminder to poke you in Slack as well. Thanks @leonliflipp !