Automate exporting Square item sales data to Google Sheets with Zapier

Hi ​@dtaylor252 

Review the available Zap app triggers/actions: 

Square: 

• https://zapier.com/apps/square/integrations#triggers-and-actions
• https://zapier.com/apps/square/integrations#help

GSheets:

• https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
• https://zapier.com/apps/google-sheets/integrations#help

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! 🙂