ClickUp + Google Sheets
Create new Google Sheets columns for every new ClickUp task
Keep your project management and spreadsheets seamlessly connected with this workflow. When a new task is created in ClickUp, a corresponding column will be added to a Google Sheets spreadsheet. This automation helps you stay organized and ensures that your team's progress is accurately reflected in your project documentation.
Keep your project management and spreadsheets seamlessly connected with this workflow. When a new task is created in ClickUp, a corresponding column will be added to a Google Sheets spreadsheet. This automation helps you stay organized and ensures that your team's progress is accurately reflected in your project documentation.
- When this happens...
New TaskTriggers when tasks are added.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
WorkspaceRequired
Checklist NameRequired
Checklist ItemRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
List NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
StartRequired
EndRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Task NameRequired
Task Description
Assignee Emails
Priority
Due Date
Start Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Find Task by Custom Fields
Find an existing task by searching custom fields.
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
FieldRequired
ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text Strikethrough
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
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
WorkspaceRequired
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Task NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Task by ID
Find an existing task by its ID.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
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
About ClickUp
ClickUp is a productivity platform that allows you to manage your work and personal tasks in a beautifully intuitive environment.
Related categories
Similar apps
Trello
Project Management
Asana
Project Management
Todoist
Task Management
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Create ClickUp tasks from new Google Sheets rows
- Create rows in Google Sheets for new ClickUp tasks
- Create Google Sheet rows for new tasks in ClickUp
- Create ClickUp tasks for new Google Sheet rows
- Create tasks in ClickUp from new spreadsheets in Google Sheets
- Create Google Sheet rows for new task changes in ClickUp
- Create ClickUp tasks from new or updated Google Sheets rows (Team Drive).
- Create ClickUp tasks from new Google Sheets rows (Team Drive)
- Create ClickUp lists from new or updated Google Sheets rows
- Create Google Sheets spreadsheets for new ClickUp tasks
- Update ClickUp tasks whenever new or updated rows appear in Google Sheets
- Create Google Sheets rows for ClickUp task changes.
- Create ClickUp lists from new Google Sheets rows.
- Create ClickUp subtasks for new or updated Google Sheets rows
- Update Google Sheets rows when ClickUp tasks change
- Create subtasks in ClickUp for new Google Sheets rows
- Create worksheets in Google Sheets for new tasks in ClickUp
- Add rows to Google Sheets for new ClickUp lists
- Create ClickUp folders from new Google Sheets rows
- Create columns in Google Sheets for new ClickUp lists
- Create ClickUp task comments from new or updated Google Sheets rows
- Create task comments in ClickUp for new Google Sheets rows
- Create tasks in ClickUp from new or updated spreadsheet rows in Google Sheets
- Create ClickUp lists from new Google Sheets worksheets
- Create columns in Google Sheets for updated tasks in ClickUp
- Add new ClickUp lists to Google Sheets as multiple rows
- Update ClickUp tasks from new or updated Google Sheets rows
- Create new ClickUp checklists from new or updated Google Sheets rows
- Create ClickUp subtasks from new or updated Google Sheets team drive spreadsheet rows
- Create worksheets in Google Sheets for new ClickUp folders
- Create new Google Sheets spreadsheets from new ClickUp lists
- Update tasks in ClickUp for every new spreadsheet row in Google Sheets
- Update Google Sheets rows whenever tasks change in ClickUp
- Generate new Google Sheets worksheets from new ClickUp lists
- Create spreadsheets in Google Sheets from new folders in ClickUp
- Update Google Sheets rows with new tasks from ClickUp
- Create tasks in ClickUp for new worksheets in Google Sheets
- Create custom actions in ClickUp for every new worksheet in Google Sheets
- Create custom actions in ClickUp for new spreadsheet rows in Google Sheets team drive
- Update Google Sheets rows with new tasks from ClickUp
- Create copies of worksheets in Google Sheets for new tasks in ClickUp
- Manage new or updated Google Sheets rows with custom ClickUp actions
- Create spreadsheet columns in Google Sheets for every new folder in ClickUp
- Create spreadsheet rows in Google Sheets for new folders in ClickUp
- Create duplicates in Google Sheets worksheets for new ClickUp lists
- Create new ClickUp checklists from new Google Sheets rows
- Create new worksheets in Google Sheets from new folders in ClickUp
- Create spreadsheets in Google Sheets when tasks change in ClickUp
Related Zap Templates
- Create ClickUp tasks from new Google Sheets rows
- Create ClickUp tasks for new Google Sheet rows
- Create ClickUp tasks from new or updated Google Sheets rows (Team Drive).
- Create Google Sheets spreadsheets for new ClickUp tasks
- Create ClickUp lists from new Google Sheets rows.
- Create subtasks in ClickUp for new Google Sheets rows
- Create ClickUp folders from new Google Sheets rows
- Create task comments in ClickUp for new Google Sheets rows
- Create columns in Google Sheets for updated tasks in ClickUp
- Create new ClickUp checklists from new or updated Google Sheets rows
- Create new Google Sheets spreadsheets from new ClickUp lists
- Generate new Google Sheets worksheets from new ClickUp lists
- Create tasks in ClickUp for new worksheets in Google Sheets
- Update Google Sheets rows with new tasks from ClickUp
- Create spreadsheet columns in Google Sheets for every new folder in ClickUp
- Create new ClickUp checklists from new Google Sheets rows
- Create rows in Google Sheets for new ClickUp tasks
- Create tasks in ClickUp from new spreadsheets in Google Sheets
- Create ClickUp tasks from new Google Sheets rows (Team Drive)
- Update ClickUp tasks whenever new or updated rows appear in Google Sheets
- Create ClickUp subtasks for new or updated Google Sheets rows
- Create worksheets in Google Sheets for new tasks in ClickUp
- Create columns in Google Sheets for new ClickUp lists
- Create tasks in ClickUp from new or updated spreadsheet rows in Google Sheets
- Add new ClickUp lists to Google Sheets as multiple rows
- Create ClickUp subtasks from new or updated Google Sheets team drive spreadsheet rows
- Update tasks in ClickUp for every new spreadsheet row in Google Sheets
- Create spreadsheets in Google Sheets from new folders in ClickUp
- Create custom actions in ClickUp for every new worksheet in Google Sheets
- Create copies of worksheets in Google Sheets for new tasks in ClickUp
- Create spreadsheet rows in Google Sheets for new folders in ClickUp
- Create new worksheets in Google Sheets from new folders in ClickUp
- Create Google Sheet rows for new tasks in ClickUp
- Create Google Sheet rows for new task changes in ClickUp
- Create ClickUp lists from new or updated Google Sheets rows
- Create Google Sheets rows for ClickUp task changes.
- Update Google Sheets rows when ClickUp tasks change
- Add rows to Google Sheets for new ClickUp lists
- Create ClickUp task comments from new or updated Google Sheets rows
- Create ClickUp lists from new Google Sheets worksheets
- Update ClickUp tasks from new or updated Google Sheets rows
- Create worksheets in Google Sheets for new ClickUp folders
- Update Google Sheets rows whenever tasks change in ClickUp
- Update Google Sheets rows with new tasks from ClickUp
- Create custom actions in ClickUp for new spreadsheet rows in Google Sheets team drive
- Manage new or updated Google Sheets rows with custom ClickUp actions
- Create duplicates in Google Sheets worksheets for new ClickUp lists
- Create spreadsheets in Google Sheets when tasks change in ClickUp