Google

Introduction

The Google package in Robility encompasses a set of activities designed to interact with Google workspace. Google Workspace is a cloud-based platform developed by Google, which includes popular applications like Google Sheets, Google Docs, Google Drive, and Gmail. 

These activities leverage Google Cloud APIs and functionalities to seamlessly integrate with Google’s services, enabling users to streamline document processing, automate email communication, and enhance productivity within their automation workflows. 

About activities package

1. Google Document AI: Activities related to Google Document AI empower users to automate document processing and analysis tasks using Google’s AI and machine learning capabilities. This includes activities for extracting text, entities, and structured data from documents, performing document classification and entity recognition, and leveraging Google’s pre-trained models for document understanding tasks.

2. Gmail Integration: The Gmail activities in the Google package facilitate automation of email-related tasks within Gmail accounts. Users can automate actions such as sending emails, receiving and reading emails, searching for specific emails based on criteria, managing email threads and labels, and extracting email content for further processing.

3. Google Sheets Automation:

Robility offers out-of-the-box automation activities for Google Sheets, such as reading/writing cell values, manipulating ranges, and generating reports. Automation workflows in Robility can pull data from various business applications, process it, and export it directly to Google Sheets for real-time reporting and decision-making.

4. Seamless Integration with Gmail:

Robility integrates with Gmail to send automated emails based on predefined triggers or data conditions, making customer support or follow-up communication faster and more efficient. RPA bots can also manage email content dynamically, ensuring accurate information distribution.

5. File Handling with Google Drive:

Robility bots can automate the upload, download, and organization of files in Google Drive, reducing manual intervention in document management tasks. With the integration of Google Drive, bots can archive, retrieve, and share documents securely, enhancing collaboration and compliance.

Pre – requisites

To integrate Google services (such as Google Sheets, Google Drive, Gmail, etc.) into Robility for automation, there are certain prerequisites that need to be met. These ensure that Robility can securely connect to and access the Google Workspace services required for automation tasks. 

1. Google Cloud Project: You need to create a Google Cloud Project to access Google APIs (such as Google Sheets, Gmail, and Drive) for integration.
2. Enable Required APIs: Depending on the automation process, enable the relevant Google APIs within the Google Cloud project.
a. Google Sheets API: For automating Google Sheets.
b. Google Drive API: For file handling and folder management.
c. Gmail API: For automating email-related workflows.
3. OAuth 2.0 Credentials: Create OAuth 2.0 credentials to authenticate and authorize Robility to access the Google services on behalf of the user.
Steps:
a. In the APIs & Services section of the Google Cloud Console, go to Credentials.
b. Click on Create Credentials and select OAuth 2.0 Client IDs.
c. Configure the consent screen and specify the scopes (permissions) needed for your project.
d. Download the OAuth Client ID JSON file, which contains the credentials (client ID and client secret).

4. Google Account with Required Permissions: Ensure that you have a Google Workspace or Google Account with the required permissions for accessing the specific services.

a. For Google Sheets, you need read and write access to the sheets you want to automate.
b. For Google Drive, ensure you have the necessary permissions to read/write files.
c. For Gmail, permissions to send or manage emails.

Scopes for Permissions

When setting up the Google integration, you need to define the OAuth Scopes for your automation. These are permissions granted by the Google user to the Robility bot for accessing their data.

• https://sheets.googleapis.com/v4/spreadsheets,
• https://www.googleapis.com/drive/v3/drives
• https://www.googleapis.com/drive/v3/files
• https://www.googleapis.com/drive/v3/files/root?fields=id,name