Google Sheets


Google Sheets


Google Sheets

Google Sheets

Beta version

The configuration and connection might need a bit of fine-tuning to get things running smoothly. Let us know if you hit any snags at team@tably.com.

Once created, a connection can be reused or copy-pasted in all other pages within same workspace without additional setup. The setup can be complex and, if in doubt, ask your developer for help. They will have all needed details and will be able to assist with possible errors.

Add account
Enter the link to the Google spreadsheet you want to sync. To copy the link, click the 'Share' button in the top-right corner of the spreadsheet, then click 'Copy link'.
Default value is 1000000. An integer representing row batch size for each sent request to Google Sheets API. Row batch size means how many rows are processed from the google sheet, for example default value 1000000 would process rows 2-1000002, then 1000003-2000003 and so on. Based on Google Sheets API limits documentation, it is possible to send up to 300 requests per minute, but each individual request has to be processed under 180 seconds, otherwise the request returns a timeout error. In regards to this information, consider network speed and number of columns of the google sheet when deciding a batch_size value.
Removes leading and trailing underscores from column names. Does not remove leading underscores from column names that start with a number. Example: "50th Percentile? "→ "_50_th_percentile" This option will only work if "Convert Column Names to SQL-Compliant Format (names_conversion)" is enabled.
Combines adjacent numbers and words. Example: "50th Percentile?" → "_50th_percentile_" This option will only work if "Convert Column Names to SQL-Compliant Format (names_conversion)" is enabled.
Removes all special characters from column names. Example: "Example ID*" → "example_id" This option will only work if "Convert Column Names to SQL-Compliant Format (names_conversion)" is enabled.
Combines adjacent letters and numbers. Example: "Q3 2023" → "q3_2023" This option will only work if "Convert Column Names to SQL-Compliant Format (names_conversion)" is enabled.
Allows column names to start with numbers. Example: "50th Percentile" → "50_th_percentile" This option will only work if "Convert Column Names to SQL-Compliant Format (names_conversion)" is enabled.
When enabled, the connector will continue reading columns after empty header cells and will include data from those columns using generated column names (e.g., "column_C"). By default, the connector stops reading columns when it encounters an empty header cell.
Number of concurrent threads for syncing. Higher values can speed up syncs for spreadsheets with multiple sheets, but may hit rate limits. Google Sheets API limits to 300 read requests per minute (~5 req/sec).
Overridden streams will default to Sync Mode: Full Refresh (Append), which does not support primary keys. If you want to use primary keys and deduplication, update the sync mode to "Full Refresh | Overwrite + Deduped" in your connection settings. Allows you to rename streams (Google Sheet tab names) as they appear in Tably. Each item should be an object with a source\_stream\_name (the exact name of the sheet/tab in your spreadsheet) and a custom\_stream\_name (the name you want it to appear as in Tably and the destination). If a source\_stream\_name is not found in your spreadsheet, it will be ignored and the default name will be used. This feature only affects stream (sheet/tab) names, not field/column names. If you want to rename fields or column names, you can do so using the Tably Mappings feature after your connection is created. See the Tably documentation for more details on how to use Mappings. Examples: - To rename a sheet called "Sheet1" to "sales_data", and "2024 Q1" to "q1_2024": [ { "source_stream_name": "Sheet1", "custom_stream_name": "sales_data" }, { "source_stream_name": "2024 Q1", "custom_stream_name": "q1_2024" } ] - If you do not wish to rename any streams, leave this blank.
Not run yet
Loading…