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.

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

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

Tray data available for Google Sheets

available pipelines

328

extractable fields

Available integrations

Integration	Description
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.

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 →

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