Google Sheets + Square
Create Google Sheets rows for new Square orders.
Managing your sales data just got easier. With this workflow, when a new order comes into your Square account, the data will be added to multiple rows in a Google Sheets spreadsheet. This saves time on manual data entry, keeps your records up-to-date and organized, and helps you track your sales performance efficiently.
Managing your sales data just got easier. With this workflow, when a new order comes into your Square account, the data will be added to multiple rows in a Google Sheets spreadsheet. This saves time on manual data entry, keeps your records up-to-date and organized, and helps you track your sales performance efficiently.
- When this happens...
New OrderTriggers when a new order is processed.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Appointment
Triggers when a new appointment is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLocationRequired
Order Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer IDRequired
GroupRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Inventory Change TypeRequired
LocationRequired
Catalog ObjectRequired
QuantityRequired
Ignore unchanged counts
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
Order IDRequired
Customer IDRequired
Accepted Payment MethodsRequired
Payment due dateRequired
Tipping enabled
Invoice title
Invoice number
Description
Delivery methodRequired
Scheduled at
Date of sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PaymentRequired
Refund amount
Reason
Team member
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Help Text
LocationRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field Help
Email Address
Phone Number
Reference ID
ActionThis is an event a Zap performs.SearchFind existing data in your appField Help
Text Filter
Location
ActionThis is an event a Zap performs.SearchFind existing data in your appField Help
Email Address
Phone Number
Reference ID
First Name
Last Name
Country
Street Address
Apt./Suite
City
State
ZIP
Other
Company
Nickname
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
LocationRequired
Team Member IDRequired
Customer IDRequired
Date and Time of AppointmentRequired
Appointment Service IDRequired
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email Address
Phone Number
Country
Street Address
Apt./Suite
City
State
ZIP
Other
Company
Nickname
Reference Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
Customer ID
External Identifier
Buyer Email Address
Payment TypeRequired
Payment Note
QuantityRequired
AmountRequired
CurrencyRequired
Line Item Name
Catalog Item Variation ID
Pickup
Display Name
Carrier
Expected Ship Date/Time
Shipping Note
Fulfillment Email Address
Phone number of the fulfillment recipient
Address Line 1
Address Line 2
State
County
Country
City
Postal Code
Discount Type
Name
Percentage
Amount Discounted
Discount Currency
Name
Percentage
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
GroupRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
First Name
Last Name
Email Address
Phone Number
Country
Street Address
Apt./Suite
City
State
ZIP
Other
Company
Nickname
Reference ID
Birthday
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Order by ID
This action retrieves the details of a specific order from Square using the order ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Id
ActionThis is an event a Zap performs.SearchFind existing data in your appLocationRequired
Field Help
Customer
Fulfillment State
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appLocationRequired
Field Help
Customer
Fulfillment State
Status
Customer ID
External Identifier
Source
Ticket Name
Quantity
Amount
Currency
Catalog Item Variation ID
Note
Unique Identifier
Amount Discounted
Amount Discounted Currency
Name
Percentage
Type
Unique Identifier
Name
Percentage
Type
Unique Identifier
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Square
Square creates tools that help sellers of all sizes start, run and grow their businesses. Square’s point-of-sale service offers tools for every part of running a business, from accepting credit cards and tracking inventory to real-time analytics and invoicing.
Related categories
Related Zap Templates
- Save new Square transactions to Google Sheets rows
- Create Google Sheet rows for new Square customers
- Create Square customers for new rows in Google Sheets
- Create rows in Google Sheets for new payments in Square
- Create Google Sheets spreadsheet rows from new Square transactions
- Log new Square payments in Google Sheets rows
- Add new Square appointments to Google Sheets as rows
- Create spreadsheets in Google Sheets for new orders in Square
- Add new Square catalog items to Google Sheets as rows
- Create multiple Google Sheets rows for new Square payments
- Add new Square customers to Google Sheets and update spreadsheet rows
- Create row entries in Google Sheets for new Square invoices
- Update Square inventories when new rows are added to Google Sheets
- Add customers to Square group for new or updated Google Sheets rows
- Create Square customers from new or updated Google Sheets rows
- Update Square customers from new or updated Google Sheets spreadsheet rows in team drive
- Update Square customers from new or updated Google Sheets rows
- Add new Square customers to Google Sheets as multiple rows
- Update Google Sheets rows with new Square payments
- Update Square inventories when new or updated rows are detected in Google Sheets
- Create multiple Google Sheets rows for every new Square invoice
- Create multiple rows in Google Sheets for new catalog items in Square
- Create spreadsheet columns in Google Sheets for new orders in Square
- Create spreadsheet columns in Google Sheets for new payments in Square
- Update Google Sheets rows following new customers on Square
- Update spreadsheet rows in Google Sheets with new payments from Square
- Log new Square payments to Google Sheets spreadsheets
- Create Square invoices from new or updated Google Sheets rows
- Create multiple rows in Google Sheets for new Square appointments
- Create spreadsheets in Google Sheets for new catalog items in Square
- Update Google Sheets rows with new Square orders
- Update Square inventories when new or updated rows are detected in Google Sheets team drive
- Create new rows in Google Sheets for each new customer in Square
- Add new Google Sheets rows to Square as customers in a group
- Update Google Sheets rows with new catalog items from Square
- Update Google Sheets rows when new Square orders are placed
- Create worksheets in Google Sheets for new catalog items in Square
Related Zap Templates
- Save new Square transactions to Google Sheets rows
- Create rows in Google Sheets for new payments in Square
- Add new Square appointments to Google Sheets as rows
- Create multiple Google Sheets rows for new Square payments
- Update Square inventories when new rows are added to Google Sheets
- Update Square customers from new or updated Google Sheets spreadsheet rows in team drive
- Update Google Sheets rows with new Square payments
- Create multiple rows in Google Sheets for new catalog items in Square
- Update Google Sheets rows following new customers on Square
- Create Square invoices from new or updated Google Sheets rows
- Update Google Sheets rows with new Square orders
- Add new Google Sheets rows to Square as customers in a group
- Create worksheets in Google Sheets for new catalog items in Square
- Create Google Sheet rows for new Square customers
- Create Google Sheets spreadsheet rows from new Square transactions
- Create spreadsheets in Google Sheets for new orders in Square
- Add new Square customers to Google Sheets and update spreadsheet rows
- Add customers to Square group for new or updated Google Sheets rows
- Update Square customers from new or updated Google Sheets rows
- Update Square inventories when new or updated rows are detected in Google Sheets
- Create spreadsheet columns in Google Sheets for new orders in Square
- Update spreadsheet rows in Google Sheets with new payments from Square
- Create multiple rows in Google Sheets for new Square appointments
- Update Square inventories when new or updated rows are detected in Google Sheets team drive
- Update Google Sheets rows with new catalog items from Square
- Create Square customers for new rows in Google Sheets
- Log new Square payments in Google Sheets rows
- Add new Square catalog items to Google Sheets as rows
- Create row entries in Google Sheets for new Square invoices
- Create Square customers from new or updated Google Sheets rows
- Add new Square customers to Google Sheets as multiple rows
- Create multiple Google Sheets rows for every new Square invoice
- Create spreadsheet columns in Google Sheets for new payments in Square
- Log new Square payments to Google Sheets spreadsheets
- Create spreadsheets in Google Sheets for new catalog items in Square
- Create new rows in Google Sheets for each new customer in Square
- Update Google Sheets rows when new Square orders are placed