How to connect Google Sheets + Microsoft Outlook + Trello
Zapier lets you send info between Google Sheets and Microsoft Outlook and Trello automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Microsoft Outlook + 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, Microsoft Outlook, and Trello. And don’t forget that you can add more apps and actions to create complex workflows.
- Dont Change Sheet Structure 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Dont 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 app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- ColumnsRequired 
- Row countRequired 
- Output format 
- First row 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Spreadsheet IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- 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
- Calendar 
- Time BeforeRequired 
- Time Before (Unit)Required 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Shared Inbox 
- Parent Folder 
- Child Folder 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Parent Folder 
- Child Folder 
- Search termsRequired 
- Note 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Shared Inbox 
- Parent Folder 
- Child Folder 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Event 
- Merge with existing attendees? 
- Attendees 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Calendar 
- SubjectRequired 
- Start Date & TimeRequired 
- End Date & TimeRequired 
- Location Name 
- Sensitivity 
- Attendees 
- Is this an All Day Event? 
- Description 
- Show me as Free or Busy 
- Is this an Online Meeting? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- To Email(s)Required 
- CC Email(s) 
- BCC Email(s) 
- Reply-To Email 
- SubjectRequired 
- Body FormatRequired 
- BodyRequired 
- Attachment 
- Action for Files Larger Than 150MB 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact to DeleteRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Email IDRequired 
- To RecipientsRequired 
- Comment 
- Send From 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Email IDRequired 
- Comment 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- From Email 
- To Email(s)Required 
- CC Email(s) 
- BCC Email(s) 
- Reply-To Email 
- SubjectRequired 
- Body FormatRequired 
- BodyRequired 
- Attachments 
- Action for Files Larger Than 150MB 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact Folder 
- ContactRequired 
- First Name 
- Last Name 
- Email Addresses 
- Business Phones 
- Home Phones 
- Mobile Phone 
- Job Title 
- Company Name 
- Department 
- Business Website URL 
- Personal Notes 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Calendar 
- Search TermRequired 
- Start Date & Time 
- End Date & Time 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Search Info 
- Search ValueRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Group email address or IDRequired 
- Search Term 
- Start Date & Time 
- End Date & Time 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Contact Folder 
- First NameRequired 
- Last Name 
- Email 
- Business Phones 
- Home Phones 
- Mobile Phone 
- Job Title 
- Company Name 
- Department 
- Business Website URL 
- File As 
- Personal Notes 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
 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
- Board ID 
- List ID 
- Card ID 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Notification- Triggers when you get a new notification in Trello. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Board IDRequired 
- Member IDRequired 
- Membership TypeRequired 
- Allow Billable Guest 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- Label IDRequired 
- List ID 
- Card IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- Member ID(s)Required 
- List ID 
- Card IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- List IDRequired 
- NameRequired 
- Description 
- Label ID 
- Custom Labels 
- Card Position 
- Member ID(s) 
- Start Date 
- Due Date 
- File Attachments 
- URL Attachments 
- Checklist Name 
- Checklist Items 
- Cover Info 
- Card Color 
- Brightness 
- URL 
- Size 
- Location Info 
- Coordinates 
- Address 
- Location 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- List ID 
- Card IDRequired 
- Checklist IDRequired 
- Checklist Item IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card ID 
- Checklist IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- BoardRequired 
- NameRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Action IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- Label NameRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Card IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- List ID 
- Card ID 
- SearchRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- List ID 
- Card IDRequired 
- Checklist IDRequired 
- SearchRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Label IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Member IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Organization IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Organization 
- Board 
- List Name 
- Keyword 
- Member 
- Label 
- Due Date Filter 
- Has Filter 
- Only Starred Boards 
- Open Cards Only 
- Cards Limit 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- Label NameRequired 
- Color 
 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
- Board IDRequired 
- List ID 
- Card IDRequired 
- SearchRequired 
- Checklist NameRequired 
- Checklist to Copy ID 
- Checklist Items 
- Checklist Position 
 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
- Dont 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 plan
- Drive 
- 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 app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- A1 RangeRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Row IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found
 - Cancelled Calendar Event- Triggers when an event is cancelled. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Shared Inbox 
- Parent Folder 
- Child Folder 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
 - New Flagged Email- Triggers when a new email is flagged. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Email IDRequired 
- CategoriesRequired 
- Mark as Read 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact Folder 
- First NameRequired 
- Last Name 
- Email Addresses 
- Business Phones 
- Home Phones 
- Mobile Phone 
- Job Title 
- Company Name 
- Department 
- Business Website URL 
- File As 
- Personal Notes 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
- Street 
- City 
- State 
- Postal Code 
- Country or Region 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Email IDRequired 
- To Email(s) 
- CC Email(s) 
- BCC Email(s) 
- Reply-To Email 
- Subject 
- Body 
- Attachment 
- Action for Files Larger Than 150MB 
- Reply to All 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- EventRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Email IDRequired 
- Destination FolderRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Draft Email IDRequired 
- Send From 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Event 
- Subject 
- Start Date & Time 
- End Date & Time 
- All Day Event? 
- Is Online Meeting? 
- Hide attendees list? 
- Description 
- Show me as Free or Busy 
- The importance of the event 
- Merge with existing attendees? 
- Attendees 
- Categories 
- Location 
 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.
- Contact Folder 
- First Name 
- Last Name 
- Email 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Folder Info 
- FolderRequired 
- Search Terms 
- From Address 
- Start Date 
- End Date 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Calendar 
- Start Date & TimeRequired 
- End Date & TimeRequired 
- Select Fields 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
 - New Board- Triggers when a new board is added. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- ActivityRequired 
- Board ID 
- List ID 
- Card ID 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Info 
- Board ID 
- Time Before 
- Time Before (Unit) 
- Status 
- Only cards where you're a member? 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Board IDRequired 
- Label ID 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Board IDRequired 
- List ID 
- Card IDRequired 
- Checklist IDRequired 
- Checklist Item NameRequired 
- Checklist Item Position 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Organization ID 
- NameRequired 
- DescriptionRequired 
- Permission Level 
- Allow Any Team Member to Join This Board? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card IDRequired 
- File Attachments 
- URL Attachments 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- From List ID 
- Card IDRequired 
- To Board ID 
- To List IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card IDRequired 
- Card Name 
- Card Description 
- Overwrite Description 
- Card Start Date 
- Card Due Date 
- Due Complete 
- Card Position 
- Card Closed 
- Cover Info 
- Card Color 
- Brightness 
- Attachment ID 
- URL 
- Size 
- Location Info 
- Coordinates 
- Address 
- Location 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card IDRequired 
- Checklist NameRequired 
- Checklist to Copy ID 
- Checklist Items 
- Checklist Position 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board ID 
- List ID 
- Card IDRequired 
- Comment TextRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- NameRequired 
- Organization ID 
- Permission Level 
- Allow Any Team Member to Join This Board? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- Label NameRequired 
- Color 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
- List ID 
- Card IDRequired 
- Label IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Board IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- List NameRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Card IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Checklist IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Checklist IDRequired 
- Checklist Item IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- List IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Organization IDRequired 
- Board NameRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Trello Query StringRequired 
- Organization ID 
- Cards Limit 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Organization IDRequired 
- Member NameRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Board IDRequired 
- List NameRequired 
 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
- Organization IDRequired 
- Board NameRequired 
- DescriptionRequired 
- Permission Level 
- Allow Any Team Member to Join This Board? 
 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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + Microsoft Outlook + Trello Integrations Work
- Step 1: Authenticate Google Sheets, Microsoft Outlook, 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.

























