Write Output to google sheet and save in a specific Folder Path in G-drive
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
