MySQL + Square

Create new MySQL rows for each new Square payment

Automate your payment tracking with this useful workflow. When a new transaction takes place in Square, a new row instantly gets inserted in your MySQL database. This simplifies record-keeping, boosts the accuracy of your accounting system, and allows for smoother business operations and financial audits.

When this happens...
New Payment
Triggers when a new payment is created.
TriggerPolling
automatically do this!
New Row
Triggers when you add a new row.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Appointment
Triggers when a new appointment is created.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
- LocationRequired
- Order Status
Trigger
Polling
Try It
- Customer IDRequired
- GroupRequired
Action
Write
- Inventory Change TypeRequired
- LocationRequired
- Catalog ObjectRequired
- QuantityRequired
- Ignore unchanged counts
Action
Write

- 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
Action
Write
- PaymentRequired
- Refund amount
- Reason
- Team member
Action
Write

- Help Text
- LocationRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Field Help
- Email Address
- Phone Number
- Reference ID
Action
Search
- Field Help
- Text Filter
- Location
Action
Search
- Field Help
- Email Address
- Phone Number
- Reference ID
- First Name
- Last Name
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
Action
Search or write
- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
- Trigger Column Configuration
Trigger
Polling
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

- Item Type
Trigger
Polling
Try It
- LocationRequired
Trigger
Polling
Try It
- Location
Trigger
Polling
Try It
- LocationRequired
- Team Member IDRequired
- Customer IDRequired
- Date and Time of AppointmentRequired
- Appointment Service IDRequired
- Note
Action
Write
- First Name
- Last Name
- Email Address
- Phone Number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference Id
Action
Write
- 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
Action
Write
- Customer IDRequired
- GroupRequired
Action
Write
- Customer IDRequired
- First Name
- Last Name
- Email Address
- Phone Number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference ID
- Birthday
Action
Write
Find Order by ID
This action retrieves the details of a specific order from Square using the order ID.
Action
Write
- Customer Id
Action
Search
- LocationRequired
- Field Help
- Customer
- Fulfillment State
- Status
Action
Search
- LocationRequired
- 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
Action
Search or write
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Learn more

Related categories

Databases

Similar apps

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.

Learn more