From VTEX to Google Sheets: managed, scheduled, no code.
Creating a pipeline that sends data from VTEX to Google Sheets spreadsheets takes only a few minutes with Kondado. And the whole integration from VTEX to Google Sheets is managed and executed by our platform. With Kondado, you can focus on extracting value from VTEX data and combining it with other data in your Google Sheets spreadsheet
Kondado provides a direct integration between VTEX and Google Sheets, allowing you to replicate your e-commerce data automatically without writing code. Simply select your VTEX data source, choose the specific pipelines you need from the 17 available options covering orders, inventory, and promotions, and configure how often you want your spreadsheets updated. The platform handles all data extraction and loading, ensuring your Google Sheets contain accurate VTEX information for immediate analysis.
Your order details, inventory levels, and promotional data flow directly into Google Sheets on a configurable schedule, ready for analysis and reporting by your entire team. Once configured, your spreadsheets stay current with automated updates, enabling you to build dynamic reports and share business insights across your organization without manual data exports or CSV downloads.
Kondado automatically replicates data from 17 VTEX pipelines including Orders, Stock, Coupons, and SKUs to Google Sheets on a configurable schedule ranging from every 5 minutes to daily, requiring no technical setup or API programming while maintaining data accuracy across 432 available fields.
Replicate your Orders pipeline to track sales performance and order status changes directly in your spreadsheets, enabling you to create custom sales dashboards and monitor revenue trends without accessing the VTEX admin panel. Combine Stock pipeline data with Google Sheets formulas to build automated inventory alerts and reorder point calculations that prevent stockouts, while the Marketing Data of Orders pipeline allows your team to analyze campaign attribution and calculate ROAS using familiar spreadsheet functions. This direct pipeline access transforms your spreadsheets into powerful analytical tools that update automatically with fresh VTEX data.
Try out all the features for free for 14 days
Replicated to Google Sheets
VTEX data available for Google Sheets
Tables Kondado writes into your Google Sheets, on a schedule you control.
17
available pipelines
432
extractable fields
Google Sheets
Destination
Available integrations
Coupons
Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock
Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data
Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders
Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders
Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders
Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details
Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders
Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items
Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions
Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits
Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals
Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products
Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions
Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs
Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits
Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices
Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.
Sync data automatically — no code, no manual exports.
1
Connect VTEX on Kondado
Access the VTEX data source in Kondado and enter your store credentials to establish the connection. The platform will authenticate your account and display the 17 available pipelines containing your e-commerce data.
2
Configure Google Sheets
Select Google Sheets as your destination and specify the workbook where your VTEX data should land. You can choose to create new sheets or append data to existing workbooks already shared with your team.
3
Select Data and Schedule
Choose the specific pipelines you need from the 17 VTEX options, such as Orders or Stock, and set your update frequency from every 5 minutes to daily. Kondado will begin replicating your selected data automatically according to your configured 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
Answers about sending VTEX data to Google Sheets automatically
How does Kondado replicate VTEX data to Google Sheets?▼
Kondado connects to your VTEX account through a direct integration, extracting data from your selected pipelines and loading it into designated Google Sheets workbooks. You configure which specific data points you need from the 17 available pipelines, and the platform updates your spreadsheets automatically on your chosen schedule without requiring any coding or API management.
What VTEX data can I replicate to Google Sheets?▼
You can replicate data from 17 different pipelines including Orders, Stock, Coupons, SKUs, Master Data, and Marketing Data of Orders, encompassing 432 total fields. This covers everything from order details and shipping information to inventory levels and promotional campaign data, giving you complete visibility into your e-commerce operations within your spreadsheets.
How often does VTEX data update in Google Sheets?▼
Kondado updates your Google Sheets on a configurable schedule that you control, with options ranging from every 5 minutes to daily updates depending on your business needs. This automated refresh ensures your reports and analyses always reflect the current state of your VTEX store without manual data exports.
Does Kondado offer pre-built dashboards for VTEX data?▼
Yes, Kondado provides ready-made report templates including the VTEX Power BI Report and VTEX Looker Studio Report that you can deploy immediately. While these templates work with Power BI and Looker Studio, you can also send the same data to Google Sheets to build custom spreadsheet-based reports tailored to your specific KPIs.
Can I combine VTEX data with other sources in Google Sheets?▼
Absolutely, Kondado allows you to replicate data from multiple sources into the same Google Sheets workbook, enabling you to blend VTEX order information with data from PostgreSQL, BigQuery, or other platforms. This unified approach lets you create comprehensive reports that correlate your e-commerce metrics with financial, CRM, or inventory management data from across your technology stack.
How is VTEX data formatted in Google Sheets?▼
Each VTEX pipeline becomes a separate sheet or tab within your Google Sheets workbook, with data organized in columns corresponding to the specific fields you selected during setup. The platform preserves data types and structure, allowing you to immediately apply filters, pivot tables, and formulas to your Orders, Stock, or SKUs data without additional cleaning or transformation steps.
What do I need to start sending VTEX data to Google Sheets?▼
You need active credentials for your VTEX store and a Google account with access to Google Sheets to begin replicating data. Once connected, you simply select your desired pipelines from the 17 available options, choose your update frequency, and specify which workbook should receive the data, with no technical implementation or engineering resources required.
'%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)
