Skip to main content
Solved

Create new Google Sheet in a specific folder...

  • February 28, 2018
  • 2 replies
  • 26 views
aarcra
Contributor

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.

Best answer by fmelizard

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • Best Answer
  • March 2, 2018

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

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • March 2, 2018

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!

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.