Formatting Google Sheets Columns

Google Sheets has two data types: Strings and Numbers.

Strings

Text, Long-text, Drop-down, Multiple Select, and Email are strings, which enables 2-way syncs by default. No additional formatting is needed.

Numbers

Numbers, Percentages, and Dates should be formatted as such in Google Sheets in to enable a 2-way sync with similar data types in other connectors. You can do so easily as shown below: Highlight a column -> Click Format → Click Number → Choose data type

If you want to sync a currency to Google Sheets in a 2-way sync, set the format as “Number”. Due to Google Sheets’ constraints, if you format a column as “Currency”, it will be a 1-way sync into Google Sheets. You can 2-way sync a Google Sheets "Number" with either a "Number" or a "Currency" on another connector.

You can learn how to use Foreign Keys in Google Sheets here:

Foreign Keys in Google Sheets