Skip to main content
  • EN

Hey all,

Just wondering if anyone has figured out how to write a brand new google sheet to a folder?

I have the following file and folder directory structure:

  • My Drive/
  • My Drive/Statistics/
  • My Drive/Statistics/2017 <---googlesheet

I want fme to create the google sheet, '2018' in the "My Drive/Statistics/" folder automatically (without user intervention), but no matter if I include the string "My Drive/Statistics/" or the folder ID & "/" , it always writes the new sheet to the root of My Drive. If the Google Sheet already exists, this is not a problem.

Sounds like a very good enhancement for the team to work in. I strongly suspect we don't do this now.

Sounds like a very good enhancement for the team to work in. I strongly suspect we don't do this now.

Hi @aarcra, I've filed a problem report in our tracking system and linked your question to it. I'll update you here once it's possible to write a new sheet in a specified (non-root) folder. Thanks for posting your question and bringing it to our attention!

Reply


Community Stats

30,108
Posts
114,283
Replies
37,742
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.