Skip to main content
Question

Automate exporting Square item sales data to Google Sheets with Zapier

  • Apr 1, 2025 4:55 PM UTC
  • 9 replies
  • 131 views

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Apr 1, 2025 4:57 PM UTC

  • Author
  • Beginner
  • Apr 1, 2025 5:02 PM UTC

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Apr 1, 2025 5:30 PM UTC

​@dtaylor252 

Try this Zap trigger: Square - New Order

Orders usually have line items.

 


  • Author
  • Beginner
  • Apr 1, 2025 10:12 PM UTC

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


  • Author
  • Beginner
  • Apr 1, 2025 10:15 PM UTC

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

is that possible?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Apr 1, 2025 10:19 PM UTC

​@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.

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Apr 1, 2025 10:19 PM UTC

​@dtaylor252 

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


  • Author
  • Beginner
  • Apr 1, 2025 10:21 PM UTC

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


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Apr 24, 2025 1:25 PM UTC

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