↔
Reports and stock from 1С/BAS are refreshed in Google Sheets on a schedule, and rows added by the team in a shared sheet come back to 1С/BAS as documents
The accounting is in 1С/BAS, but the team works in Google Sheets: the sales board, the shipment plan, the list of requests from the field. Every week somebody exports numbers from 1С/BAS into a sheet, and every evening somebody types rows from a sheet back into 1С/BAS. The 1С/BAS ↔ Google Sheets pair removes both manual steps: report and stock tables are rewritten from 1С/BAS on a schedule, and rows that people add in agreed sheets become orders, requests or counts in 1С/BAS. Below: what exactly moves, which scenarios we cover and which capabilities of both systems we rely on.
Before the sales board in Google Sheets is updated by hand from 1С/BAS on Fridays, so on Thursday the team argues with numbers from last week.
After the board is rewritten from 1С/BAS every morning, and the meeting starts with today's figures.
Before a Google Form drops requests into a sheet, and someone remembers to move them into 1С/BAS twice a week.
After every new row becomes a customer request in 1С/BAS within minutes, and the manager sees it in the morning list.
Before the planner keeps the shipment plan in a sheet and messages the warehouse about every order to find out if it is assembled.
After statuses from 1С/BAS appear next to each row of the plan, and the chat goes quiet.
Before field managers write orders into a shared sheet from the phone, and the operator retypes them into 1С/BAS in the evening.
After each row becomes a customer order in 1С/BAS, and the document number is written back into the row.
For those who want to check: each point links to the official documentation page it comes from.
The official BAS support portal documents its integration technologies under the title «Технології інтеграції 1С:Підприємства 8.3» — BAS is built on the 1C:Enterprise 8.3 platform.
Source: its.bas-soft.eu ↗ checked 2026-09-25According to the same documentation, the platform automatically builds a REST interface using the OData protocol, through which outside systems can read, change, create and delete data over HTTP.
Source: its.bas-soft.eu ↗ checked 2026-09-25The Google Sheets API is an official interface that lets a program read and modify a spreadsheet's data.
Source: developers.google.com ↗ checked 2026-09-27Spreadsheet IDs are stable, even if the spreadsheet name changes — renaming the file does not break the connection.
Source: developers.google.com ↗ checked 2026-09-27Sheets API quotas are per minute and refill every minute; Google's own example is a read limit of 300 requests per minute per project.
Source: developers.google.com ↗ checked 2026-09-27A service account is a special kind of account used by an application rather than a person; access to a specific Google Sheet is granted by sharing the file or folder with the service account's email address.
Source: developers.google.com ↗ checked 2026-09-27The limits come from both systems. Google Sheets does not report a new row by itself, so rows reach 1С/BAS on a schedule of minutes, not instantly. Google counts requests per minute, so a very large report is written in batches, and a sheet with hundreds of thousands of rows is better replaced by a filtered one. A row edited by hand after it became a document is not changed in 1С/BAS backwards: corrections are made in 1С/BAS. 1С/BAS is on the official prohibited software list: we do not take projects for state bodies, critical infrastructure or systems with state data, and with private businesses we discuss the risk openly.
Three steps from a first message to work on your project.
Describe the task in the form — in text or by voice. Budget and timing are optional.
A developer studies the brief, asks about anything unclear and sends an estimate.
Once scope and price are agreed, the work begins.
or write to info@coreviaflow.space
Describe the task in text or a voice message. We look at your setup and reply with a plan.
Four services people come to us for most often. Each page explains what we do, how the work goes and where to start.
Choose the system, set up the pipeline, migrate data, train the team.
Learn more →Accounting, telephony, website, payments and messengers feed the CRM on their own.
Learn more →Orders, requests and answers around the clock, straight into your CRM.
Learn more →Flows between CRM, email, spreadsheets, payments and AI, on your own server.
Learn more →Accounting & ERPUAAlready running your accounting in 1С/BAS? We automate the work around it
See scenarios →Automation & workspaceUSThe spreadsheet your team already lives in: leads flow from a Google Sheet into your CRM, reports flow back into the sheet, and nobody copies rows by hand
See scenarios →↔
Reports, price lists and stock from 1С/BAS land in Excel workbooks by themselves, and rows filled in by managers in Excel come back to 1С/BAS as documents
See scenarios →↔
An AI agent on Claude reads the data in 1С/BAS, answers questions about debts and stock, and prepares documents for the accountant to confirm
See scenarios →↔
Your Telegram bot takes orders and answers «where is my order» from 1С/BAS, and the owner gets debts, stock and daily totals in the chat
See scenarios →↔
A won deal in Bitrix24 becomes a sales document in 1С/BAS, and stock, payments and shipments from 1С/BAS come back to the deal
See scenarios →Implementation · Development · Integrations →
1С/BAS ↔ Google Sheets — the system names are trademarks of their owners. CoreviaFlow is not affiliated with them unless stated otherwise.
