New learner. I setup a vm instance on Google Cloud and was going through some workflow learning exercises. One of the nodes has me reading from a Google Sheet and another has me writing back to the same sheet I read from. My vm is Linux (don’t know if Google Sheets runs there or not). I created a simple Google Sheet on my personal account, setup the workflow and tried to execute the step then realized it cannot find the sheet. I assume I have to put the file on the Cloud, but not sure how to do it. Do I create it on the server, if so how? Do I transfer the sheet there instead via ftp - again how and where do I put it?
hey,
You would need to upload to cloud, and then login to your google account, if selfhosting there is an extrastep, which is setting clientid and secret, and you would need domain for callback URL, There is a link on the credential page when you go to add in more details. If you want to work with local files, u can use write / read node which can access local file on server etc.
hope that helps.
Thanks for the reply. ChatGPT tells me I can leave the file where it is and just modify the permissions so it can be accessed from the vm instance. I still have to go through the steps I was given to test it. But thank you for responding.
1 Like