Google Sheets + Square
Create row entries in Google Sheets for new Square invoices
Keep your sales records organized with this efficient workflow between Square and Google Sheets. Whenever a new invoice is created in your Square account, this automation will add all the relevant details to a new row in a specified Google Sheets spreadsheet. Stay on top of your finances without any manual data entry and ensure all your invoice information is always up-to-date.
Keep your sales records organized with this efficient workflow between Square and Google Sheets. Whenever a new invoice is created in your Square account, this automation will add all the relevant details to a new row in a specified Google Sheets spreadsheet. Stay on top of your finances without any manual data entry and ensure all your invoice information is always up-to-date.
- When this happens...
New InvoiceTriggers when a new invoice is added.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planLocationRequired
Order Status
Try ItTriggerThis is the start of your ZapPollingZapier 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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 ZapPollingZapier 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.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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
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
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
Related categories
About Square
Related categories
Related Zap Templates
- Save new Square transactions to Google Sheets rows
- Create Google Sheet rows for new Square customers
- Log new Square payments in Google Sheets rows
- Create Square customers for new rows in Google Sheets
- Create rows in Google Sheets for new payments in Square
- Create Google Sheets rows for new Square orders.
- Create spreadsheets in Google Sheets for new orders in Square
- Add new Square appointments to Google Sheets as rows
- Create Google Sheets spreadsheet rows from new Square transactions
- Add new Square customers to Google Sheets as multiple rows
- 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
- 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
- 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
- Log new Square payments by creating rows in Google Sheets
- Create new Square customers from new Google Sheets rows
- Create new Google Sheets rows at the top for every new order in Square
- Create rows at top of Google Sheets with every new appointment in Square
Related Zap Templates
- Save new Square transactions to Google Sheets rows
- Create Square customers for new rows in Google Sheets
- Create spreadsheets in Google Sheets for new orders in Square
- Add new Square customers to Google Sheets as multiple rows
- Add new Square customers to Google Sheets and update spreadsheet rows
- Create Square customers from new or updated Google Sheets rows
- 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 new Google Sheets rows at the top for every new order in Square
- Create Google Sheet rows for new Square customers
- Create rows in Google Sheets for new payments in Square
- Add new Square appointments to Google Sheets as rows
- Add new Square catalog items to Google Sheets as rows
- 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 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
- Log new Square payments by creating rows in Google Sheets
- Create rows at top of Google Sheets with every new appointment in Square
- Log new Square payments in Google Sheets rows
- Create Google Sheets rows for new Square orders.
- Create Google Sheets spreadsheet rows from new Square transactions
- Create multiple Google Sheets rows for new Square payments
- Add customers to Square group for new or updated Google Sheets rows
- Update Square customers from new or updated Google Sheets 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
- Create new Square customers from new Google Sheets rows