Google Sheets
The module allows you to customize the integration with Google Sheets.
Business processes
- Google Sheets: Remove sheet
- Google Sheets: Clear sheet
- Google Sheets: Create sheet
- Google Sheets: Create spreadsheet
- Google Sheets: Delete rows and columns from sheet
Settings
ParameterPresetDescriptionCredentials file - Path to credentials.json file provided by Google Cloud Platform
Google Drive
The module provides integration with Google Drive
ParameterDefaultDescriptionOAuth2 Client ID-Provided by the Google API Console.OAuth2 Client Secret-Provided by the Google API Console.
Data Model
Google Drive Element- virtual model that stores files and folders.
Fields:
- id(string) - id of file or folder;
- title(string) - name of file or folder.
Google Drive: Create Folder
Input
- title(string) - name of folder.
Output
- folder_id (string) - id of the created folder.
Google Drive: Delete folder
Input
- folder_id(string) - id of folder.
Google Drive: List files and folders
Output
- files(array model) - list of files;
- folders (array model) - list of folders
Google Drive: Download file
Input
- file_id(string) - id of file.
Output
- data(file) - downloaded file
Google Drive: Copy file
Input
- file_id(string) - id of file.
Output
- new_file_id(string) - id of new file.
Google Drive: Share file
Input
- file_id(string) - id of file;
- emails(array email) - emails to share.
Google Drive: Update file
Input
- folder_id (string) - id of folder;
- data(file) - updated file;
- title(string) - name of file;
- file_id(string) - id of file.
Google Drive: Delete file
Input
- file_id(string) - id of file.
Google Drive: Share folder
Input
- emails(array email) - emails to share;
- folder_id(string) - id of folder.