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 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 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 |
Ten minutes of your time, then it's ours
- Pay and open your accountCard or invoice, about two minutes. This integration is already selected.
- Paste the 1C HTTP service address and the Google Sheets linkEach has a short guide. About seven minutes. If one doesn't work, a person joins the chat.
- Post one test documentA 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.
When 1C 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, replies within a working hour.
- Custom logic beyond the table is priced separately.
No setup fee, cancel any month
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 the same day and build into the same account.
