1C and Google Sheets, ready to switch on

Invoices, payments and shipments land on their own tabs with numbers, dates, customers and totals, and stock counts are refreshed in place so a formula above them reads today's number. You paste the service address and a link to your sheet, and we switch it on for you.

Ask us to connect it Mine is a bit different

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

More with these apps: all 1C 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
Documents as rows	1C to Google Sheets	A few times an hour	Invoices, payments and shipments each on their own sheet, with number, date, customer and total
Payment status	1C to Google Sheets	When it is posted in 1C	The status column of the same row is rewritten, so paid and unpaid never both show
Stock counts	1C to Google Sheets	A few times an hour	Item, warehouse and quantity refreshed in place, so a formula above them always reads today's number
Prices	1C to Google Sheets	When they change in 1C	New items appear at the bottom, a price change rewrites the item's own row
Your columns stay yours	In Google Sheets	Always	We write the columns we set up; what you add to the right, your formulas and your filters are left alone
Duplicate check	1C to Google Sheets	Every document	Matched by document number, never a second row

How to set up 1C and Google Sheets

A few minutes of your time, then it's ours.

Choose 1C and Google Sheets

Press Connect. This pair is already selected on the checkout page at $79 a month, and there's nothing else to pick.
Pay and open your account

Card or invoice, about two minutes. The account opens with this integration waiting for its two keys.
3
Paste the 1C HTTP service address and the Google Sheets link
- 1C HTTP service address: ask your 1C administrator to publish the standard exchange HTTP service and create a user for it; you paste the address, the login and the password. Full 1C 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 seven minutes for both.
We check both keys

Each key is checked against 1C'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.
Post one test document, then we switch it on

A minute or two. Post a document in 1C and watch its row appear on the right sheet. From then on we watch it for you. A person checks the setup and switches it on, within a working day.

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

$79a month

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.

Ask us to connect it

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 1C and Google Sheets

Two ways people connect these two, and what each one asks of you.

Zapier or MakeDovetly

Who sets it upYou, one step at a time in the scenario editorAlready built. You paste two keys and we switch it on.

Who fixes it when it breaksYou: the scenario is yours, so the fix is tooWe do, within a working day, and we watch it

What you need to knowTriggers, actions, filters and how the fields of 1C and Google Sheets mapWhere the two keys are. The guide shows it.

PriceSet by the builder's plan, counted in tasks or operations$79 a month, flat, whatever the volume

Before you decide

Does anything get written back into 1C?

No. The books are read, never edited. That is the point of putting the numbers in a sheet: the people who need them stop asking for a screenshot, and nothing they do can change the accounting.

Who can see the sheet?

Whoever you share it with. Since it holds customer names and sums, most teams keep it shared with named people rather than with a link, and we work with either.

Anything to know about 1C?

1C has to answer over HTTPS through the standard exchange HTTP service; on an office server your administrator publishes it first.

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.