Declare column types when you want to tell Sheetgo how to read your source data instead of relying on auto-detection. For example, if Sheetgo reads a date column as a number, the destination may receive a serial number such as 46027 rather than a date.
You only need to declare the columns you care about. Columns left on Auto-detect keep their existing behavior. If a value doesn't match the declared type, Sheetgo leaves it as-is. Nothing is dropped.
Declare a column type
In the automation builder, go to the Source step.
Find TABLE SCHEMA and turn on Configure column types.
Find the column you want to configure. The table lists every column with its spreadsheet letter under Column, Type, and Format. Use Filter columns... to search.
Open the column's Type dropdown and select a type.
The available types are:
Auto-detect: Let Sheetgo detect the type.
Text: Any text value.
Boolean: True / false.
Integer: Whole numbers.
Float: Approximate decimals.
Decimal: Exact decimals and currency.
Date: Calendar dates.
Date & time: Date and time together.
Time: Time of day.
For a column containing calendar dates that Sheetgo reads as numbers, select Date.
The running count, such as "0 of 10 columns declared", tracks how many columns have a declared type. Turn on Show declared only to view those columns.
Set a format and locale
Once you declare a number, date, or time type, the Format cell offers Set format. Text and Boolean have no format options, so their Format cells stay empty.
Select Set format for the column.
In the panel titled "Format - " followed by the column letter, choose an option under PRESETS. Choose Custom if you need a different pattern.
Check the PREVIEW line.
Choose a LOCALE, or leave it on Inherit (workflow default).
Select Done.
The Format syntax link in the panel provides a reference for format patterns.
Number format presets
Number formats include these presets:
Default (no formatting).
1,235, with the pattern#,##0.$1,235, with the pattern"$"#,##0.1235, with the pattern0.Custom.
Date and time format presets
Date and time formats include these presets:
Default (no formatting).
2024-03-09 15:30:45, with the patternyyyy-mm-dd hh:mm:ss.09/03/2024 15:30, with the patterndd/mm/yyyy hh:mm.03/09/2024 15:30:45, with the patternmm/dd/yyyy hh:mm:ss.Custom.
How locale settings apply
LOCALE defaults to Inherit (workflow default). Available locales include en_US, en_GB, pt_BR, es_ES, fr_FR, de_DE, and it_IT.
A locale token inside a format pattern overrides the column's locale setting. For example, a pattern containing [$R$-pt_BR] uses pt_BR rather than the locale selected for that column.
Return a column to auto-detection
Select Auto-detect in the column's Type dropdown to let Sheetgo detect its type again. That column behaves exactly as it did before you declared a type.