Guru and Google Sheets automations
Guru is the knowledge base, Google Sheets is the log, and “Card Verified” can feed “Update Spreadsheet Row”.
Set up an automation: when card verified in Guru, update spreadsheet row in Google Sheets
Build itOr have an AI agent work across Guru and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Guru and Google Sheets in practice
Used for
Guru is the knowledge base, Google Sheets is the log, and “Card Verified” can feed “Update Spreadsheet Row”.
Best template
“Card Verified” in Guru, then “Update Spreadsheet Row” in Google Sheets. A verified card can update a row, so a sheet can show which knowledge has been checked.
Watch out
“Update Spreadsheet Row” edits existing rows and does not add new ones for events like “Card Viewed”.
Guru and Google Sheets templates
Pick one and Captain builds it with you.


When card updated in Guru, update spreadsheet row in Google Sheets
Build this

When draft created in Guru, update spreadsheet row in Google Sheets
Build this

When question deleted in Guru, update spreadsheet row in Google Sheets
Build this

When question answered in Guru, update spreadsheet row in Google Sheets
Build this

When question created in Guru, update spreadsheet row in Google Sheets
Build this

When tag category updated in Guru, update spreadsheet row in Google Sheets
Build this

When tag category deleted in Guru, update spreadsheet row in Google Sheets
Build this

When tag category created in Guru, update spreadsheet row in Google Sheets
Build this

When tag merged in Guru, update spreadsheet row in Google Sheets
Build this

When tag updated in Guru, update spreadsheet row in Google Sheets
Build this

When tag deleted in Guru, update spreadsheet row in Google Sheets
Build this

When tag created in Guru, update spreadsheet row in Google Sheets
Build this

When team member removed in Guru, update spreadsheet row in Google Sheets
Build this

When team member added in Guru, update spreadsheet row in Google Sheets
Build this

When user group member added in Guru, update spreadsheet row in Google Sheets
Build this

When user group deleted in Guru, update spreadsheet row in Google Sheets
Build this

When user group created in Guru, update spreadsheet row in Google Sheets
Build this

When card draft created in Guru, update spreadsheet row in Google Sheets
Build this

When collection exported in Guru, update spreadsheet row in Google Sheets
Build this

When collection deleted in Guru, update spreadsheet row in Google Sheets
Build this

When collection created in Guru, update spreadsheet row in Google Sheets
Build this

When card viewed in Guru, update spreadsheet row in Google Sheets
Build this

When card verified in Guru, update spreadsheet row in Google Sheets
Build this

When card to pdf in Guru, update spreadsheet row in Google Sheets
Build this

When card unfavorited in Guru, update spreadsheet row in Google Sheets
Build this

When card restored in Guru, update spreadsheet row in Google Sheets
Build this

When card link copied in Guru, update spreadsheet row in Google Sheets
Build this

When card favorited in Guru, update spreadsheet row in Google Sheets
Build this

When card deleted in Guru, update spreadsheet row in Google Sheets
Build this

When card copied in Guru, update spreadsheet row in Google Sheets
Build this

When card comment updated in Guru, update spreadsheet row in Google Sheets
Build this

When card comment resolved in Guru, update spreadsheet row in Google Sheets
Build this

When card comment deleted in Guru, update spreadsheet row in Google Sheets
Build this

When card comment created in Guru, update spreadsheet row in Google Sheets
Build this

When card added to folder in Guru, update spreadsheet row in Google Sheets
Build this

When folder viewed in Guru, update spreadsheet row in Google Sheets
Build this

When folder to pdf created in Guru, update spreadsheet row in Google Sheets
Build this

When folder deleted in Guru, update spreadsheet row in Google Sheets
Build this

When new folder updated in Guru, update spreadsheet row in Google Sheets
Build this

When new folder created in Guru, update spreadsheet row in Google Sheets
Build this
Guru and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
41- Card createdTrigger when a user creates a card.
- New folder createdTrigger when a new Folder Created.
- New folder updatedRuns when Folder is updated
- Folder deletedTrigger when a new Folder Deleted.
- Folder to pdf createdTrigger when a Folder To Pdf Created.
- Folder viewedTrigger when an existing Folder Viewed.
- Card added to folderTrigger when a Card Added To Folder.
- Card comment createdTrigger when a Card Comment Created.
- Card comment deletedTrigger when a Card Comment Deleted.
- Card comment resolvedTrigger when a Card Comment Resolved.
- Card comment updatedTrigger when a Card Comment Updated.
- Card copiedTrigger when a Card or Card content Copied.
- Card deletedTrigger when a Card Deleted.
- Card favoritedTrigger when a Card Favorited.
- Card link copiedTrigger when a user clicked on the "Card Copy link" button while viewing a card.
- Card restoredTrigger when a user restored a card from the archives.
- Card unfavoritedTrigger when a user removes a card from their card favorites list .
- Card to pdfTrigger when a user downloads a card as a PDF.
- Card updatedTrigger when a user made edits to a card.
- Card verifiedTrigger when a user has verified a card.
- Card viewedTrigger when a user clicked & viewed a card.
- Collection createdTrigger when a user created a collection.
- Collection deletedTrigger when a user deleted a collection.
- Collection exportedTrigger when a user exports a collection.
- Card draft createdTrigger when a user created a card draft
- User group createdTrigger when a User Group is created.
- User group deletedTrigger when a User Group is Deleted.
- User group member addedTrigger when a user is added to a Group.
- Team member addedTrigger when a new user is added to your team.
- Team member removedTrigger when a user is removed from your team.
- Tag createdTrigger when a user created a tag.
- Tag deletedTrigger when a user delete a tag.
- Tag updatedTrigger when a user update a tag.
- Tag mergedTrigger when a user merged a tag with another tag.
- Tag category createdTrigger when a user created a tag category.
- Tag category deletedTrigger when a user deleted a tag category.
- Tag category updatedTrigger when a user updated a tag category.
- Question createdTrigger when a user created a question in the "Ask the Experts" feature.
- Question answeredTrigger when a user answered a question in the "Ask the Experts" feature.
- Question deletedTrigger when a user deleted a question in the "Ask the Experts" feature.
- Draft createdTrigger when a user created a card draft.
No triggers match.
Actions
10- Create cardCreate a new card in a chosen collection; optionally add folders, tags, collaborators, sharing, or verification.
- Update cardUpdate an existing card's title, content, tags, folders, sharing, verification, collaborators, and advanced settings.
- Delete cardDeletes an existing card.
- Ask a questionSubmits a question to Guru and returns the answer.
- Find answersFind relevant knowledge and documents for a query.
- List foldersList folders in Guru, optionally filtered by collection, keyword or folder IDs.
- List cardsList cards in Guru by keyword or Guru query, with sorting and pagination.
- List membersList team members in Guru, with optional name or email filter, user type filter and sorting.
- List groupsList user groups in Guru, optionally searched by name and sorted.
- List collectionsList collections in Guru, optionally searched by name and sorted.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Guru and Google Sheets
What can start a Guru and Google Sheets automation?
“Card updated”, “Draft created”, “Question deleted”, “Question answered” and “Question created”, and the others in the templates above.
Which other apps work with both Guru and Google Sheets?
Slack, Notion, Pipedrive, Planable and Polar. Each one has templates with Guru and with Google Sheets, so a third app can join the same job.
All Guru integrations · All Google Sheets integrations · Every app, A to Z