When Sheetgo transfers data from a source to a destination, it will identify the following formats:
Numbers
Dates
Sheetgo will automatically parse and paste values into the destination sheet according to the format it recognizes. This setting allows you to automatically interpret and format raw data according to predefined rules. This tool is essential for converting unstructured data into a structured format that can be easily analyzed and integrated into your workflows.
Data transfer errors
In some circumstances, Sheetgo may incorrectly identify values as numbers, dates, or formulas.
This includes:
Phone numbers starting with +
Codes starting with 00
Codes that resemble dates
Value in source | Recognized format | Value pasted into the destination |
0005 | Number | 5 |
+49784621221 | Formula | #ERROR |
If numerical values are being pasted incorrectly into your destination sheet you can deactivate the Parse Data setting to paste values as raw data.
How to change the Parse Data setting?
Open the workflow that you want to edit and find the automation you need to turn off this feature.
On the Destination go to Advanced Settings, where you can find the Parse Data option.
Uncheck the box labeled Convert text to numbers, dates, and formulas.
Sheetgo will now paste values into your destination sheet as raw data every time the connection is updated.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.