No-code pipeline · Tray → Google Sheets

Send data from Tray 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

From Tray to Google Sheets: managed, scheduled, no code.

Creating a pipeline that sends data from Tray to Google Sheets spreadsheets takes only a few minutes with Kondado. And the whole integration from Tray to Google Sheets is managed and executed by our platform. With Kondado, you can focus on extracting value from Tray data and combining it with other data in your Google Sheets spreadsheet

Connect Tray now →

Send Tray Data to Google Sheets Automatically

How to send Tray data to Google Sheets? Kondado connects your Tray store to Google Sheets, replicating your eCommerce data on a configurable schedule. Simply add Tray as a data source, select Google Sheets as your destination, and choose which pipelines to replicate. Your data flows automatically every 5 minutes, hourly, or daily based on your business needs, keeping your spreadsheets current without manual exports. Once connected, you can analyze sales performance, track inventory levels, and monitor customer behavior directly in your familiar spreadsheet environment.

Kondado replicates 14 pipelines from Tray to Google Sheets, including Customers, Orders, Payments, Products, and Sold Products, updating automatically on user-defined schedules ranging from 5 minutes to daily intervals.

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

With the Orders pipeline flowing into your spreadsheets, you can build custom dashboards tracking order volumes and delivery status alongside your marketing metrics. The Sold Products pipeline brings detailed sales performance data including quantities and order IDs, enabling you to identify top-performing SKUs and optimize inventory decisions. Combine these with Customer data to segment your audience and personalize outreach strategies, all within the collaborative environment of Google Sheets.

Try out all the features for free for 14 days

Replicated to Google Sheets

Tray data available for Google Sheets

Tables Kondado writes into your Google Sheets, on a schedule you control.

available pipelines

328

extractable fields

Google Sheets

Destination

Available integrations

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

See all available data → Send Tray to Google Sheets →

Try out all the features for free for 14 days

How to send Tray data to Google Sheets

Sync data automatically — no code, no manual exports.

Add Tray as data source

Enter your Tray store credentials in Kondado to establish the connection and authorize access to your eCommerce data. The platform will automatically detect available pipelines including Orders, Products, and Customers.

Set up Google Sheets destination

Select Google Sheets as your destination and specify the target workbook where your Tray data will land. You can use an existing spreadsheet or create a new one directly from the Kondado interface.

Choose pipelines and schedule

Select which of the 14 Tray pipelines to replicate, such as Sold Products or Order Invoices, and configure your update frequency from 5 minutes to daily. Kondado will begin replicating data immediately based on your selected schedule.

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

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Tray to other destinations

Tray > Looker Studio

Tray > Power BI

Other visualizations

Tray > Amazon S3

Tray > BigQuery

Tray > Excel

Tray > Google Sheets

Tray > MySQL

Tray > PostgreSQL

Tray > Redshift

Tray > SQL Server

Choose a tool to visualize your Tray data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Tray > Airtable

Tray > Alteryx

Tray > Amazon Quicksight

Tray > BIMachine

Tray > Cortex

Tray > Data Studio

Tray > Geckoboard

Tray > Grafana

Tray > IBM Cognos Analytics

Tray > Klipfolio

Tray > Looker Studio

Tray > Looker

Tray > Looqbox

Tray > Metabase

Tray > Microstrategy

Tray > Pentaho

Tray > Power BI

Tray > Qlik Cloud Analytics

Tray > Qlik Sense

Tray > Qlik

Tray > QlikView

Tray > Redash

Tray > Superset

Tray > Tableau

Tray > BI TOTVS

Tray > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Tray data to Google Sheets automatically

How does Tray data appear in Google Sheets after replication? ▼

Each pipeline becomes a separate tab within your Google Sheets workbook, with column headers matching Tray field names such as order_id, customer_email, or product_name. Data arrives in a structured format ready for pivot tables, VLOOKUP functions, and chart creation without additional cleaning or transformation steps.

What Tray eCommerce data can I replicate to Google Sheets? ▼

You can replicate 14 distinct pipelines covering your entire operation, including Orders, Sold Products, Payments, Discount Coupons, and Order Details specific to Mercado Livre. Each pipeline contains relevant fields such as transaction values, inventory IDs, customer registration dates, and invoice details for comprehensive business analysis.

How often does Kondado update Tray data in Google Sheets? ▼

Kondado updates your spreadsheets on a configurable schedule that you control, with options ranging from every 5 minutes for near-real-time monitoring to hourly or daily intervals for periodic reporting. You can adjust these frequencies per pipeline based on how frequently specific data changes in your Tray store.

Can I combine Tray data with other sources in the same Google Sheet? ▼

Yes, Kondado supports sending data from multiple sources into the same Google Sheets destination, allowing you to blend Tray eCommerce metrics with information from additional platforms in one workbook. You can also route your Tray data simultaneously to Power BI, Looker Studio, or BigQuery while maintaining your Google Sheets connection for different analytical needs.

Does Kondado support Mercado Livre order data from Tray? ▼

Yes, the Order Details: Mercado Livre pipeline specifically extracts marketplace-specific information including estimated delivery dates, customer IDs, and product details from your Mercado Livre sales through Tray. This allows you to track marketplace performance separately from your main store orders within the same spreadsheet.

What can I build with Tray data in Google Sheets? ▼

You can construct custom sales dashboards tracking revenue trends, create inventory management systems using Products and Products: Variants pipelines, and build customer segmentation reports by analyzing registration dates and purchase histories. These spreadsheets can serve as data sources for Looker Studio reports or be shared across teams for collaborative planning.

How do I connect my Tray store to Google Sheets using Kondado? ▼

Start by adding Tray as a data source in your Kondado account using your store credentials, then select Google Sheets as the destination and authorize access to your preferred workbook. Finally, select which of the 14 available pipelines to replicate and set your preferred update schedule to begin automated data flow.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days