Send Qikify Product Options to Google Sheets

5 min setup
No coding required
Runs automatically

Track customer product options by automatically sending Qikify product option selections to Google Sheets. Every time a customer picks size, color, engraving text, or other options, their choices appear in your spreadsheet instantly. Perfect for inventory planning, production scheduling, and understanding which customizations drive the most sales. Leave the template as-is to capture all orders containing any line item properties, or filter for specific line item properties in the trigger if you only want the workflow to run for certain options.

qikify logo icon
Order Created
Loop
google sheets logo icon
Add Row

How it works

4 steps to start sending product options order details to Google Sheets automatically

qikify logo icon

Order Created

App connector: Qikify Product Options • Time to complete: 0 minutes (Auto-configured)
Why this matters: This trigger activates the workflow whenever a new order containing Qikify product options is placed, ensuring you capture all customized orders without manual monitoring.

This step automatically detects when customers complete orders that include Qikify product customizations like text fields, dropdown selections, or file uploads. The trigger captures the complete order data including customer information, shipping details, and all line items with their custom options. No configuration is required - it runs in the background and passes the order data to subsequent steps for processing.

Retrieve Shop

App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This step pulls your store's domain information which is needed to create properly formatted admin links to orders in your spreadsheet.

The workflow automatically connects to your Shopify store to retrieve shop details, particularly your myshopify domain name. This information gets used to generate clickable admin URLs in your spreadsheet so you can quickly access order details in Shopify. The step runs automatically using your connected Shopify account credentials and requires no manual input from you.

Loop

App connector: Loop • Time to complete: 0 minutes (Auto-configured)
Why this matters: This loop processes each individual product in the order separately, creating one spreadsheet row per item rather than cramming everything into a single row.

The loop iterates through every line item in the order, handling each product and its custom options individually. For orders with multiple products, this ensures each item gets its own dedicated row in your spreadsheet with complete details. The loop automatically processes the line items data structure and makes individual product information available to the next step for spreadsheet creation.

google sheets logo icon

Add Row

App connector: Google Sheets • Time to complete: 2 minutes
Why this matters: This creates the actual spreadsheet rows with your order data, organized exactly how you specified during setup with one row per product purchased.

This step adds a new row to your Google Sheets spreadsheet for each product processed by the loop. You'll configure which columns to include during setup - options include Order URL, Order Name, Email, Shipping Name, Address, City, State/Province, Zip/Postal Code, Country, Product Name, Product SKU, and Product Price. The spreadsheet gets created automatically with your chosen name if it doesn't exist, and new rows are added to the "Sheet1" tab for each order processed.

Trusted by 1,000+ Shopify merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to start sending product options order details to Google Sheets automatically

Get setup in 5 minutes.

Try this template →

Frequently asked questions

Will this create a separate row for each product in multi-item orders?

Yes, the Loop step processes each line item individually, so if someone orders 3 different customized products, you'll get 3 separate rows in your spreadsheet - one for each product with its own custom options and pricing details.

Can I capture the actual custom text and options customers entered through Qikify?

The workflow captures the core order and product data, but specific Qikify customization details may require additional configuration. You can extend the template to include custom properties and metafields where Qikify stores the personalization data.

What happens if my Google Sheets spreadsheet reaches the row limit?

Google Sheets supports up to 10 million cells per spreadsheet. If you approach this limit, consider creating monthly or quarterly spreadsheets by modifying the spreadsheet name to include date variables, or set up a secondary workflow to archive older data.

Make this template your own!

Customize this workflow even further:

Set custom filters for specific products
Add conditions to only track orders containing certain SKUs, product types, or price ranges, perfect for monitoring high-value custom items or specific product lines.
Connect fulfillment notifications
Extend the workflow to automatically send email notifications to customers when their custom orders are ready for pickup or shipment, using the order data already captured.
Store detailed custom options data
Save the specific customization details (text inputs, color selections, file uploads) from Qikify into separate columns or a dedicated database table for quality control and production reference.
Deploy AI agents for custom order routing
Let AI agents analyze the custom options and automatically route orders to different fulfillment teams or suppliers based on the complexity or type of customization requested.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

Ready to start sending product options order details to Google Sheets automatically?

7-day free trial • 5 min setup • Cancel anytime

Need help? Our automation experts will help you personalize this workflow for free. Contact support