A web-based spreadsheet program included with the Google Docs Editors suite. Create and manage data in spreadsheets and CSVs, share with other users, and more.

A cloud-based file hosting service. Automate file and folder management tasks like uploads, versioning, or update notifications.

Optimize your business operations by integrating Google Drive and Sheets with UiPath. Automate the extraction of data from new invoices uploaded to Google Drive, ensuring precision and accuracy. Easily export the extracted data to Google Sheets, streamlining your workflow and minimizing manual effort. Experience the efficiency of UiPath's integrations, enhancing collaboration and driving productivity across your organization.

Automatically extract data from new invoices in Google Drive and export it to Google Sheets. Save time and streamline your workflow with precision and ease.

Google Drive and Google Sheets Integrations

Google Cloud内に含まれるドキュメント、スプレッドシート、保存されたファイルへのアクセス、メールの読み取りすべてにおいて連携できるロボットで生産性を大幅に向上させます。

このアクティビティは現在、UiPath Studio内の公式フィードにあり、エンタープライズユーザー向けに完全にサポートされています。  
以下、48個のコンポーネントが含まれます。

  

**Google カレンダー  
**\- 参加者を追加  
\- 予定を作成  
\- 予定を削除  
\- 予定を変更  
\- 予定を検索\*Google ドキュメント\*  
\- ドキュメントのバッチ更新スコープ  
\- ドキュメントを作成  
\- ドキュメントを取得  
\- テキストインデックスを取得  
\- テキストを挿入  
\- すべてのテキストを読み込み \*\*\* NEW \*\*\*  
\- テキストを置換

  

**Google ドライブ  
**\- ファイルやフォルダーを探す  
\- ファイルをコピー  
\- ファイルを削除  
\- ファイルを移動  
\- フォルダーを作成  
\- ファイルをダウンロード  
\- ファイルをアップロード  
\- ファイル情報を取得  
\- ファイルアクセス許可を作成  
\- ファイルアクセス許可を削除  
\- ファイルアクセス許可を取得  
\- ファイルアクセス許可を更新

  

**Gmail**  
\- メールメッセージを取得  
\- メールメッセージを送信  
\- ラベルを変更\*Google スプレッドシート\*  
\- 行を追加または削除  
\- 列を追加または削除  
\- 行を追加  
\- 範囲をオートフィル  
\- 値のバッチ更新スコープ  
\- 範囲をコピー/貼り付け  
\- シートをコピー  
\- 新しいスプレッドシートを作成  
\- 新しいシートを追加  
\- 範囲を削除  
\- シートを削除  
\- セルの色を取得  
\- シートを取得  
\- セルを読み込み  
\- 列を読み込み  
\- 行を読み込み  
\- 範囲を読み込み  
\- シート名を変更  
\- セルに書き込み  
\- 範囲に書き込み

  

**Authentication**  
\- GSuite アプリケーションスコープ (API Key, Service Account, OAuth)

  

**Supported Languages  
**\- 中国語（簡体字）  
\- 英語  
\- フランス語  
\- ドイツ語  
\- 日本語  
\- 韓国語  
\- ポルトガル語（ブラジル語）

  
ロシア語アクティビティについて詳しくはこちらをお読みください。

