Kommo and Google Sheets, ready to switch on
Every lead lands as a row with the pipeline, the stage, the amount and the manager, and the row is rewritten when the lead moves, so the weekly number needs no export. You paste a Kommo token and a link to your sheet, and we switch it on for you.
No setup fee, cancel any month, and a person on live chat if a key doesn't work.
More with these apps: all Kommo integrations · all Google Sheets integrations
What moves, and when
The details you would normally get after a sales call. Here they are up front.
| What | Direction | When | Rule |
|---|---|---|---|
| New lead as a row | Kommo to Google Sheets | Within seconds | Pipeline, stage, budget, the manager it belongs to and the tags it carries |
| Contacts on a second tab | Kommo to Google Sheets | Within seconds | Name, phone and email, tied back to the lead by its id |
| Stage and budget updates | Kommo to Google Sheets | Within seconds | Rewritten in place, so last week's figure doesn't change under your feet |
| Formulas and filters survive | In the sheet | Always | Only our own columns are written, and everything you built around them keeps working |
| One lead, one row | Kommo to Google Sheets | Every change | Matched on the lead id |
How to set up Kommo and Google Sheets
A few minutes of your time, then it's ours.
- Choose Kommo and Google SheetsPress Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
- Pay and open your accountCard or invoice, about two minutes. The account opens with this integration waiting for its two keys.
- Paste the Kommo token and the Google Sheets link
- Kommo token: in Kommo open Settings, then Integrations, then Create integration. Full Kommo guide
- Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
Each screen carries the full guide with the exact menu names, about six minutes for both. - We check both keysEach key is checked against Kommo's and Google Sheets's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
- Move one test lead, then we switch it onA minute or two. Change a test lead in Kommo and watch its row appear and then update. From then on we watch it for you. A person checks the setup and switches it on, within a working day.
When Kommo or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.
- Everything in the table above, with monitoring on.
- Fixes when either app changes its API.
- A person on live chat, weekdays 10:00 to 19:00 EET.
- Custom logic beyond the table is priced separately.
What it will cost once you can switch it on yourself. While we're in beta we connect it by hand and don't charge for it.
Ways to connect Kommo and Google Sheets
Two ways people connect these two, and what each one asks of you.
Before you decide
Can the team edit the sheet?
Yes. We rewrite only the columns we own; what you type elsewhere stays. An edit in Google Sheets doesn't change Kommo.
How far back does it go?
From the day it's switched on. History is a one-off job we scope with you first.
Anything to know about Kommo?
Kommo is the international edition of amoCRM, so the same long-lived token and API apply.
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 within a working day and build into the same account.
