From Olist Tiny to Google Sheets: managed, scheduled, no code.
Creating a pipeline that sends data from Olist Tiny to Google Sheets spreadsheets takes only a few minutes with Kondado. And the whole integration from Olist Tiny to Google Sheets is managed and executed by our platform. With Kondado, you can focus on extracting value from Olist Tiny data and combining it with other data in your Google Sheets spreadsheet
Sending Olist Tiny data to Google Sheets requires no coding or complex setup. Simply authenticate your Olist Tiny account within Kondado, select Google Sheets as your destination, and choose which pipelines to activate. You can replicate financial records, customer information, and inventory data directly into your spreadsheets without manual exports or CSV imports. The platform handles all data transformation and synchronization automatically.
Kondado replicates Olist Tiny ERP data to Google Sheets on a configurable schedule, automatically updating 15 pipelines with 792 fields including order details, accounts payable, and product stock levels, enabling teams to analyze ecommerce operations using familiar spreadsheet tools.
Once your data arrives in Google Sheets, you can analyze CRM Issues to track customer support tickets alongside sales performance, or monitor Accounts Payable and Accounts Receivable to maintain healthy cash flow visibility. The Order Details pipeline provides granular transaction data perfect for demand forecasting and sales trend analysis, while Product Stock information helps prevent inventory shortages across multiple channels. Teams can build custom dashboards using familiar formulas, create pivot tables for financial reconciliation, or share live reports with stakeholders without granting direct ERP access to external partners.
Try out all the features for free for 14 days
Replicated to Google Sheets
Olist Tiny 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 in the CRM.
CRM Issues Details
Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.
Accounts Payable
Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.
Accounts Receivable
Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.
Contacts
Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.
Accounts Payable Details
Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.
Accounts Receivable Details
Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.
Invoice Details
Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.
Invoice Details: XML
Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.
Order Details
Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.
Product Stock
Contains information about the available quantity of products, including fields such as id, product name, and stock balance.
Invoices
Records details of issued invoices, including fields such as id, issue date, and customer name.
Orders
Includes information about placed orders, with fields such as id, order date, and order status.
Products
Presents data about registered products, including id, name, and selling price.
Products: grid
Provides a grid view of products, with fields such as id, name, and category.
Answers about sending Olist Tiny data to Google Sheets automatically
How does Olist Tiny data replication to Google Sheets work?▼
Kondado connects directly to your Olist Tiny ERP using secure authentication, extracts data from your selected pipelines, and loads it into designated Google Sheets tabs. The platform handles data formatting automatically, ensuring that Brazilian currency formats, dates, and text fields display correctly in your spreadsheets without manual adjustment.
What specific business data from Olist Tiny can I replicate to Google Sheets?▼
You can replicate 15 distinct pipelines including Orders, Invoices, Accounts Payable, Accounts Receivable, Product Stock, and CRM Issues. Each pipeline contains specific fields such as order values, customer contact information, invoice XML data, and inventory balances across 792 total available fields for comprehensive business analysis.
How frequently does my Olist Tiny data update in Google Sheets?▼
Updates occur on a configurable schedule that you control, ranging from every 5 minutes for near-real-time monitoring to hourly or daily intervals for periodic reporting. You can set different frequencies for different pipelines, updating critical sales data more frequently while refreshing historical financial records less often.
Can I merge Olist Tiny data with other platforms in the same Google Sheet?▼
Yes, Kondado allows you to combine Olist Tiny data with other sources such as additional Google Sheets connections to marketing platforms, payment processors, or shipping carriers. This enables unified reporting where you can correlate ERP order data with advertising spend or delivery tracking information in a single spreadsheet.
Does Kondado offer pre-built dashboards for Olist Tiny data?▼
Yes, ready-made reports are available including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report templates. These provide immediate visualizations of your ERP data, though you can also send data to Google Sheets for custom analysis or to BigQuery for advanced data warehousing.
What format does Olist Tiny data take once it reaches Google Sheets?▼
Data arrives as structured rows and columns with preserved data types, where numeric fields remain calculable, dates maintain proper formatting, and text fields retain special characters. Each pipeline populates a separate sheet or tab within your workbook, with column headers matching Olist Tiny field names for easy reference and formula building.
Can I send Olist Tiny data to destinations other than Google Sheets?▼
Absolutely, while Google Sheets offers collaborative spreadsheet analysis, you can also replicate data to BigQuery for large-scale storage, PostgreSQL for database applications, or business intelligence tools like Power BI and Looker Studio for advanced visualization.
'%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)
