From Tiny ERP to Google Sheets: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to Google Sheets spreadsheets takes only a few minutes with Kondado. And the whole integration from Tiny ERP to Google Sheets is managed and executed by our platform. With Kondado, you can focus on extracting value from Tiny ERP data and combining it with other data in your Google Sheets spreadsheet
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.
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
Replicated to Google Sheets
Tiny ERP data available for Google Sheets
Tables Kondado writes into your Google Sheets, on a schedule you control.
15
available pipelines
792
extractable fields
Google Sheets
Destination
Available integrations
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.
Sync data automatically — no code, no manual exports.
1
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.
2
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.
3
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
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Tiny ERP data to Google Sheets automatically
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.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
