Send Qikify Product Options to Google Sheets - MESA
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.
How it works
4 steps to
start sending product options order details to Google Sheets automatically
Order Created
App connector: [Qikify Product Options](/content/apps/qikify-product-options/integrate "View Qikify Product Options integration page"/index.html)• 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.
Retrieve Shop
App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html)• 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.
Loop
App connector: [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html)• 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.
Add Row
App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• 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.
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.