Google Sheets + Square
Update Google Sheets properties when new payments are received in Square
Whenever a new payment is recorded in Square, this system swiftly modifies the details in your Google Sheets. Say goodbye to the tedious job of manually updating your spreadsheet for every financial transaction. This efficient process consistently maintains accurate financial data, requiring less effort and ensuring your records are always up to date. A great tool for effective financial order and administrative ease.
Whenever a new payment is recorded in Square, this system swiftly modifies the details in your Google Sheets. Say goodbye to the tedious job of manually updating your spreadsheet for every financial transaction. This efficient process consistently maintains accurate financial data, requiring less effort and ensuring your records are always up to date. A great tool for effective financial order and administrative ease.
- When this happens...
New PaymentTriggers when a new payment is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Change Sheet PropertiesUpdate Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.
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 foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
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 foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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
- Create Google Sheets rows for new Square orders.
- Create rows in Google Sheets for new payments in Square
- Log new Square payments in Google Sheets rows
- Add new Square customers to Google Sheets as multiple rows
- Create Square customers for new rows in Google Sheets
- Create multiple Google Sheets rows for every new Square invoice
- Add new Square appointments to Google Sheets as rows
- Create Google Sheets spreadsheet rows from new Square transactions
- 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
- Update Google Sheets rows with new Square payments
- Update Square inventories when new or updated rows are detected in Google Sheets
- 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
- Create new rows at top of Google Sheets for new invoices in Square
- Create paid orders in Square from new or updated spreadsheet rows in Google Sheets
Related Zap Templates
- Save new Square transactions to Google Sheets rows
- Create rows in Google Sheets for new payments in Square
- Create Square customers for new rows in Google Sheets
- Create Google Sheets spreadsheet rows from new Square transactions
- 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 Square inventories when new or updated rows are detected in Google Sheets
- 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
- Create new rows at top of Google Sheets for new invoices in Square
- Create Google Sheet rows for new Square customers
- Log new Square payments in Google Sheets rows
- Create multiple Google Sheets rows for every new Square invoice
- 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
- 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 paid orders in Square from new or updated spreadsheet rows in Google Sheets
- Create Google Sheets rows for new Square orders.
- Add new Square customers to Google Sheets as multiple rows
- Add new Square appointments to Google Sheets as 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
- Update Google Sheets rows with new Square payments
- 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