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 it

Or 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

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

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

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
Bitbucket and Google SheetsBuild it