RPA.Cloud.Google
Arguments
Argument | Type | Default value |
---|---|---|
mimeMessage | null | |
attachment | null |
Analyze sentiment in a text file
Arguments
Argument | Type | Default value |
---|---|---|
text | str, None | None |
text_file | str, None | None |
file_type | TextType | TEXT |
json_file | str, None | None |
lang | str, None | None |
param text: | source text |
---|---|
param text_file: | source text file |
param file_type: | type of text, PLAIN_TEXT (default) or HTML |
param json_file: | json target to save result, defaults to None |
param lang: | language code of the source, defaults to None |
return: | analysis response |
For list of supported languages: https://cloud.google.com/natural-language/docs/languages
Examples
Robot Framework
Annotate image
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str | null |
image_uri | str | null |
json_file | str, None | None |
param image_file: | source image file path |
---|---|
param image_uri: | Google Cloud Storage URI |
param json_file: | json target to save result |
return: | detection response |
Examples
Robot Framework
Annotate video
Arguments
Argument | Type | Default value |
---|---|---|
video_file | str, None | None |
video_uri | str, None | None |
features | str, None | None |
output_uri | str, None | None |
json_file | str, None | None |
timeout | int | 300 |
Possible values for features:
- FEATURE_UNSPECIFIED, Unspecified.
- LABEL_DETECTION, Label detection. Detect objects, such as dog or flower.
- SHOT_CHANGE_DETECTION, Shot change detection.
- EXPLICIT_CONTENT_DETECTION, Explicit content detection.
- SPEECH_TRANSCRIPTION, Speech transcription.
- TEXT_DETECTION, OCR text detection and tracking.
- OBJECT_TRACKING, Object detection and tracking.
- LOGO_RECOGNITION, Logo detection, tracking, and recognition.
If video_uri is given then that is used even if video_file is given.
param video_file: | local file path to input video |
---|---|
param video_uri: | Google Cloud Storage URI to input video |
param features: | list of annotation features to detect, defaults to LABEL_DETECTION,SHOT_CHANGE_DETECTION |
param output_uri: | Google Cloud Storage URI to store response json |
param json_file: | json target to save result |
param timeout: | timeout for operation in seconds |
return: | annotate result |
Examples
Robot Framework
Classify text
Arguments
Argument | Type | Default value |
---|---|---|
text | str, None | None |
text_file | str, None | None |
file_type | TextType | TEXT |
json_file | str, None | None |
lang | str, None | None |
param text: | source text |
---|---|
param text_file: | source text file |
param file_type: | type of text, PLAIN_TEXT (default) or HTML |
param json_file: | json target to save result, defaults to None |
param lang: | language code of the source, defaults to None |
return: | classify response |
For list of supported languages: https://cloud.google.com/natural-language/docs/languages
Examples
Robot Framework
Clear cell values for range of cells within a spreadsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_range | str | null |
param spreadsheet_id: | target spreadsheet |
---|---|
param sheet_range: | target sheet range |
return: | operation result |
Examples
Python
Robot Framework
Copy sheet into the spreadsheet as new sheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
source_sheet_name | str | null |
new_sheet_name | str | null |
insertSheetIndex | int, None | None |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param source_sheet_name: | name of the source sheet |
param new_sheet_name: | name for the new sheet |
param insertSheetIndex: | zero based index where the new sheet should be inserted, defaults to None |
return: | operation result as an dictionary |
Examples
Python
Robot Framework
Copy spreadsheet to target spreadsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
target_spreadsheet_id | str | null |
NOTE: service account user must have access also to target spreadsheet
param spreadsheet_id: | ID of the spreadsheet to copy |
---|---|
param target_spreadsheet_id: | ID of the target spreadsheet |
return: | operation result |
Examples
Python
Robot Framework
Create new directory to Google Drive
Arguments
Argument | Type | Default value |
---|---|---|
folder | str, None | None |
parent_folder | str, None | None |
param folder: | name for the new directory |
---|---|
param parent_folder: | top level directory for new directory |
return: | dictionary containing folder ID and folder URL |
Usage
Create a message for an email.
Arguments
Argument | Type | Default value |
---|---|---|
to | str | null |
subject | str | null |
message_text | str | null |
attachments | list, None | None |
html | bool | False |
param to: | message recipient |
---|---|
param subject: | message subject |
param message_text: | message body text |
param attachment: | list of files to add as message attachments |
param html: | set to True if message body is HTML (default False, plain text) |
return: | An object containing a base64url encoded email object |
Create sheet into the spreadsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str | null |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param sheet_name: | name for the new sheet |
return: | operation result as an dictionary |
Examples
Python
Robot Framework
Create empty sheet with a title
Arguments
Argument | Type | Default value |
---|---|---|
title | str | null |
param title: | name as string |
---|---|
return: | created spreadsheet_id |
Examples
Python
Robot Framework
Create Google Cloud Storage bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
param bucket_name: | name as string |
---|---|
return: | bucket |
Examples
Robot Framework
Delete file specified by id, file dictionary or query string
Arguments
Argument | Type | Default value |
---|---|---|
file_id | str, None | None |
file_dict | dict, None | None |
query | str, None | None |
multiple_ok | bool | False |
suppress_errors | bool | False |
Note. Be extra careful when calling this keyword!
param file_id: | drive file id |
---|---|
param file_dict: | file dictionary returned by Search Drive Files |
param query: | drive query string to find target file, needs to match 1 file unless parameter multiple_ok is set to True |
param multiple_ok: | set to True if it is ok to perform delete on more than 1 file |
param suppress_errors: | on True will log warning message instead of raising an exception, defaults to False |
return: | how many files where deleted |
Usage
Delete a sheet from the spreadsheet.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str | null |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param sheet_name: | name of the sheet to delete |
return: | operation result as an dictionary |
Examples
Python
Robot Framework
Delete Google Cloud Storage bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
Bucket needs to be empty before it can be deleted.
param bucket_name: | name as string |
---|
Examples
Robot Framework
Delete files in the bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
files | Any | null |
Files need to be object name in the bucket.
param bucket_name: | name as string |
---|---|
param files: | single file, list of files or comma separated list of files |
return: | list of files which could not be deleted Examples |
Robot Framework
Detect document
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str, None | None |
image_uri | str, None | None |
json_file | str, None | None |
param image_file: | source image file path |
---|---|
param image_uri: | Google Cloud Storage URI |
param json_file: | json target to save result |
return: | detection response |
Examples
Robot Framework
Detect labels in the image
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str, None | None |
image_uri | str, None | None |
json_file | str, None | None |
param image_file: | source image file path |
---|---|
param image_uri: | source image uri |
param json_file: | json target to save result |
return: | detection response |
Examples
Robot Framework
Detect tables in the sheet.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str, None | None |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param sheet_name: | name of the sheet, or leave None for all sheets |
return: | tables arranged by sheets |
Detect text in the image
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str, None | None |
image_uri | str, None | None |
json_file | str, None | None |
param image_file: | source image file path |
---|---|
param image_uri: | Google Cloud Storage URI |
param json_file: | json target to save result |
return: | detection response |
Examples
Robot Framework
Download files specified by file dictionary or query string
Arguments
Argument | Type | Default value |
---|---|---|
file_dict | dict, None | None |
query | str, None | None |
source | str, None | None |
limit | int, None | None |
timeout | float, None | None |
Parameters start, limit and timeout are used only when downloading files defined by query parameter.
param file_dict: | file dictionary returned by Search Drive Files |
---|---|
param query: | drive query string to find target files, defaults to None |
param source: | source directory where query is executed |
param limit: | maximum amount of files that are downloaded, defaults to None |
param timeout: | maximum allowed time in seconds for download process |
return: | list of downloaded files |
Usage
Download files from a bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
files | Any | null |
Example files: files = {"mytestimg": "image1.png", "mydoc": "google.pdf"}
param bucket_name: | name as string |
---|---|
param files: | list of object names or dictionary of object names and target files |
return: | list of files which could not be downloaded |
Examples
Robot Framework
Export Google Drive file using Drive export links
Arguments
Argument | Type | Default value |
---|---|---|
file_id | str, None | None |
file_dict | dict, None | None |
target_file | str, None | None |
mimetype | str | application/pdf |
param file_id: | drive file id |
---|---|
param file_dict: | file dictionary returned by Search Drive Files |
param target_file: | name for the exported file |
param mimetype: | export mimetype, defaults to "application/pdf" |
return: | file path to the exported file |
Usage
Detect faces
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str, None | None |
image_uri | str, None | None |
json_file | str, None | None |
param image_file: | source image file path |
---|---|
param image_uri: | Google Cloud Storage URI |
param json_file: | json target to save result |
return: | detection response |
Examples
Robot Framework
This keyword allows to do generic batch update to the spreadsheet.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
body | Dict | null |
For more information on the batch update: https://googleapis.github.io/google-api-python-client/docs/dyn/sheets_v4.spreadsheets.html#create
List of possible requests actions (body can contain multiple at the same time):
- addBanding
- addChart
- addConditionalFormatRule
- addDataSource
- addDimensionGroup
- addFilterView
- addNamedRange
- addProtectedRange
- addSheet (keyword Create sheet)
- addSlicer
- appendCells
- appendDimension
- autoFill
- autoResizeDimensions
- clearBasicFilter
- copyPaste
- createDeveloperMetadata
- cutPaste
- deleteBanding
- deleteConditionalFormatRule
- deleteDataSource
- deleteDeveloperMetadata
- deleteDimension
- deleteDimensionGroup
- deleteDuplicates
- deleteEmbeddedObject
- deleteFilterView
- deleteNamedRange
- deleteProtectedRange
- deleteRange
- deleteSheet (keyword Delete sheet)
- duplicateFilterView
- duplicateSheet (keyword Copy sheet)
- findReplace
- insertDimension
- insertRange
- mergeCells
- moveDimension
- pasteData
- randomizeRange
- refreshDataSource
- repeatCell
- setBasicFilter
- setDataValidation
- sortRange
- textToColumns
- trimWhitespace
- unmergeCells
- updateBanding
- updateBorders
- updateCells
- updateChartSpec
- updateConditionalFormatRule
- updateDataSource
- updateDeveloperMetadata
- updateDimensionGroup
- updateDimensionProperties
- updateEmbeddedObjectBorder
- updateEmbeddedObjectPosition
- updateFilterView
- updateNamedRange
- updateProtectedRange
- updateSheetProperties (keyword Rename sheet)
- updateSlicerSpec
- updateSpreadsheetProperties
param spreadsheet_id: | id of the spreadsheet |
---|---|
param body: | body of the batch update request |
return: | operation result as an dictionary |
Examples
Python
Robot Framework
Get values from the range in the spreadsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str, None | None |
value_render_option | str | UNFORMATTED_VALUE |
datetime_render_option | str | FORMATTED_STRING |
param spreadsheet_id: | target spreadsheet |
---|---|
param sheet_name: | target sheet (default first sheet) |
param value_render_option: | how values should be represented in the output defaults to "UNFORMATTED_VALUE" |
param datetime_render_option: | how dates, times, and durations should be represented in the output, defaults to "FORMATTED_STRING" |
return: | operation result |
Examples
Python
Robot Framework
Helper keyword for getting document entities from a Process Document response object.
Arguments
Argument | Type | Default value |
---|---|---|
document | Document | null |
For examples. see Process Document keyword
param document: | the document response object |
---|---|
return: | detected entities in the document response as a list |
Helper keyword for getting detected languages from a Process Document response object.
Arguments
Argument | Type | Default value |
---|---|---|
document | Document | null |
For examples. see Process Document keyword
param document: | the document response object |
---|---|
return: | detected languages in the document response as a list |
Get file dictionary by its file id.
Arguments
Argument | Type | Default value |
---|---|---|
file_id | str | null |
suppress_errors | bool | False |
param file_id: | id of the file in the Google Drive |
---|---|
param suppress_errors: | on True will log warning message instead of raising an exception, defaults to False (exception is raised) |
return: | dictionary containing file information |
Usage
Get file id for the folder
Arguments
Argument | Type | Default value |
---|---|---|
folder | str, None | None |
parent_folder | str, None | None |
details | bool | False |
param folder: | name of the folder to identify, by default returns drive's root folder id |
---|---|
param parent_folder: | can be used to narrow search by giving parent folder name |
param details: | on True will return folder dictionary, on False (default) folder id is returned |
return: | file id of the folder or file dictionary when details = True |
Usage
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str | null |
Get formulas from the sheet.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str | null |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param sheet_name: | name of the sheet |
return: | _description_ |
Get values from the range in the spreadhsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_range | str, None | None |
value_render_option | str | UNFORMATTED_VALUE |
datetime_render_option | str | FORMATTED_STRING |
param spreadsheet_id: | target spreadsheet |
---|---|
param sheet_range: | target sheet range |
param value_render_option: | how values should be represented in the output defaults to "UNFORMATTED_VALUE" |
param datetime_render_option: | how dates, times, and durations should be represented in the output, defaults to "FORMATTED_STRING" |
return: | operation result |
Examples
Python
Robot Framework
Get title, id, url and sheets information from the spreadsheet.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
param spreadsheet_id: | ID of the spreadsheet |
---|---|
return: | operation result as an dictionary |
Returns spreadsheet information as a dictionary.
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
param spreadsheet_id: | ID of the spreadsheet |
---|---|
return: | operation result as an dictionary |
Get Google Cloud Storage bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
param bucket_name: | name as string |
---|---|
return: | bucket |
Examples
Robot Framework
Arguments
Argument | Type | Default value |
---|---|---|
parsed_parts | null | |
part | null | |
msg | null | |
folder_name | null |
Initialize Google Apps Script client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
credentials | str, None | None |
use_robocorp_vault | bool, None | None |
scopes | list, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param credentials: | file path to credentials file |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param scopes: | list of extra authentication scopes |
param token_file: | file path to token file |
Initialize Google Cloud Document AI client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
region | str, None | us |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param region: | region of the service |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Robot Framework example:
Python example:
Initialize Google Drive client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
credentials | str, None | None |
use_robocorp_vault | bool, None | None |
scopes | list, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param credentials: | file path to credentials file |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param scopes: | list of extra authentication scopes |
param token_file: | file path to token file |
Initialize Google Gmail client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
credentials | str, None | None |
use_robocorp_vault | bool, None | None |
scopes | list, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param credentials: | file path to credentials file |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param scopes: | list of extra authentication scopes |
param token_file: | file path to token file |
Initialize Google Cloud Natural Language client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Sheets client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
credentials | str, None | None |
use_robocorp_vault | bool, None | None |
scopes | list, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param credentials: | file path to credentials file |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param scopes: | list of extra authentication scopes |
param token_file: | file path to token file |
Initialize Google Cloud Speech to Text client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Cloud Storage client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Cloud Text to Speech client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Cloud Translation client
Arguments
Argument | Type | Default value |
---|---|---|
project_identifier | str | null |
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param project_identifier: | identifier for Translation project |
---|---|
param service_account: | file path to service account file |
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Cloud Video Intelligence client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Initialize Google Cloud Vision client
Arguments
Argument | Type | Default value |
---|---|---|
service_account | str, None | None |
use_robocorp_vault | bool, None | None |
token_file | str, None | None |
param service_account: | file path to service account file |
---|---|
param use_robocorp_vault: | use credentials in Robocorp Vault |
param token_file: | file path to token file |
Insert values into sheet cells
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_range | str | null |
values | list | null |
major_dimension | str | COLUMNS |
value_input_option | str | USER_ENTERED |
param spreadsheet_id: | target spreadsheet |
---|---|
param sheet_range: | target sheet range |
param values: | list of values to insert into sheet |
param major_dimension: | major dimension of the values, default COLUMNS |
param value_input_option: | controls whether input strings are parsed or not, default USER_ENTERED |
return: | operation result |
Examples
Python
Robot Framework
List messages
Arguments
Argument | Type | Default value |
---|---|---|
user_id | str | null |
query | str | null |
folder_name | str, None | None |
label_ids | list, None | None |
max_results | int, None | None |
include_json | bool | False |
include_spam | bool | False |
param user_id: | user's email address. The special value me can be used to indicate the authenticated user. |
---|---|
param query: | message query |
param folder_name: | path where attachments are saved, default current directory |
param label_ids: | message label ids |
param max_results: | maximum number of message to return |
param include_json: | include original response json |
param include_spam: | include messages from SPAM and TRASH |
return: | messages |
Usage
List existing document AI processors from given project and region.
Arguments
Argument | Type | Default value |
---|---|---|
project_id | str | null |
region | str | null |
Requires documentai.processors.list permission.
param project_id: | Google Cloud project ID |
---|---|
param region: | Google Cloud region of the processor |
return: | list of available processors as a list |
Robot Framework example:
Python example:
List Google Cloud Storage buckets
return: | list of buckets |
---|
Examples
Robot Framework
List files in the bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
param bucket_name: | name as string |
---|---|
return: | list of object names in the bucket |
Examples
Robot Framework
List supported voices for the speech
Arguments
Argument | Type | Default value |
---|---|---|
language_code | str, None | None |
param language_code: | voice languages to list, defaults to None (all) |
---|---|
return: | list of supported voices |
Examples
Robot Framework
Loads the binary object saved by Save Document Response into documentai.Document format which is accessible by helper keywords.
Arguments
Argument | Type | Default value |
---|---|---|
filepath | str | null |
param filepath: | source file to read binary document object from |
---|---|
return: | processed document response object |
Robot Framework example:
Python example:
Move file specified by id, file dictionary or query string into target folder
Arguments
Argument | Type | Default value |
---|---|---|
file_id | str, None | None |
file_dict | dict, None | None |
query | str, None | None |
source | str, None | None |
target | str, None | None |
multiple_ok | bool | False |
param file_id: | drive file id |
---|---|
param file_dict: | file dictionary returned by Search Drive Files |
param query: | drive query string to find target file, needs to match 1 file |
param source: | name of the folder to move file from, is by default drive's root folder id |
param target: | name of the folder to move file into, is by default drive's root folder id |
param multiple_ok: | if True then moving more than 1 file |
return: | list of file ids |
Usage
Utility function that parses the content of an email partition
Arguments
Argument | Type | Default value |
---|---|---|
msg_id | null | |
msg | null | |
parts | null | |
folder_name | null |
Process document in the Google Cloud platform using given document processor ID within given project and region.
Arguments
Argument | Type | Default value |
---|---|---|
project_id | str | null |
region | str | null |
processor_id | str | null |
file_path | str | null |
mime_type | str, None | None |
For a full list of Document response object attributes, please reference this page.
param project_id: | Google Cloud project ID |
---|---|
param region: | Google Cloud region of the processor |
param processor_id: | ID of the document processor |
param file_path: | filepath of the document to process |
param mime_type: | given mime type of document (optional), if not given it is auto detected |
return: | processed document response object |
Robot Framework example:
Python example:
Recognize text in the audio file
Arguments
Argument | Type | Default value |
---|---|---|
audio_file | str, None | None |
audio_uri | str, None | None |
encoding | str, None | None |
language_code | str | en_US |
audio_channel_count | int | 2 |
sample_rate | int, None | None |
param audio_file: | local audio file path |
---|---|
param audio_uri: | Google Cloud Storage URI |
param encoding: | audio file encoding |
param language_code: | language in the audio |
param audio_channel_count: | number of audio channel |
param sample_rate: | rate in hertz, for example 16000 |
return: | recognized texts |
Examples
Robot Framework
Rename sheet in the spreadsheet
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_name | str | null |
new_sheet_name | str | null |
param spreadsheet_id: | id of the spreadsheet |
---|---|
param sheet_name: | existing name of the sheet |
param new_sheet_name: | name for the new sheet |
return: | operation result as an dictionary |
Examples
Python
Robot Framework
Run the Google Apps Script function
Arguments
Argument | Type | Default value |
---|---|---|
script_id | str | null |
function_name | str | null |
parameters | dict, None | None |
param script_id: | Google Script identifier |
---|---|
param function_name: | name of the script function |
param parameters: | script function parameters as a dictionary |
raises AssertionError: | thrown when Google Script returns errors |
Usage
Save Process Document response into a binary file.
Arguments
Argument | Type | Default value |
---|---|---|
document | Document | null |
filepath | str | null |
param document: | response document object |
---|---|
param filepath: | target file to save binary object into |
Robot Framework example:
Python example:
Search Google Drive for files matching query string
Arguments
Argument | Type | Default value |
---|---|---|
query | str, None | None |
recurse | bool | False |
source | str, None | None |
param query: | search string, defaults to None which means that all files and folders are returned |
---|---|
param recurse: | set to True if search should recursive |
param source: | source directory where query is executed |
return: | list of files |
Usage
Send an email message.
Arguments
Argument | Type | Default value |
---|---|---|
sender | str | null |
to | str | null |
subject | str | null |
message_text | str | null |
attachments | list, None | None |
html | bool | False |
param sender: | message sender |
---|---|
param to: | message recipient |
param subject: | message subject |
param message_text: | message body text |
param attachment: | list of files to add as message attachments |
param html: | set to True if message body is HTML (default False, plain text) |
return: | sent message |
Usage
Arguments
Argument | Type | Default value |
---|---|---|
audio_file | null | |
audio_uri | null |
Arguments
Argument | Type | Default value |
---|---|---|
payload | null | |
message_id | null | |
response | null |
Arguments
Argument | Type | Default value |
---|---|---|
image_file | str, None | None |
image_uri | str, None | None |
Arguments
Argument | Type | Default value |
---|---|---|
user_id | null | |
query | null | |
label_ids | null | |
max_results | null | |
include_spam | null |
Set Robocorp Vault name and secret key name :param vault_name: Robocorp Vault name :param vault_secret_key: Robocorp Vault secret key name :param auth_type: either serviceaccount or token
Arguments
Argument | Type | Default value |
---|---|---|
vault_name | str, None | None |
vault_secret_key | str, None | None |
auth_type | str | serviceaccount |
Synthesize speech synchronously
Arguments
Argument | Type | Default value |
---|---|---|
text | str | null |
language | str | en-US |
name | str | en-US-Standard-B |
gender | str | MALE |
encoding | str | MP3 |
target_file | str | synthesized.mp3 |
param text: | input text to synthesize |
---|---|
param language: | voice language, defaults to "en-US" |
param name: | voice name, defaults to "en-US-Standard-B" |
param gender: | voice gender, defaults to "MALE" |
param encoding: | result encoding type, defaults to "MP3" |
param target_file: | save synthesized output to file, defaults to "synthesized.mp3" |
return: | synthesized output in bytes |
Examples
Robot Framework
Convert a column number and a row number into a cell reference.
Arguments
Argument | Type | Default value |
---|---|---|
column_number | int | null |
row_number | int | null |
param column_number: | column number to convert |
---|---|
param row_number: | row number to convert |
return: | cell reference string |
Convert a column number into a column letter(s).
Arguments
Argument | Type | Default value |
---|---|---|
number | int | null |
param number: | column number to convert |
---|---|
return: | column letter(s) |
Translate text
Arguments
Argument | Type | Default value |
---|---|---|
text | list, str | null |
source_language | str, None | None |
target_language | str, None | None |
mime_type | TextType, None | None |
param text: | text to translate |
---|---|
param source_language: | language code |
param target_language: | language code |
param mime_type: | text or html |
return: | translated text |
Examples
Robot Framework
Update file specified by id, file dictionary or query string
Arguments
Argument | Type | Default value |
---|---|---|
file_id | str, None | None |
file_dict | dict, None | None |
query | str, None | None |
source | str, None | None |
action | UpdateAction | star |
multiple_ok | bool | False |
Possible actions: - star - unstar - trash - untrash
param file_id: | drive file id |
---|---|
param file_dict: | file dictionary returned by Drive Search Files |
param query: | drive query string to find target file, needs to match 1 file |
param source: | source directory where query is executed |
param action: | update action, default star file |
param multiple_ok: | set to True if it is ok to perform update on more than 1 file |
return: | number of updated files |
Usage
Insert values into sheet cells
Arguments
Argument | Type | Default value |
---|---|---|
spreadsheet_id | str | null |
sheet_range | str | null |
values | list | null |
major_dimension | str | COLUMNS |
value_input_option | str | USER_ENTERED |
param spreadsheet_id: | target spreadsheet |
---|---|
param sheet_range: | target sheet range |
param values: | list of values to insert into sheet |
param major_dimension: | major dimension of the values, default COLUMNS |
param value_input_option: | controls whether input strings are parsed or not, default USER_ENTERED |
return: | operation result |
Examples
Python
Robot Framework
Upload files into Drive
Arguments
Argument | Type | Default value |
---|---|---|
filename | str, None | None |
folder | str, None | None |
overwrite | bool | False |
make_dir | bool | False |
param filename: | name of the file to upload |
---|---|
param folder: | target folder for upload |
param overwrite: | set to True if already existing file should be overwritten |
param make_dir: | set to True if folder should be created if it does not exist |
return: | uploaded file id |
Usage
Upload a file into a bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
filename | str | null |
target_name | str | null |
param bucket_name: | name as string |
---|---|
param filename: | filepath to upload file |
param target_name: | target object name |
Examples
Robot Framework
Upload files into a bucket
Arguments
Argument | Type | Default value |
---|---|---|
bucket_name | str | null |
files | dict | null |
Example files: files = {"mytestimg": "image1.png", "mydoc": "google.pdf"}
param bucket_name: | name as string |
---|---|
param files: | dictionary of object names and filepaths |
Examples
Robot Framework