Write Output to google sheet and save in a specific Folder Path in G-drive

[DataPirate26]

Hi all, 

Can someone give an example how to write Output to google sheet and save the file in a specific given folder path in G-drive. I am able to generate G-sheet output but not able to save in a specific desired location in G-drive. 

[PanPP]

Hi @DataPirate26 

You will be able to output to google drive via the new google drive tools found in the links below:

https://help.alteryx.com/20223/designer/google-drive-output-tool

You can download the beta tool here which is the latest version that is coming out. https://community.alteryx.com/t5/Community-Gallery/Google-Drive-Tools/ta-p/898151

The latest tool that will be released should support outputting to a drive.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[apathetichell]

FYI: 

Work with Google Drive folders

There’s no option to create a spreadsheet directly within a specified Drive folder using the Sheets API. By default, the created spreadsheet is saved to the user’s root folder on Drive.

However, there are 2 alternatives to saving a file to a Drive folder:

• After the spreadsheet is created, move it to a specific folder using the files.update method of the Drive API. For more information on moving files, refer to Move files between folders.
• Add a blank spreadsheet to a folder using the files.create method of the Drive API, specifying application/vnd.google-apps.spreadsheet as the mimeType. For more information on creating files, refer to Create a file in a folder.

For either alternative, you'll need to add the appropriate Drive API scopes to authorize the call.

To move or create a file within a shared drive folder, refer to Implement shared drive support.

To learn more about cell and row limits in Google Sheets, see Files you can store in Google Drive.

https://developers.google.com/sheets/api/guides/create#python