Overview
IntelliBuddies lets you interact with Drive and Sheets tasks. It enables you to extend your automation connectivity toward Google tenants and perform multiple actions. Here is the List of activities IntelliBuddies supports to automate your Google processes.
| Activity | Description |
|---|---|
| Google Context | Create a context by connecting to the Google Drive tenant using Drive API V3 and allowing you to perform multiple actions within it. |
| Copy File | Copies a specified file from the source to the specified folder in Google Drive. |
| Create Folder | Creates a new folder inside the Google Drive. |
| Delete File | Deletes a specified file in the Google Drive. |
| Delete Folder | Deletes a specified folder in the Google Drive. |
| Download File | Downloads the specified File from Google Drive into the file system. |
| Download Folder | Downloads a specified folder from Google Drive into the file system. |
| File Exists | Checks whether the specified File exists in Google Drive. |
| Folder Exists | Checks whether the specified folder exists in Google Drive. |
| Move File | Moves a specified file from the source to the specified folder in Google Drive. |
| Move Folder | Moves a specified folder from the source to the specified folder in Google Drive. |
| Upload File | Uploads a local file into a specified Google Drive directory. |
| Add Sheet | Adds an empty sheet into the specified spreadsheet. |
| Create Spreadsheet | Creates a spreadsheet in the specified drive folder. |
| Download Spreadsheet | Downloads a specified Google sheet from Google Drive into the file system. |
| Read Cell | Reads a cell's value and stores it in a variable. |
| Read Range | Reads data from the specified Range in a spreadsheet and converts it to a DataTable. |
| Write Cell | Writes a value into a specified cell in spreadsheet. |
| Write Range | "Writes the data from a DataTable to the specified spreadsheet. |
| Copy Sheet | "Copies the entire sheet from one spreadsheet to another." |
| Delete Cells | "Deletes cells from the specified address or range in the specified sheet." |
| Delete Columns | "Deletes the entire column at the address or range in the specified sheet" |
| Delete Rows | "Deletes the entire row at the address or range in the specified sheet." |
| Find | "Searches in a specified range with a certain value and returns the list of the cell address." |
| Find And Replace | "Finds and replaces data in cells over a range, sheet, or all sheets in a specified spreadsheet." |
| Find First Empty Row And Column | "Finds the first empty row and column in the specified sheet." |
| Find First Empty Cell | "Finds the first empty cell in the specified row or column index of a sheet." |
| Find Last Empty Cell | "Finds the last empty cell in the specified row or column of a sheet." |
| Find Last Empty Row And Column | "Finds the last empty row and column in the specified range of the specified sheet." |
| Get Sheets | "Returns the list of all the sheets in a specified spreadsheet." |
| Insert Cells | "Inserts cells into a specified address or range in the specified sheet." |
| Insert Columns | "Inserts columns in a sheet at a specified index." |
| Insert Rows | "Inserts rows in a sheet at the specified address or range." |
| Read Cell Formula | "Extracts the formula of the specified cell and stores it in a variable." |
| Rename Sheet | "Renames the existing sheet in the specified spreadsheet." |
| Set Active Sheet | "Sets the active sheet to a specified spreadsheet." |
| Sheet Exists | "Checks whether sheet with the given name exists or not in a specified spreadsheet." |