Smartsheet + Square

Smartsheet + Square integrations

Add new Square invoices to Smartsheet as rows

Keep your financial documents in order and save time with this workflow. As soon as a new invoice is created in Square, a row will be added to your selected Smartsheet. This streamlined process ensures your financial records are consistently updated, enabling you to further enhance your business management and invoicing system.

When this happens...
New InvoiceTriggers when a new invoice is added.
TriggerPolling
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Square and Smartsheet

Discover other triggers and actions you can use with Square and Smartsheet

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
- Location
  Required
- Order Status
Trigger
Polling
Try It
- Customer ID
  Required
- Group
  Required
Action
Write
- Inventory Change Type
  Required
- Location
  Required
- Catalog Object
  Required
- Quantity
  Required
- Ignore unchanged counts
Action
Write

- Location
  Required
- Order ID
  Required
- Customer ID
  Required
- Accepted_payment_methods
  Required
- Payment due date
  Required
- Tipping enabled
- Invoice title
- Invoice number
- Description
- Delivery method
  Required
- Scheduled at
- Date of sale
Action
Write
- Payment
  Required
- Refund amount
- Reason
- Team member
Action
Write

- Help_text
- Location
  Required
Action
Write
- Customer ID
  Required
- 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
- Location
  Required
- Field_help
- Customer
- Fulfillment_state
- Status
Action
Search
- Location
  Required
- 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
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

- Item Type
Trigger
Polling
Try It
- Location
  Required
Trigger
Polling
Try It
- Location
Trigger
Polling
Try It
- Location
  Required
- Team Member ID
  Required
- Customer ID
  Required
- Date and Time of Appointment
  Required
- Appointment Service ID
  Required
- 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
- Location
  Required
- Customer ID
- External Identifier
- Buyer Email Address
- Payment Type
  Required
- Payment Note
- Quantity
  Required
- Amount
  Required
- Currency
  Required
- 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 ID
  Required
- Group
  Required
Action
Write
- Customer
  Required
- Attribute
  Required
- Value
  Required
- Idempotency Key
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- 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
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Workspace
- Source Folder
  Required
- Destination Workspace
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

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 moreLearn moreHelpHelp

Related categories

eCommerce

Payment Processing

Similar apps

PayPal

Payment Processing

Shopify

eCommerce

Epos Now

Payment Processing

Related Zap Templates

Automatically add new Square orders as rows in a Smartsheet sheet

Update Square customers when new rows are added in Smartsheet