In general, I like to see all the hidden files. So I have used Ctrl+H to have Nautilus show all the hidden files.
But now thanks to this issue with google drive, I like Nautilus not to show the hidden files in my mapped google drive folder.
Is this possible?
This is not possible. By design, showing or hiding files in Files (nautilus) is a global setting, immediately affecting all windows.
In past times, it was a per-window setting. It probably still works like this in forked versions of nautilus, such as Nemo (Cinnamon desktop) or Caja (Mate desktop) and probably other file managers.
Thus, you may not be able to adapt the file manager itself. Either you may need to move away from it, or change your habits. You may want to learn to work without hidden files shown. It will reduce the clutter. In normal working circumstances, there is not much point of having the hidden files visible all the time. That is also why the feature is there: to have files present in a convenient location and at the same time avoiding to have to see them all the time. You only need to see these occasionally, and then they are just a keypress, Ctrl+h, away.