Excel GCC High
Read and write Excel workbooks for GCC High (Government Community Cloud) tenants through the Microsoft Graph API v1.0 GCC High endpoints in the US Government sovereign cloud.
📝 Beta: This connector is in beta. It follows the service's documented API but has not yet been fully tested against the live service, so some tools may behave differently than described.
What you can ask
- Read the used range of the
Q3 Budgetworksheet in a GCC High tenant - Append a row to the
Contractstable each time a new award is recorded - Add a chart to a workbook and return it as an image for a status report
Set up
Excel GCC High needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.
- Go to Organization > Connectors and find Excel GCC High. Click Enable, and choose which tools to allow.
- Create an OAuth application in the Excel GCC High developer portal.
- Add the Redirect URI shown in the connector settings to the application.
- Copy the application's Client ID and Client Secret into the connector, then save it.
- Each member connects their own account the first time they use it.
⚠️ Warning: Do not enter your Devs.ai or Excel GCC High login email or password in the OAuth application fields.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
OAuth scopes used by these tools (3)
Grant the scopes for the tools you plan to allow.
Files.ReadFiles.ReadWriteUser.Read
Tools
Excel GCC High offers 34 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (14)
View and search information without changing it.
| Tool | What it does |
|---|---|
get_chart_image | Get a base64-encoded PNG image of a chart. |
get_named_item | Get a single named item by name, including the value or formula it refers to. |
get_range | Get a cell range's values, text, and formulas by address (e.g. 'A1:B2'). |
get_table | Get a table by name or ID. |
get_used_range | Get the used range of a worksheet (the smallest range covering all cells with data). |
get_worksheet | Get a worksheet by name or ID. |
list_charts | List charts in a worksheet. |
list_named_items | List named items (named ranges and constants) defined in a workbook. |
list_table_columns | List columns of a table, including their values. |
list_table_rows | List data rows of a table, including their values. |
list_tables | List all tables in a workbook. |
list_workbooks | List Excel (.xlsx) workbooks in the signed-in user's own OneDrive. |
list_worksheets | List worksheets in a workbook. |
validate_credential | Validate Microsoft Excel credentials by calling GET /me on Microsoft Graph. |
Write (7)
Create or send data.
| Tool | What it does |
|---|---|
add_chart | Add a chart to a worksheet from a data range. chart_type e.g. 'ColumnClustered', 'Line', 'Pie'. source_data e.g. 'A1:C4'. series_by: Auto, Columns, or Rows. |
add_table | Create a table over a range, e.g. address 'Sheet1!A1:C5' with has_headers=true. |
add_table_column | Add a column to a table. values is a 2-D array including the header, e.g. [['Status'], ['Open'], ['Closed']]. |
add_table_row | Add one or more rows to a table. values is a 2-D array, e.g. [['Jan', 49, 37]]. |
add_worksheet | Add a new worksheet to a workbook. |
create_session | Create an Excel workbook session and return a session_id. |
refresh_session | Refresh a workbook session to keep it alive; persistent sessions expire after ~5 minutes idle, non-persistent after ~7. |
Delete or overwrite (13)
Remove or replace existing data.
| Tool | What it does |
|---|---|
clear_range | Clear a range's contents, formats, or both. apply_to: All (default), Contents, or Formats. |
close_session | Close an Excel workbook session created with create_session. |
create_workbook | Create a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other tools). |
delete_chart | Delete a chart from a worksheet by name or ID. |
delete_table | Delete a table (the underlying cells remain). |
delete_table_column | Delete a column from a table by column name or ID. |
delete_table_row | Delete a table row by zero-based index. |
delete_workbook | Delete an Excel workbook from the signed-in user's OneDrive by its driveItem ID. |
delete_worksheet | Delete a worksheet by name or ID. |
sort_table | Sort a table by one or more columns. fields is a list of {key (zero-based column index), ascending}. |
update_range | Write values, formulas, or number formats to a bounded range (e.g. 'A1:B2'). |
update_table | Update a table's name, header/totals visibility, or style. |
update_worksheet | Update a worksheet's name, position, or visibility. |