Bitrix24 and Google Sheets, ready to switch on

Deals and leads land as rows with the stage, the sum, the owner and the source, and each row is rewritten when the deal moves, so a report built on the sheet is right without an export. You paste a webhook and a link to your sheet, and it runs, in about ten minutes.

No setup fee, cancel any month, and a person on live chat if a key doesn't work.

More with these apps: all Bitrix24 integrations · all Google Sheets integrations

What moves, and when

The details you would normally get after a sales call. Here they are up front.

WhatDirectionWhenRule
New deal as a rowBitrix24 to Google SheetsWithin secondsNumber, date, pipeline, stage, sum, the responsible manager and the source
Leads on their own tabBitrix24 to Google SheetsWithin secondsSo the unqualified ones don't sit in the middle of a report about deals
Stage and sum updatesBitrix24 to Google SheetsWithin secondsThe same row is rewritten, which is what makes a pivot on top of it worth trusting
Your columns stay yoursIn the sheetAlwaysWe fill the columns we set up; what you add to the right of them is untouched
One deal, one rowBitrix24 to Google SheetsEvery changeMatched on the Bitrix24 id, so editing a card doesn't add a second row

Ten minutes of your time, then it's ours

  1. Pay and open your account
    Card or invoice, about two minutes. This integration is already selected.
  2. Paste the Bitrix24 webhook and the Google Sheets link
    Each has a short guide. About five minutes. If one doesn't work, a person joins the chat.
  3. Move one test deal
    A minute or two. Change a test deal in Bitrix24 and watch its row appear and then update. From then on we watch it for you.

When Bitrix24 or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.

$39a month
  • Everything in the table above, with monitoring on.
  • Fixes when either app changes its API.
  • A person on live chat, replies within a working hour.
  • Custom logic beyond the table is priced separately.
Connect for $39 a month

No setup fee, cancel any month

Before you decide

Can the team edit the sheet?

Yes. Columns we own are rewritten when Bitrix24 changes, and anything you type elsewhere in the row stays. If you want an edit in Google Sheets to change Bitrix24, that is a different job and we price it.

How far back does it go?

From the moment you switch it on. Pulling the history you already have in Bitrix24 is a one-off job we scope with you first, because the fields people used two years ago are rarely the fields they use now.

Can we report on funnels this way?

Yes, and it's the usual reason people ask for it. Because the stage and the sum are rewritten in the same row, a pivot over the sheet shows the pipeline as it stands rather than as it was exported.

Anything to know about Bitrix24?

An inbound webhook carries the permissions of the user who created it, so make it as an administrator or as someone who sees every deal.

Anything to know about Google Sheets?

Google Sheets doesn't tell anyone when a cell changes, so anything we read back out of a sheet is picked up on a short schedule rather than the moment you type it.

What if mine is a bit different?

Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price the same day and build into the same account.