How does the Tiny ERP to Google Sheets pipeline work?

Kondado connects directly to your Tiny ERP account and extracts data from selected pipelines, then loads it into designated Google Sheets spreadsheets on your chosen schedule. The process requires no coding: you authenticate your Tiny ERP data source, specify which pipelines to replicate, and configure how frequently the information should refresh.

What Tiny ERP data can I replicate to Google Sheets?

You can replicate 15 different pipelines including Accounts Payable, Accounts Receivable, Orders, Product Inventory, CRM Issues, Contacts, and Invoice Details. Each pipeline contains specific fields such as financial amounts, dates, customer information, and product details, providing comprehensive coverage of your ecommerce, retail, or service operations.

How often does Tiny ERP data update in Google Sheets?

Updates occur on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals depending on your business needs. This ensures your spreadsheets contain current information without overwhelming your systems with unnecessary API calls or manual export processes.

Can I combine Tiny ERP data with other sources in Google Sheets?

Yes, you can blend Tiny ERP data with information from other Kondado sources sent to the same spreadsheet, or use Google Sheets functions to merge datasets manually. This allows you to create unified views combining your ERP financial data with marketing analytics, inventory systems, or custom databases for comprehensive business intelligence.

What format does Tiny ERP data arrive in within Google Sheets?

Data arrives as structured rows and columns with fields corresponding to Tiny ERP data points such as ids, dates, monetary values, and status indicators, ready for immediate analysis using pivot tables, charts, or formulas. Each pipeline populates separate sheets or ranges within your workbook, maintaining data relationships and enabling you to build custom reports that reference multiple pipelines.

Are there reports available for Tiny ERP data?

Yes, Kondado offers ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report that you can use alongside your Google Sheets data. These templates provide immediate visualization capabilities for your replicated data, and you can also send information directly to Looker Studio or Power BI if you prefer dedicated business intelligence platforms over spreadsheet analysis.

Can I track specific financial metrics like cash flow in Google Sheets?

By replicating the Accounts Payable and Accounts Receivable pipelines, you can build custom cash flow trackers that calculate outstanding balances, payment due dates, and historical trends directly in your spreadsheet. This enables finance teams to monitor liquidity without accessing the ERP system, creating automated alerts and forecasts using familiar Google Sheets formulas and conditional formatting.

Send data from Tiny ERP to Google Sheets

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Send Tiny ERP Data to Google Sheets

Kondado enables businesses to replicate data from Tiny ERP to Google Sheets on a configurable schedule, eliminating manual exports and ensuring your spreadsheets always contain current information for analysis and reporting. Whether you manage online stores, retail operations, or service workflows, this pipeline keeps your financial and operational data synchronized without requiring technical expertise or custom development. You can set up automated data flows in minutes and start working with live business metrics directly in your preferred spreadsheet environment.

Teams can access refreshed data directly in Google Sheets, enabling faster decision-making and collaborative workflows across departments without switching between multiple systems or waiting for IT resources to build complex connections. This approach ensures that sales figures, inventory levels, and financial records stay current and accessible to everyone who needs them, from agency analysts to operations managers.

Kondado automatically replicates Tiny ERP data to Google Sheets on a configurable schedule, supporting 15 pipelines including Accounts Payable, Orders, Product Inventory, and CRM Issues across 792 fields, with updates available every 5 minutes, 15 minutes, hourly, or daily.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Once your data arrives in Google Sheets, you can analyze the Accounts Receivable pipeline to track outstanding balances and cash flow trends without logging into Tiny ERP. The Product Inventory pipeline enables dynamic stock monitoring, allowing you to create custom dashboards that reflect current business conditions as your data refreshes on schedule. You can also combine this information with the Orders pipeline to analyze sales velocity against stock levels, ensuring you never miss revenue opportunities due to inventory shortages while maintaining optimal financial oversight.

Try out all the features for free for 14 days

Tiny ERP data available for Google Sheets

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable	Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable	Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts	Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details	Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details	Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details	Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory	Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices	Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders	Table lists the orders placed, including fields such as order id, order date, and status.
Products	Table presents information about products, with fields such as id, name, and price.
Product Grid	Table provides a detailed grid of products, including fields such as id, description, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.

Accounts Payable

Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.

Accounts Receivable

Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.

Contacts

Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.

Accounts Payable Details

Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.

Invoice Details

Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.

Order Details

Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.

Product Inventory

Table provides information about inventory, including fields such as id, product name, and available quantity.

Invoices

Table contains details of invoices, featuring fields such as id, issue date, and customer name.

Orders

Table lists the orders placed, including fields such as order id, order date, and status.

Products

Table presents information about products, with fields such as id, name, and price.

Product Grid

Table provides a detailed grid of products, including fields such as id, description, and category.

See all available data →

Try out all the features for free for 14 days

How to send Tiny ERP data to Google Sheets

Sync data automatically — no code, no manual exports.

Connect Tiny ERP

Authenticate your Tiny ERP data source in Kondado by providing your API credentials, allowing the platform to access your ecommerce, financial, and operational records.

Configure Google Sheets Destination

Select Google Sheets as your destination and specify the target spreadsheet where your Tiny ERP data should load, ensuring proper permissions are set for collaborative access.

Select Pipelines and Schedule

Choose from 15 available pipelines such as Orders, Product Inventory, or Accounts Receivable, then set your preferred update frequency ranging from every 5 minutes to daily intervals.

Try out all the features for free for 14 days