As can be seen in the first figure, the google sheets has loaded after running once. Now in the second figure, when I add data cleansing tool the fields don't get loaded like how it would have if it was 'excel input'. I should run the workflow again for the fields to appear in data cleansing tool.
What can be done to make it run like excel input?
When connecting to an Excel file, Alteryx can identify the metadata (filed names, field types, etc.) before running the workflow and can therefore pre-configure the Data Cleanse tool. With the Google Sheets connector, however, since it's a remote connection and the metadata isn't available until the workflow is run, Alteryx can't pre-configure the Data Cleanse tool.
Depending on what type of cleansing you want to do, it may be possible to use something like the Multi-field formula, where you can use [_Currentfield_] and something like a Trim() function to remove whitespace.