Integration
Connect Google Sheets to Google Classroom
When something happens in Google Sheets, your agent does the next thing in Google Classroom. Describe it in plain language and the automation is built, tested on every branch and kept running.
Build it
What do you want Google Sheets and Google Classroom to do together?
Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.
Ask the assistant
You'll sign in before anything runs. What you typed comes with you.
Or work from Claude Code
Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.
Connect Claude CodeEverything your agent can do with Google Sheets and Google Classroom
Triggers and actions 16 triggers · 72 actions
Trigger
Aggregate Metric ChangedFires when an aggregate metric (sum/avg/count/…) over a column changes. Managed by Composio (~15 min floor).
Trigger
Cell Range Values ChangedFires when the values in a specific cell range change. Managed by Composio (~15 min floor).
Trigger
Conditional Format Rule ChangedFires when a conditional-format rule changes. Managed by Composio (~15 min floor).
Trigger
Data Validation Rule ChangedFires when a data-validation rule changes. Managed by Composio (~15 min floor).
Trigger
Developer Metadata ChangedFires when developer metadata changes. Managed by Composio (~15 min floor).
Trigger
Filtered Range Values ChangedFires when the values in a filtered range change. Managed by Composio (~15 min floor).
Trigger
New RowsFires when new rows are appended to a Google Sheet. Managed by Composio (server-side poll; ~15 min floor).
Trigger
New Sheet AddedFires when a new sheet (tab) is added to a spreadsheet. Managed by Composio (~15 min floor).
Trigger
New Spreadsheet CreatedFires when a new spreadsheet is created in the account. Managed by Composio (~15 min floor).
Trigger
Spreadsheet Metadata ChangedFires when spreadsheet metadata changes. Managed by Composio (~15 min floor).
Trigger
Spreadsheet Properties ChangedFires when spreadsheet properties change. Managed by Composio (~15 min floor).
Trigger
Spreadsheet Row ChangedFires when a row matching a query changes. Managed by Composio (~15 min floor).
Trigger
Spreadsheet Search MatchFires when a spreadsheet matching search criteria is found. Managed by Composio (~15 min floor).
Trigger
Table Query Result ChangedFires when the result of a SQL-style table query changes. Managed by Composio (~15 min floor).
Trigger
Table Schema ChangedFires when a table's column schema changes. Managed by Composio (~15 min floor).
Trigger
Worksheet Names ChangedFires when worksheet (tab) names change. Managed by Composio (~15 min floor).
Action
Add RowAppend a row to a Google Sheet
Action
Aggregate Column DataRead a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).
Action
Auto-Resize Rows or ColumnsAuto-fit row heights or column widths over an index range via autoResizeDimensions.
Action
Change Sheet PropertiesUpdate a worksheet's grid properties (row/column count) using an explicit field mask.
Action
Clear Basic FilterRemove the basic filter from a sheet via clearBasicFilter.
Action
Clear Spreadsheet Row(s)Clear the values in a range (formatting preserved).
Action
Copy RangeCopy a source cell range to a destination range within the spreadsheet.
Action
Copy WorksheetCopy a worksheet into a destination spreadsheet.
Action
Create ChartAdd a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.
Action
Create Conditional Formatting RuleAdd a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.
Action
Create Multiple Spreadsheet RowsAppend many rows in one call.
Action
Create SpreadsheetCreate a new Google Sheets spreadsheet with the given title.
Action
Create Spreadsheet ColumnInsert a blank column at a given index.
Action
Create Spreadsheet RowAppend a single row of values to a sheet range.
Action
Create Spreadsheet Row at TopInsert a blank row just below the header (row 2), then write the given values into it in one operation.
Action
Create WorksheetAdd a new worksheet (tab) to an existing spreadsheet.
Action
Delete ChartDelete an embedded chart via deleteEmbeddedObject.
Action
Delete SheetDelete a worksheet from a spreadsheet by sheetId (gid).
Action
Delete Spreadsheet Row(s)Delete a contiguous block of rows by index.
Action
Find and ReplaceFind and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).
Action
Find SpreadsheetFind spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).
Action
Find WorksheetReturn the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.
Action
Format Cell RangeApply background color and bold formatting to a cell range via repeatCell.
Action
Format Spreadsheet RowApply a background color across an entire row via repeatCell over a row range.
Action
Get Conditional Format RulesList all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).
Action
Get Data RangeRead all values in a range.
Action
Get Data Validation RulesRead the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).
Action
Get Many Spreadsheet Rows (Advanced)Read multiple ranges at once via batchGet.
Action
Get Row by IDRead a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.
Action
Get Sheet NamesReturn the titles of all sheets (tabs) in the spreadsheet.
Action
Get Spreadsheet by IDFetch spreadsheet metadata (title, sheets, gids, grid properties).
Action
List ChartsList all embedded charts (chartId + title) across every sheet in the spreadsheet.
Action
Lookup Spreadsheet RowRead a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
Action
Lookup Spreadsheet Rows (Advanced)Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
Action
Move ChartReposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.
Action
Rename SheetRename a worksheet's title.
Action
Search SpreadsheetsSearch spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.
Action
Set Basic FilterApply a basic filter to a range on a sheet via setBasicFilter.
Action
Set Data ValidationApply a ONE_OF_LIST dropdown data-validation rule to a cell range.
Action
Sort RangeSort a cell range by one column in ascending or descending order.
Action
Update ChartReplace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.
Action
Update Conditional Format RulesReplace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.
Action
Update Data Validation RuleOverwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).
Action
Update Spreadsheet RowOverwrite the values at a specific range.
Action
Update Spreadsheet Row(s)Update one or more disjoint ranges in a single batch.
Action
Upsert RowRead a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).
Action
Classrooms Course Work Materials ListTool to list courseworkmaterials in a course. use after confirming a valid courseid; supports pagination and ordering.
Action
Courses Announcements CreateTool to create an announcement in a course. use after confirming the course id is valid.
Action
Courses Announcements DeleteTool to delete an announcement. use after confirming the announcement id.
Action
Courses Announcements GetTool to get an announcement. use when you need to fetch an announcement by course and announcement id.
Action
Courses Announcements ListTool to list announcements in a course. use after you have the course id to page through announcements.
Action
Courses Announcements PatchTool to update fields of an announcement. use when you need to modify specific details of an existing announcement after confirming which fields to update.
Action
Courses GetTool to get details for a specific course. use when you need full course information by id.
Action
Courses ListTool to list all courses accessible to the authenticated user. use when you need a paginated list of courses.
Action
Courses Students Guardians ListTool to list guardians of a student in a course. use when you need to retrieve and paginate guardians for a given student in a course.
Action
Courses Students ListTool to list students in a course. use after you have the course id to page through enrolled students.
Action
Courses Teachers GetTool to get teacher enrollment. use when you need to retrieve a specific teacher in a course by courseid and userid.
Action
Courses Teachers ListTool to list teachers in a course. use after you have the course id to page through enrolled teachers.
Action
Courses Topics CreateTool to create a course topic. use when you need to organize course content into named sections.
Action
Courses Topics DeleteTool to delete a course topic. use when you need to remove a topic from a course after confirming the course and topic ids.
Action
Courses Topics GetTool to get a course topic. use when you need to retrieve details of a specific course topic by id after confirming the course and topic ids.
Action
Courses Topics ListTool to list topics in a course. use when you have confirmed the courseid and need to retrieve its topics.
Action
Courses Topics PatchTool to update fields of a course topic. use when you need to rename a topic after confirming its current details.
Action
Course Work CreateTool to create a coursework item in a course. use when you need to assign an assignment or question to students immediately or on a schedule.
Action
Course Work DeleteTool to delete a specific coursework. use when you need to remove a coursework item from a course after confirming the ids.
Action
Course Work GetTool to get details of a specific coursework. use when detailed information about a particular assignment is needed.
Action
Course Work ListTool to list coursework in a course. use after verifying courseid.
Action
Course Work Materials CreateTool to create course work material. use when adding resources or notes to a course.
Action
Course Work Materials GetTool to get a coursework material. use when you need to retrieve details of a specific coursework material by course and material id.
Action
Course Work Materials ListTool to list course work materials in a course. use when you need to retrieve and paginate materials for a given courseid.
Action
Course Work PatchTool to update fields of a coursework. use when you need to modify specific details of an existing coursework after confirming which fields to update.
Action
Course Work Student Submissions ListTool to list student submissions for a specific coursework. use when you need to fetch or paginate student submissions by course and coursework, optionally filtering by user, state, or timeliness.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.