[https://docs.uipath.com/activities/docs/about-google-gsuite-activities](https://docs.uipath.com/activities/docs/about-google-gsuite-activities)

このアクティビティ一式は、Googleカレンダー、ドキュメント、ドライブ、スプレッドシート、Gmailとのやり取りに役立ちます。

Supercharge your productivity with a robot that can collaborate on documents, spreadsheets, access stored files, and read emails all within Google Cloud.This activity set is now on the official feed within UiPath Studio and is fully supported for Enterprise users. It contains 53 components:

**Google AppsScript**

*   Create Script Project
*   Create Deployment
*   Get Project Content
*   Run Script
*   Upload Script File

**Google Calendar**

*   Add Attendee
*   Create Event
*   Delete Event
*   Modify Event
*   Search Events

**Google Docs**

*   Batch Update Scope
*   Create Document
*   Get Document
*   Get Text Index
*   Insert Text
*   Read All Text
*   Replace Text

**Google Drive**

*   Find Files and Folders
*   Copy File
*   Delete File
*   Move File
*   Create Folder
*   Download File
*   Upload File
*   Get File Information
*   Create File Permission
*   Delete File Permission
*   Get File Permission
*   Update File Permission

**Gmail**

*   Get Mail Messages
*   Send Mail Messages
*   Change Labels

**Sheets**

*   Add Delete Rows
*   Add Delete Columns
*   Append Row
*   AutoFill Range
*   Batch Update Values Scope
*   Clear Range
*   Copy Paste Range
*   Copy Sheet
*   Create New SpreadSheet
*   Add New Sheet
*   Delete Range
*   Delete Sheet
*   Get Cell Color
*   Get Sheets
*   Read Cell
*   Read Column
*   Read Row
*   Read Range
*   Rename Sheet
*   Write Cell
*   Write Range

**Authentication**

*   GSuite Application Scope (API Key, Service Account, OAuth)

**Supported Languages**

*   Chinese (Simplified)
*   English
*   French
*   German
*   Japanese
*   Korean
*   Portuguese (Brazilian)
*   Russian

[Click here for documentation on the activities.](https://integrations.uipath.com/docs/gsuite-application-scope?password=)

This set of activities will help you interact with Google Calendar, Docs, Drive, Sheets, Gmail and Apps Script

Activities Google Sheet:

*   Application Scope manages the authentication to access the desired spreadsheet (identified by its id)
*   Read Range - reads a range of cells from the spreadsheet
*   Write Range - writes a range of cells on the spreadsheet

**NOTE**: Installation Guidelines for Custom Activities can be found [here](https://dmtyylqvwgyxw.cloudfront.net/instances/214/assets/help-guides/UiPath-Go-Installation-Guide-Custom-Activities.pdf).

Interacts with Google Spreadsheet by calling Google API.

Upload Gmail email attachments to Google Drive and move the email to a different folder.

Keep a Google Drive folder in sync with OneDrive or SharePoint, downloading Google Documents files as .docx files, Google Spreadsheets files as .xlsx files, Google Presentations as .pptx files, and Google Drawings as .png files, while preserving the original type of all other files.

Upload Outlook email attachments to Google Drive and move the email to a different folder.

Keep a OneDrive folder in sync with Google Drive by uploading newly created files to a folder.

Upload Documents (Envelopes) once they are signed in DocuSign to OneDrive

Extract data using Document Understanding when a new invoice is uploaded to Google Drive, then export it to an Google Sheets spreadsheet

Split a multi-page PDF into single pages and save them as individual files in a folder in OneDrive.

	Template	Apps	Used in
	Upload email attachments to Google Drive Upload Gmail email attachments to Google Drive and move the email to a different folder.		183 automations
	Sync Google Drive folder to OneDrive folder Keep a Google Drive folder in sync with OneDrive or SharePoint, downloading Google Documents files as .docx files, Google Spreadsheets files as .xlsx files, Google Presentations as .pptx files, and Google Drawings as .png files, while preserving the original type of all other files.		<100 automations
	Upload Outlook email attachments to Google Drive Upload Outlook email attachments to Google Drive and move the email to a different folder.		<100 automations
	Sync OneDrive folder to Google Drive folder Keep a OneDrive folder in sync with Google Drive by uploading newly created files to a folder.		<100 automations
	Upload Signed DocuSign Documents to OneDrive Upload Documents (Envelopes) once they are signed in DocuSign to OneDrive		<100 automations
	Extract data from a new invoice file in Google Drive and store it in Google Sheets Extract data using Document Understanding when a new invoice is uploaded to Google Drive, then export it to an Google Sheets spreadsheet		<100 automations
	Split PDF file in Google Drive to separate pages Split a multi-page PDF into single pages and save them as individual files in a folder in OneDrive.		<100 automations

	Listing	Apps	Downloads
	Google GSuite This set of activities will help you interact with Google Calendar, Docs, Drive, Sheets, Gmail and Apps Script		2581
	Activity for Google Sheets API Interacts with Google Spreadsheet by calling Google API.		173
	check industries programming line of b safsadf		<100

Automated Data Extraction with Google Drive and Google Sheets Integrations

Explore Studio Web templates

Move Received Email

Upload Attachments to Destination Folder

Upload Files

Move Email

Explore Studio Desktop listings