I have an issue with the number format when getting data from ad platforms to Google Sheets via windsor.ai connector:
- I created several custom fields in windsor.ai dashboard and when I connect to Google Sheets, the data downloaded as always “Plain Text” no matter the format from the custom fields is. For example I choose “NUMERIC” for a custom field, the data goes to my Sheets is “Plain Text”. When I change the format of the sheet to “Number” when the data refreshing, that format is back to “Plain Text”
- The issue happens to custom fields only but it leads to wrong calculation in the Google Sheets
Please help to fix it. Thank you!