BeLazy Technologies Ltd.

Google Sheets is a cloud-based spreadsheet tool by Google, widely used for data tracking, reporting, and collaboration. BeLazy offers built-in support for Google Sheets: 

• if you are using a commercial business management system or connected your own, it enables outcome-based reporting and support for simplifying the project management of continuous localization projects,
• if you are not using a commercial business management system, Google Sheets offers a ready-to-use business operations system that requires no custom development and is configured entirely through the BeLazy interface.

All projects and jobs received from connected source systems are automatically synchronized into a structured spreadsheet, including financial data, analysis, vendor information, and connector-specific metadata.

Use cases:

The Google Sheets BMS is a good fit if one or more of the following apply to your situation:

• You are a translation company or language department that does not see the need for a commercial BMS, or is looking for a lightweight alternative for simpler workflows.
• You want to track projects and jobs from multiple source systems in a single view without building a custom integration.
• You want business intelligence reporting such as charts, pivot tables, filtering, and custom views using Google Sheets' built-in tools, applied to your live translation project data.
• You want to implement outcome-based reporting for your own use or your customer's use using external tools such as PowerBI, Looker Studio, Tableau, Domo, etc., and therefore you want connector- and customer-specific metadata from your source systems to be captured automatically as extra columns in the spreadsheet, without manual configuration.
• You want to use BeLazy's built-in vendor selection and cost calculation capabilities, powered by the price lists and fuzzy schemes you maintain in the spreadsheet.

The Google Sheet BMS capabilities boost your reporting capabilities, and enable very simple and efficient project management for small projects, synchronizing vendor assignments and job status changes with both your translation management system and with your business management system (if there is one).

Google Sheet is also very extensible: you can easily create new automations using Google App Script. Due to the data view simplification and data normalization performed by BeLazy, LLMs like Claude, Gemini or ChatGPT can create working scripts within minutes to connect the sheet to the various tools you use, or help you implement advanced vendor assignment capabilities.

How to use:

BeLazy maintains one comprehensive Google Sheet structure rather than making it configurable. Different roles in the organization need different information, and a filtered view of projects and jobs. You can use the IMPORTRANGE and QUERY (or FILTER) commands to build tailor-made sheets for every project manager. You can also offer certain projects for self-claiming to linguists, saving the work of vendor assignment for the project managers.

Integration type:

The Google Sheets BMS is a native, built-in BeLazy capability. BeLazy communicates with Google Sheets using the official Google Sheets API and authenticates using OAuth 2.0. You authorize BeLazy to access your Google account through the BeLazy interface. No development work is required on your side.

Requirements:

• A Google account with access to Google Drive and Google Sheets.
• Authorization of BeLazy to access Google Sheets via OAuth. This is done through the BeLazy interface during setup.

Setting up Google Sheets as your BMS:

Navigate to Profile menu → Google Sheets integration, and turn on the Google Apps Script API on your Google account that you want to connect. The interface gives you a direct link where you can do this. Then connect your Google account. After completing the OAuth authorization flow, click on Create spreadsheet. BeLazy creates a new spreadsheet in your Google Drive with all required tabs, headers, formatting, and built-in scripts pre-configured. Open the spreadsheet with the button, and select Initialize BeLazy triggers from the Translation tools menu in your Google Sheet, and perform the necessary authentication. Go to the User guide tab (last tab in the spreadsheet) and perform the Getting started steps. The spreadsheet is ready to use.

Important: Due to how Google Sheets work, please ensure that you are only logged in with one Google account into Google. If you can switch accounts in your browser, the spreadsheet may not work correctly.

Sync modes:

• Full sync: Clears all data from the spreadsheet and rewrites it from scratch. Use this when you want to reset the state, for example, after changing connection configuration or mapping rules. Full sync can be triggered manually from the BeLazy interface.
• Incremental sync: Computes a row-level diff based on content hashes and applies only the changes: new rows are added, changed rows are updated, removed rows are deleted. Incremental sync runs automatically on a schedule and is the standard day-to-day sync mode.
• Event-driven sync: Triggered by individual BMS project events (such as a new project being accepted, a job being updated, or a project being closed). Only the rows belonging to the affected BMS project are updated. This provides near-real-time synchronization without the overhead of a full scan.

Spreadsheet structure:

The spreadsheet created by BeLazy contains the following tabs:

The Vendors, Price lists, and Fuzzy schemes tabs are yours to manage. BeLazy will never overwrite the data you enter there. This is intentional: your pricing agreements and vendor capabilities change independently of your project data.

Extra data columns:

Many source system connectors extract connector-specific metadata fields that go beyond BeLazy's standard set of unified fields. BeLazy automatically captures these fields and appends them as dynamic columns to the Project extra data and Job extra data tabs.

The column set is determined at sync time: BeLazy discovers all fields present across your current projects and jobs, merges them with any previously known columns, and writes them in a stable order. New fields are always appended to the right — existing columns never move. This ensures that any formulas, charts, or integrations referencing existing columns continue to work without adjustment.

Semantically equivalent fields from different connectors are automatically merged into a single column (for example, fields named description, brief_description, and project_description in different connectors all map to a single description column).

Built-in scripts:

The spreadsheet includes a Translation tools menu, powered by built-in Google Apps Scripts that BeLazy installs automatically:

• Select vendor: Select any cell in a job row in the Jobs tab and run this script. It filters the Vendors tab to find vendors whose supported languages and work types match the job, calculates the cost for each based on their assigned price list and fuzzy scheme, and presents the results in a dialog. Clicking a vendor assigns them to the Vendor column of the job row.
• Show my jobs: Creates a personal tab named Jobs for [your name] containing only the jobs where you are the project manager. The tab is recreated fresh each time you run this action.
• Initialize BeLazy triggers: Sets up an onEdit trigger that automatically records vendor assignments made via the Select vendor script. Run this once after opening the spreadsheet.

Functionality supported:

• Projects tab: one row per BeLazy project; covers the full standard project metadata
• Jobs tab: one row per job; linked to projects via the Project ID column
• Dropdowns for project managers, customers, languages, and work types, validated against the reference tabs
• Vendor management with supported languages, work types, and price list assignment
• Price lists with fuzzy scheme integration and per-word, per-character, per-page, and per-hour pricing support
• Analysis data for TM match band cost calculation in the Select vendor script
• Dynamic extra data columns for connector-specific fields from any source system
• BI reporting: use Google Sheets' built-in charts, pivot tables, filters, and formulas on live project data
• Role-based views via the Show my jobs script

Important:

• One Google Sheets BMS is supported per BeLazy organization. If you switch to a different BMS later, the spreadsheet will remain in your Google Drive but will no longer be updated.
• On first sync, the Vendors tab is populated with the vendor names and emails from your BeLazy account. All other vendor fields (capabilities, price list, notes) must be filled in manually before the Select vendor script can calculate meaningful results.
• The multi-selection dropdowns for target languages, supported languages, and price list target languages must be enabled manually once after the spreadsheet is created. The User guide tab in the spreadsheet contains the exact steps.
• The built-in scripts require the Initialize BeLazy triggers action to be run once per Google account to enable automatic vendor assignment tracking.