Trello + Google Sheets Integrations

How to connect Trello + Google Sheets

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

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

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

Quickly automate Trello and Google Sheets workflows with Zapier's templates

Our most popular Zap! arrow pointing down

Create Trello cards from new rows on Google Sheets
Details
Try it
Google Sheets + Trello
Create Trello cards from new or updated Google Sheets rows
Details
Try it
Google Sheets + Trello
Create rows in Google Sheets spreadsheets with new Trello cards
Details
Try it
Trello + Google Sheets
Save new Trello card activity as Google Sheets rows
Details
Try it
Trello + Google Sheets
Add rows to Google Sheets when new Trello cards are moved to a list
Details
Try it
Trello + Google Sheets
Add new Trello card activity as a new row on Google Sheet
Details
Try it
Trello + Google Sheets

Create Trello cards and Google Sheets rows for new starred emails on Gmail
Details
Try it
Gmail + Trello + Google Sheets
Update rows in Google Sheets when new Trello cards are moved to lists
Details
Try it
Trello + Google Sheets

Create Trello cards from new rows on Google Sheets

Details

Try it

Google Sheets + Trello

Create Trello cards from new or updated Google Sheets rows

Details

Try it

Google Sheets + Trello

Create rows in Google Sheets spreadsheets with new Trello cards

Details

Try it

Trello + Google Sheets

Save new Trello card activity as Google Sheets rows

Details

Try it

Trello + Google Sheets

Add rows to Google Sheets when new Trello cards are moved to a list

Details

Try it

Trello + Google Sheets

Add new Trello card activity as a new row on Google Sheet

Details

Try it

Trello + Google Sheets

Create Trello cards and Google Sheets rows for new starred emails on Gmail

Details

Try it

Gmail + Trello + Google Sheets

Update rows in Google Sheets when new Trello cards are moved to lists

Details

Try it

Trello + Google Sheets

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

Do Even More with Trello + Google Sheets

With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Trello + Google Sheets workflows do more for them.

Zapier users love adding Gmail to their workflows
Create Trello cards and Google Sheets rows for new starred emails on Gmail
Premium
Create Trello cards and Google Sheets rows for new starred emails on Gmail
Try it
Gmail + Google Sheets + Trello
Zapier users love adding Gmail to their workflows
Send Gmail emails for new Trello cards that are also in Google Sheets
Premium
Send Gmail emails for new Trello cards that are also in Google Sheets
Try it
Gmail + Google Sheets + Trello

Supported triggers and actions

What does this mean?

New Board
Triggers when a new board is added.
Trigger
Scheduled
Try It
- Board
  If you do not select a board, only activities performed by you will trigger the zap. If you choose a board, activities on all cards on that board will trigger the zap, including cards you are not a member of.
- List
  Further filter activity by list. Requires a board to be selected.
- Card
Trigger
Scheduled
Try It
- ActivityRequired
  Only trigger for this type of activity/action.
Trigger
Instant
Try It
- Board
  Choosing a board will trigger only for cards due on that board.
- Time Before
  How far before the due time do you want us to trigger? Note: The Trello API requires ~60 seconds for updates on cards to appear.
- Time Before (Unit)
- Status
- Only cards where you're a member?
Trigger
Scheduled
Try It
- BoardRequired
  Only trigger for new checklists in this board.
Trigger
Scheduled
Try It

- BoardRequired
- Label
Trigger
Instant
Try It
- BoardRequired
Trigger
Scheduled
Try It

- BoardRequired
  Pick a board that contains the card with the checklist you want to add an item to.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card with the checklist you want to add an item to.
- ChecklistRequired
  Pick the checklist you want to add an item to.
- Checklist Item NameRequired
- Checklist Item Position
  You can choose a specific number if you want.
Action
Write
- BoardRequired
- ListRequired
- NameRequired
- Description
  Trello uses Markdown formatting syntax.
- Label
  Pick a color label to apply to the card.
- Custom Labels
  Type names for custom labels (non-existing will be created).
- Card Position
  You can choose a specific number if you want.
- Member
  Requires a board to be selected.
- Due Date
- File Attachments
  Use a comma to separate multiple files.
- URL Attachments
  Use a comma to separate multiple URLs.
- Checklist Name
  Leave this blank if you don't want to add a checklist.
- Checklist Items
Action
Write
- Board
  Pick a board that contains the card you want to add an attachment to.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to add the attachment to.
- File Attachments
  Use a comma to separate multiple files.
- URL Attachments
  Use a comma to separate multiple URLs.
