Hello! When I was working on my thesis and using the Google Spreadsheet API, I encountered something odd. I had set a column to plain text in the settings, but when data like a phone number was input via the API, it didn't work as expected. The column that I had prepared with a plain text format didn't work, and it automatically converted to a spreadsheet formula, resulting in a #ERROR. So, I think the settings in Google Spreadsheet only work when we’re working directly in the Google Spreadsheet workspace. But when a bot inputs data via the API, it doesn’t apply. Why is this happening, and what's the solution?
Solution
Just enclose your text in single quotes ('). This will make Google Spreadsheet interpret your text as plain text.