Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Can Zapier automate exporting items sales in Square to Google sheets? I want to automate not manually export.

Hi ​@dtaylor252 

Review the available Zap app triggers/actions: 

Square: 

GSheets:

 

Hi Troy, thanks. I don’t see the capability but not sure if I’m missing something.

​@dtaylor252 

Try this Zap trigger: Square - New Order

Orders usually have line items.

 

I tried these before posting this question. I don’t see anything about “item sales” 

I need order date, item qty, item name, item sku, item modifiers, item total price

is that possible?

​@dtaylor252 

An Order will have 1+ Line Items.

The Square Zap app integrations is based on the Square API.

Square API for ORDERS, shows LINE ITEMS  as part of the output for an Order.

Each LINE ITEM in an ORDER will have the data points you mentioned.

https://developer.squareup.com/reference/square/orders-api/retrieve-order

 

In Zap step 1 for Square New Order, test in the TEST tab.

Then post screenshots showing the DATA OUT returned for an example order record.

 

 

​@dtaylor252 

If you want to hire help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

ok. I will look into both! thanks for the info

Hi ​@dtaylor252, just checking in—how did you get on with that New Order trigger Troy suggested? Did it include all the line item information you were hoping to send over to Google Sheets?

Want to make sure you’re all set, so please keep us posted on how it went! 🙂

Terms & Conditions