Action
Write
- BoardRequired
  Pick a board that contains the card you want to move.
- From List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to move.
- To Board
  Pick the board that has the list you would like the card to move to. Defaults to the board the card is currently in.
- To ListRequired
  Pick the list to move the card to.
Action
Write
- Board
  Pick a board that contains the card you want to update. A board must be selected if you want custom fields to be shown as options below.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to update.
- Card Name
  Leave this blank if you do not want to update the name.
- Card Description
  Leave this blank if you do not want to update the description. Trello uses Markdown formatting syntax.
- Card Due Date
  Leave this blank if you do not want to update the due date.
- Due Complete
- Card Position
  Leave this blank if you do not want to update the position. Pick the position of the card in the list (can be top, bottom, or a positive number)
Action
Write
- BoardRequired
  Choose a board to close.
Action
Write
- BoardRequired
  Pick a board that contains the card with the checklist item you want to complete.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card with the checklist item you want to complete.
- ChecklistRequired
  Pick the checklist which has the item you want to complete.
- Checklist ItemRequired
  Pick the checklist item you want to complete.
Action
Write
- Board
  Pick a board that contains the card with the checklist you want to add an item to.
- List
  Filter cards below by list. Requires a board to be selected.
- Card
  Pick the card with the checklist you want to add an item to.
- ChecklistRequired
  Pick the checklist you want to add an item to.
Action
Write
- BoardRequired
- NameRequired
Action
Write
- BoardRequired
- Label NameRequired
Action
Search
- BoardRequired
  Pick a board that contains checklist you're looking for.
- List
  Filter cards below by list. Requires a board to be selected.
- Card
  Pick the card that contains the checklist you're looking for.
- SearchRequired
  Search by matching Checklist Name.
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
  An Organization must be chosen if the "organization" option is chosen.
- Allow Any Team Member to Join This Board?
  Choose "Yes" to allow any team member to join this board without being invited (only applicable to team boards). To apply this setting, the "Permission Level" field can't be blank or set to Private.
Action
Search or write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Trigger
Scheduled
Try It
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
  The column position (zero-based) to insert. If not set, append to the right by default.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
  Create a duplicate of an existing spreadsheet.
- Headers
  These Headers are ignored if a "Spreadsheet to Copy" is selected.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  Use a search step before this to get the row to delete.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Action
Write
- Owner
  Determines which App Extensions will appear in the dropdown below.
- App ExtensionRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet?
- Row Count
  Number of rows to return. Max is 500.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- ColumnsRequired
  Let us know which columns to return. e.g. A:Z
- Row CountRequired
  Number of rows to return. Max is 500.
- First Row
  Number of the first row to return (1 is the header)
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Search or write

- Board
  Choosing a board will trigger on all new cards on that board.
- List
  Requires a board to be selected.
- Filter
Trigger
Scheduled
Try It
- Board
  If you do not select a board, only activities performed by you will trigger the zap. If you choose a board, activities on all cards on that board will trigger the zap, including cards you are not a member of.
- List
  Further filter activity by list. Requires a board to be selected.
- Card
Trigger
Scheduled
Try It
- BoardRequired
- ListRequired
  List where the card was moved to.
- 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
  An Organization must be chosen if the "organization" option is chosen.
- Allow Any Team Member to Join This Board?
  Choose "Yes" to allow any team member to join this board without being invited (only applicable to team boards). To apply this setting, the "Permission Level" field can't be blank or set to Private.
Action
Write
- Board
  Pick a board that contains the card you want to archive.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to archive.
Action
Write
- BoardRequired
  Pick a board that contains the label you want to add.
- LabelRequired
  Requires a board to be selected.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to add the label to.
Action
Write
- BoardRequired
  Pick a board that contains the card you want to add members to.
- Member(s)Required
  Requires a board to be selected.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to add members to.
Action
Write
- Board
  Pick a board that contains the card you want to add the checklist to.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to add the checklist to.
- Checklist NameRequired
- Checklist to Copy
  Requires a board to be picked.
- Checklist Items
  If you're copying a checklist, these will be added after its items.
- Checklist Position
  You can choose a specific number if you want.
Action
Write
- Board
  Filter cards below by board.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
- Comment TextRequired
Action
Write
- BoardRequired
  Choose a board to copy.
- NameRequired
  Enter the name of your new board.
