How do I connect Tiny ERP to Data Studio using Kondado?

Start by adding Tiny ERP as a new data source in your Kondado account and authenticate with your existing credentials. Then select Looker Studio as your destination, choose which pipelines to replicate, and your data will be available for visualization within minutes.

How often does Tiny ERP data update in my Data Studio dashboards?

You configure the update frequency based on your business needs, choosing from intervals as frequent as every 5 minutes or longer periods like hourly or daily. This configurable schedule ensures your dashboards reflect recent transactions, inventory changes, and financial updates without manual intervention.

What business KPIs can I track by visualizing Tiny ERP data?

You can monitor sales velocity from the Orders pipeline, track inventory turnover using Product Inventory data, and analyze cash flow health through Accounts Receivable and Accounts Payable pipelines. These metrics help you identify bestselling products, manage stock levels, and optimize payment collection strategies.

Are there pre-built dashboard templates 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. These templates provide immediate visualizations for common ecommerce and financial metrics, allowing you to start analyzing your data without building dashboards from scratch.

Can I share Tiny ERP dashboards with my team members who don't have Kondado access?

Once your data is in Looker Studio , you can share reports using the platform's standard collaboration features, granting view or edit access to colleagues. Your team members can interact with filters and date ranges without needing direct access to Kondado or your Tiny ERP account.

What specific Tiny ERP information can I visualize in Data Studio?

You can replicate data from 15 different pipelines including Orders, Invoices, Product Inventory, Accounts Receivable, Accounts Payable, and CRM Issues. This covers your complete ecommerce operation from sales transactions and customer service records to financial management and stock control.

Do I need programming skills to replicate Tiny ERP data to Data Studio?

No coding is required to establish the connection or configure your data replication. Kondado provides a no-code interface where you simply select your data source, choose your destination, and pick which pipelines to replicate using point-and-click configuration.

Connect Tiny ERP to Data Studio: Dashboards in Minutes

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

Visualize Tiny ERP Data in Data Studio with Kondado

Kondado makes it simple to visualize Tiny ERP data in Data Studio without technical complexity or manual exports. You connect your Tiny ERP account as a data source, choose which business information to replicate, and send it directly to Data Studio in minutes. The setup requires no coding knowledge, no intermediate databases, and no IT support, allowing business teams to start analyzing their ecommerce and financial data immediately.

Kondado provides a direct connection between Tiny ERP and Data Studio, offering 15 pre-built pipelines with 792 fields that update on a configurable schedule to keep your business reports current and accurate.

Once connected, you can build comprehensive dashboards that combine sales transactions, inventory levels, and customer information to make informed decisions about your online store or retail operations. The automated data refresh ensures your visualizations always display the latest orders, payments, and product availability without requiring manual updates or spreadsheet exports.

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

With Kondado, you can combine data from Accounts Receivable, Orders, and Product Inventory pipelines to create unified views of your business performance in Data Studio. Track which products are selling fastest while monitoring cash flow from pending payments, all within interactive dashboards that update automatically. Marketing teams can analyze customer purchase patterns from the Orders pipeline alongside CRM Issues data to identify service trends and optimize the shopping experience. Financial managers gain clear visibility into accounts payable and receivable aging, enabling better cash management decisions without waiting for manual report generation.

Try out all the features for free for 14 days

Tiny ERP data available in Data Studio

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

Discover our Tiny ERP report in Data Studio

How to create Tiny ERP dashboards in Data Studio

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Tiny ERP as Data Source

Log into Kondado and add Tiny ERP as a new data source, then authenticate your account to establish the connection. Select the specific pipelines you want to replicate, such as Orders, Invoices, or Product Inventory.

Select Looker Studio Destination

Choose Looker Studio as your destination to begin visualizing your Tiny ERP data immediately. You can also send data to Google Sheets or BigQuery if your team uses multiple analytics tools.

Configure Refresh and Visualize

Set your preferred update frequency to keep reports current, then start building dashboards that combine sales, inventory, and financial data. Your visualizations will update automatically based on the schedule you configured.