Don't escape the space here:
newFile ('/Users/FZ/Google Drive/projectData.csv')
Also "newFile" should be "new File"
var csvFile = new File('/Users/FZ/Google Drive/projectData.csv');
Thank you for point that out. Still not able to create the file in the Google Drive with the this code.
Does Photoshop scripting allow creating a txt file in a remote server?
var csvFile = new File('/Users/FZ/Google\ Drive/projectData.csv');
What you are pointing to is a folder on your hard drive. Remote files on the Internet would have to be accesed using a Socket, then only if the sever allowed this sort of access.
P.S. you are stll escaping a space, you need to lose the \
I use a Photoshop script to format and process files. When the process is done the script writes to a cvs file. Info about the processed files. Trying to save the cvs file to Google Drive and link to a Google spread sheet. The idea is that the Google spread sheet updates every time the Photoshop script runs. Does Photoshop scripting allow socket protocols?
Photoshop does support sockets, but I wouldn't have an Idea how to implement it.
I thought that Google can sync from your PC if so you only have to save the file to a local folder.