Skip to end of metadata
Go to start of metadata

This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial.



Google Sheets

Author: Irene Cho 

This plugin creates, reads from, writes to, and manages Google Sheets.

Primary Features

You can create Google Sheet and read from/write to it. Management functions includes rename a spreadsheet or sheet, adding, deleting, and duplicating sheets.  There is also a feature to find and replace certain values in the spreadsheet.

Prerequisite

  • A file token.pickle which stores the credential information of Google API (Refer Google Token Plugin).

Google Spreadsheet ID and Sheet Id.

  • The spreadsheet id and sheet id both can be found from URL.



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,



1. Return Value (CSV) headers

 Below 4 operations return CSV as Return Value.

 (warning) Note : the headers are used as “variable name” when you extract data from CSV and they are case sensitive.


Operations                       Column A               Column B                    Column C

Add a Sheet:                     sheetId                  spreadsheetId

Delete a Sheet                  sheetId                 spreadsheetId

Rename a Sheet               sheetId                 spreadsheetId

Duplicate a Sheet            new sheetId        old sheetId                 spreadsheetId


 

2. Plugin operations and required parameters

 

Operations

Parameters

Output


Read a Spreadsheet

Spreadsheet Id

 Values from the cell range of the sheet in form of CSV.

Sheet Range

(e.g. Sheet1!A1:B3, sheetname!A1)

Create a Spreadsheet

Spreadsheet Name

Spreadsheet Id


Write a Spreadsheet

Spreadsheet Id


Spreadsheet Id

Sheet Range

Excel/CSV File

*Only accept .xslx or .csv format

Inputfile Sheet

*Sheetname of input excel file

Rename a Spreadsheet

Spreadsheet Id

 Spreadsheet Id

Spreadsheet Name


Add a Sheet

Spreadsheet Id


 Sheet Id, Spreadsheet Id

Sheet Name

Sheet Id (optional): Integer e.g. 123

Delete a Sheet

Spreadsheet Id

 Sheet Id,  Spreadsheet Id

Sheet Id: The sheet id to delete

Rename a Sheet

Spreadsheet Id


Sheet Id,  Spreadsheet Id

Sheet Id: The sheet id to rename

Sheet Name

Duplicate a Sheet

Spreadsheet Id


Newssheet Id,  oldsheet Id, Spreadsheet Id

Sheet Id: The sheet id to be duplicated

Sheet Name

Find and Replace

Spreadsheet Id

 Sheet Id,  Spreadsheet Id


3. Example of the plugin in STU