Bitbucket and Google Sheets automations
Bitbucket code activity becomes a Google Sheets log, with “Add New Row to Sheet” adding a line per pull request.
Set up an automation: when pull request merges in Bitbucket, add new row to sheet in Google Sheets
Build itOr have an AI agent work across Bitbucket and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Bitbucket and Google Sheets in practice
Used for
Bitbucket code activity becomes a Google Sheets log, with “Add New Row to Sheet” adding a line per pull request.
Best template
“Pull Request Merges” in Bitbucket, then “Add New Row to Sheet” in Google Sheets. Each merged pull request lands as a row, giving you a running list of finished work.
Watch out
“Pipeline State Changed” in Bitbucket is polling, so a failed or passed pipeline can reach the sheet late.
Bitbucket and Google Sheets templates
Pick one and Captain builds it with you.


When commit comment created in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request comment is deleted in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request comment added in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request decline in Bitbucket, add new row to sheet in Google Sheets
Build this

When repository is forked in Bitbucket, add new row to sheet in Google Sheets
Build this

When pipeline state changed in Bitbucket, add new row to sheet in Google Sheets
Build this

When code is pushed in Bitbucket, add new row to sheet in Google Sheets
Build this

When repository created in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request approval changes in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request merges in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request updated in Bitbucket, add new row to sheet in Google Sheets
Build this

When pull request opens in Bitbucket, add new row to sheet in Google Sheets
Build this
Bitbucket and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
12- Pull request opensRuns when pull request opens
- Pull request updatedRuns when pull request updated
- Pull request mergesRuns when pull request merges
- Pull request approval changesRuns when PR approval changes
- Repository createdRuns when repository created
- Code is pushedRuns when Code Is Pushed
- Pipeline state changedTriggers when a pipeline is created or its state changes (started, passed, failed, stopped).
- Repository is forkedRuns when repository is forked
- Pull request declineRuns when pull request decline
- Pull request comment addedRuns when PR comment added
- Pull request comment is deletedRuns when PR comment deleted
- Commit comment createdRuns when comment on commit
No triggers match.
Actions
28- Create deployment environmentCreate a deployment environment (e.g., staging or production) for a repository and optionally set its order/priority.
- Create pull requestPropose merging changes from one branch into another.
- Add comment to pull requestPost a comment on a pull request to give feedback, ask questions, or update your team.
- Merge pull requestMerges an existing pull request.
- Approve pull requestApprove a pull request
- Decline pull requestDeclines a pull request.
- Create branch or tagCreate a branch or tag from a specified commit in your repository.
- Create project in workspaceCreate a new project in a workspace to group repositories.
- Create a snippet commentCreate a comment on a snippet
- Create repositoryCreate a new repository inside a workspace project.
- Update pull requestEdit an existing pull request
- Merge pull requestMerge a pull request
- Create task on pull requestCreate task on pull request
- Create build status for commitAdd build result to a commit
- Delete branch or tagDelete a branch or tag.
- Create branch restriction ruleCreate branch or tag rule
- Update branch restriction ruleUpdate an existing branch restriction rule
- Delete branch restriction ruleRemove a branch restriction
- Delete environmentRemove a repo environment
- Update repositoryUpdate repository settings
- Update project settingsEdit project name and privacy
- Get pull request file changesView changed files and stats
- Get pull request diff and diffstatRetrieve a pull request's diff and per-file change statistics (lines added/removed and file paths).
- List branches and tagsGet branches and tags from a Bitbucket repository, with options to choose branches, tags, or both, search by name, and paginate results.
- List workspace projects and check pull request templateList projects in a workspace and check whether a repository has a pull request template.
- List pull requestsRetrieve pull requests from a Bitbucket repository, optionally filtered by state, updated time, sort order, and limit.
- List merged pull requests by branch and date rangeFind merged pull requests for a specified branch within a selected date range.
- List pull requestsList pull requests in a Bitbucket repository, with optional state, search, sort, and pagination.
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 Bitbucket and Google Sheets
What can start a Bitbucket and Google Sheets automation?
“Commit comment created”, “Pull request comment is deleted”, “Pull request comment added”, “Pull request decline” and “Repository is forked”, and the others in the templates above.
Which other apps work with both Bitbucket and Google Sheets?
Shopify, WooCommerce, Calendly, ThriveCart and Tidyhire. Each one has templates with Bitbucket and with Google Sheets, so a third app can join the same job.
All Bitbucket integrations · All Google Sheets integrations · Every app, A to Z
Connect Bitbucket and Google Sheets
Or pick another template above. Free to start.
Build it with Captain