Google Spreadsheets

To get started with Google Spreadsheets, make sure you either sign up with a Google account or add a google authentication to your ContentSync account.

You must have at lease one Google authentication enabled on your account to use Google Spreadsheets.

Performance

Google Spreadsheets is our preferred Spreadsheet. It consistently works and is performance. However, keep in mind that the more tabs on your Google Spreadsheet, the longer a sync will take.

Sheet Tabs Naming Options

These options allow finer grained control of which sheet tabs are synced and when they are synced.

Some notes:

  • All options are case insensitive

  • Options can be combined and used multiple times

  • Each option must have a space before it

  • An option can appear anywhere in the sheet tab name

Disable Sheet Tab

To always ignore a tab from syncing, include "--noCS" in the tab name.

Examples

A sheet tab with the name ComponentContents will sync.

ComponentContents --noCS or --noCS ComponentContents will not sync.

Enable Sheet Tabs for Specific Content Versions

You can set a sheet tab to sync only for specific content versions using "--CSVersion=<version>". You can include this option multiple times and with other options.

Examples

ComponentContents --CSVersion=english will only sync on content version "english".

ComponentContents --CSVersion=v1 --CSVersion=v3 will only sync on content version "v1" and "v3" and will not sync on version v2 or any others.

Disable Sheet Tabs For Specific Content Versions

You can also set a tab to be ignored for a specific content version using "--notCSVersion=<version>". You can include this option multiple times.

Examples

ComponentContents --notCSVersion=english will sync on call content versions except for version "english".

ComponentContents --notCSVersion=v1 --notCSVersion=v3 will not sync its contents one content version v1 or v3 but will sync on content version v2 and others.

Last updated