Google Sheets + Square + Trello Integrations

How to connect Google Sheets + Square + Trello

Zapier lets you send info between Google Sheets and Square and Trello automatically—no code required. With 7,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

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

Do even more with Google Sheets + Square + Trello

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Square, and Trello. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
- Item Type
Trigger
Scheduled
Try It
- LocationRequired
Trigger
Scheduled
Try It
- Location
Trigger
Scheduled
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
- Board
- List
- Filter
Trigger
Scheduled
Try It
- Board
- List
- Card
Trigger
Scheduled
Try It
- Board
- List
- Card
Trigger
Instant
Try It
- BoardRequired
- CardRequired
Trigger
Instant
Try It
- BoardRequired
Trigger
Scheduled
Try It
- BoardRequired
Trigger
Scheduled
Try It
New Notification
Triggers when you get a new notification in Trello.
Trigger
Scheduled
Try It
- Organization
- NameRequired
- DescriptionRequired
- Permission Level
- Allow Any Team Member to Join This Board?
Action
Write
- Board
- List
- CardRequired
Action
Write
- BoardRequired
- LabelRequired
- List
- CardRequired
Action
Write
- BoardRequired
- Member(s)Required
- List
- CardRequired
Action
Write
- Board
- List
- CardRequired
- Checklist NameRequired
- Checklist to Copy
- Checklist Items
- Checklist Position
Action
Write
- Board
- List
- CardRequired
- Comment TextRequired
Action
Write
- BoardRequired
- NameRequired
- Organization
- Permission Level
- Allow Any Team Member to Join This Board?
Action
Write
- BoardRequired
- Label NameRequired
- Color
Action
Write
- BoardRequired
- List
- CardRequired
- LabelRequired
Action
Write
- BoardRequired
- List NameRequired
Action
Search
- BoardRequired
- List
- CardRequired
- ChecklistRequired
- SearchRequired
Action
Search
- Info
- Organization
- Board
- List
- Card NameRequired
Action
Search
- BoardRequired
- Label NameRequired
- Color
Action
Search or write
- BoardRequired
- List
- CardRequired
- SearchRequired
- Checklist NameRequired
- Checklist to Copy
- Checklist Items
- Checklist Position
Action
Search or write
- Info
- Organization
- BoardRequired
- ListRequired
- Card NameRequired
- Description
- Label
- Custom Labels
- Card Position
- Member
- Due Date
- File Attachments
- URL Attachments
- Checklist Name
- Checklist Items
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New Appointment
Triggers when a new appointment is created.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is created.
Trigger
Scheduled
Try It
- LocationRequired
- Order Status
Trigger
Scheduled
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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- 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
New Board
Triggers when a new board is added.
Trigger
Scheduled
Try It
- Board
- List
- Card
Trigger
Scheduled
Try It
- ActivityRequired
- Board
- List
- Card
Trigger
Instant
Try It
- Board
- Time Before
- Time Before (Unit)
- Status
- Only cards where you're a member?
Trigger
Scheduled
Try It
- BoardRequired
Trigger
Scheduled
Try It
- BoardRequired
- Label
Trigger
Instant
Try It
- BoardRequired
Trigger
Scheduled
Try It
- BoardRequired
- List
- CardRequired
- ChecklistRequired
- Checklist Item NameRequired
- Checklist Item Position
Action
Write
- BoardRequired
- ListRequired
- NameRequired
- Description
- Label
- Custom Labels
- Card Position
- Member
- Due Date
- File Attachments
- URL Attachments
- Checklist Name
- Checklist Items
Action
Write
- Board
- List
- CardRequired
- File Attachments
- URL Attachments
Action
Write
- BoardRequired
- From List
- CardRequired
- To Board
- To ListRequired
Action
Write
- Board
- List
- CardRequired
- Card Name
- Card Description
- Card Due Date
- Due Complete
- Card Position
Action
Write
- BoardRequired
Action
Write
- BoardRequired
- List
- CardRequired
- ChecklistRequired
- Checklist ItemRequired
Action
Write
- Board
- List
- Card
- ChecklistRequired
Action
Write
- BoardRequired
- NameRequired
Action
Write
- BoardRequired
- Label NameRequired
Action
Search
- BoardRequired
- List
- Card
- SearchRequired
Action
Search
- OrganizationRequired
- Board NameRequired
Action
Search
- OrganizationRequired
- Member NameRequired
Action
Search
- BoardRequired
- List NameRequired
Action
Search or write
- OrganizationRequired
- Board NameRequired
- DescriptionRequired
- Permission Level
- Allow Any Team Member to Join This Board?
Action
Search or write

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Google Sheets + Square + Trello Integrations Work

Step 1: Authenticate Google Sheets, Square, and Trello.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Google Sheets + Square + Trello

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

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.