- Organization
  Add the board to an organization (it'll be in your Personal Boards if left blank).
- Permission Level
  An Organization must be chosen if the "organization" option is chosen.
- Allow Any Team Member to Join This Board?
  Choose "Yes" to allow any team member to join this board without being invited (only applicable to team boards). To apply this setting, the "Permission Level" field can't be blank or set to Private.
Action
Write
- BoardRequired
  Pick a board to add the label to.
- Label NameRequired
- Color
  Pick a color for the label.
Action
Write
- BoardRequired
  Pick a board that contains the card you want to remove the label from.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to remove the label from.
- LabelRequired
  Requires a board to be selected.
Action
Write
- BoardRequired
- List NameRequired
Action
Search
- BoardRequired
  Pick a board that contains checklist you're looking for.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card that contains the checklist you're looking for.
- ChecklistRequired
  Pick the checklist that contains the checklist item you're looking for.
- SearchRequired
  Search by matching Checklist Item Name.
Action
Search
- Organization
- Board
- List
- Card NameRequired
Action
Search
- BoardRequired
  Pick a board to add the label to.
- Label NameRequired
- Color
  Pick a color for the label.
Action
Search or write
- BoardRequired
  Pick a board that contains the card you want to add the checklist to.
- List
  Filter cards below by list. Requires a board to be selected.
- CardRequired
  Pick the card to add the checklist to.
- SearchRequired
  Search by matching Checklist Name.
- Checklist NameRequired
- Checklist to Copy
  Requires a board to be picked.
- Checklist Items
  If you're copying a checklist, these will be added after its items.
- Checklist Position
  You can choose a specific number if you want.
Action
Search or write
- Organization
- BoardRequired
- ListRequired
- Card NameRequired
- Description
  Trello uses Markdown formatting syntax.
- Label
  Pick a color label to apply to the card.
- Custom Labels
  Type names for custom labels (non-existing will be created).
- Card Position
  You can choose a specific number if you want.
- Member
  Requires a board to be selected.
- Due Date
- File Attachments
  Use a comma to separate multiple files.
- URL Attachments
  Use a comma to separate multiple URLs.
- Checklist Name
  Leave this blank if you don't want to add a checklist.
- Checklist Items
Action
Search or write
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
  Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
- Background Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Bold
  True if the text is bold.
- Text Italic
  True if the text is italicized.
- Text Strikethrough
  True if the text is strikethrough.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Api Docs Info
  API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search or write

How Trello + Google Sheets Integrations Work

Step 1: Authenticate Trello and Google Sheets.
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 Trello + Google Sheets

Trello Tutorials

Google Sheets Tutorials

About Trello

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

Learn more

Trello + Google Sheets Integrations

How to connect Trello + Google Sheets

Create Trello cards from new rows on Google Sheets

Create Trello cards from new or updated Google Sheets rows

Create rows in Google Sheets spreadsheets with new Trello cards

Save new Trello card activity as Google Sheets rows

Add rows to Google Sheets when new Trello cards are moved to a list

Add new Trello card activity as a new row on Google Sheet

Create Trello cards and Google Sheets rows for new starred emails on Gmail

Update rows in Google Sheets when new Trello cards are moved to lists

Create Trello cards from new rows on Google Sheets

Create Trello cards from new or updated Google Sheets rows

Create rows in Google Sheets spreadsheets with new Trello cards

Save new Trello card activity as Google Sheets rows

Add rows to Google Sheets when new Trello cards are moved to a list

Add new Trello card activity as a new row on Google Sheet

Create Trello cards and Google Sheets rows for new starred emails on Gmail

Update rows in Google Sheets when new Trello cards are moved to lists

Connect your apps and automate workflows

Do Even More with Trello + Google Sheets

Create Trello cards and Google Sheets rows for new starred emails on Gmail

Send Gmail emails for new Trello cards that are also in Google Sheets

New Board

Card Archived

Board

List

Card

New Activity

ActivityRequired

Card Due

Board

Time Before

Time Before (Unit)

Status

Only cards where you're a member?

New Checklist

BoardRequired

New Label Added to Card

BoardRequired

Label

New Member on Board

BoardRequired

Create Checklist Item in Card

BoardRequired

List

CardRequired

ChecklistRequired

Checklist Item NameRequired

Checklist Item Position

Create Card

BoardRequired

ListRequired

NameRequired

Description

Label

Custom Labels

Card Position

Member

Due Date

File Attachments

URL Attachments

Checklist Name

Checklist Items

Add Attachment to Card

Board

List

CardRequired

File Attachments

URL Attachments

Move Card to List

BoardRequired

From List

CardRequired

To Board

To ListRequired

Update Card

Board

List

CardRequired

Card Name