We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

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

DataPirate26
10 - Fireball

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. 

2 REPLIES 2
PanPP
Alteryx Alumni (Retired)

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.

 

googledriveoutput.png

 

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
20 - Arcturus

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

Labels
Top Solution Authors