ClickUp + Google Sheets
Update custom field values in ClickUp when new rows are added to Google Sheets in team drive
Keep your ClickUp tasks updated with new data from Google Sheets using this workflow. Whenever a new row is added in your Google Sheets team drive, this automation will immediately update the custom field value in ClickUp. This ensures your projects are always reflecting of the latest changes in your data, keeping your team on track and up-to-date.
Keep your ClickUp tasks updated with new data from Google Sheets using this workflow. Whenever a new row is added in your Google Sheets team drive, this automation will immediately update the custom field value in ClickUp. This ensures your projects are always reflecting of the latest changes in your data, keeping your team on track and up-to-date.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Update Custom Field ValueUpdate value of a custom field for a selected task
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.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.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 appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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 foundTask
Include subtask?
Fetch task data?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message TextRequired
Include a link to this Zap?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document name (title)
Subtitle
Markdown Content
Content
Visibility
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.WorkspaceRequired
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
CommentRequired
Include a link to this Zap?
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
Custom task type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IdRequired
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 Custom Fields
View the Custom Fields available on tasks in a specific Team / Space / Folder / List.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind a List of All Tasks
Finds a list of all tasks created in Workspace/Space/Folder/List. Supports Custom Fields.
ActionThis is an event a Zap performs.SearchFind existing data in your appCheck Plan Bandage
WorkspaceRequired
FieldRequired
ValueRequired
Include all shared items?
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
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 appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
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 foundReaction(s)
WorkspaceRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Reaction(s)
WorkspaceRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
Thread
Include a link to this Zap?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DocumentRequired
Name
Content
Subtitle
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field nameRequired
Description
Required in tasks
Pinned
Visible to guests
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
Custom task type
Task Description
Markdown Content
Assignee Emails
Priority
Start Date
Due 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.Name
Subtitle
DocumentRequired
PageRequired
Content
Content edit mode
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.Find the Most Recent Task
Find the most recent task created in Workspace/Space/Folder/List.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Task by ID
Find an existing task by its ID.
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
Space
Folder
List
Document nameRequired
Name match condition
Include archived documents?
ActionThis is an event a Zap performs.SearchFind existing data in your app
About ClickUp
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create rows in Google Sheets for new ClickUp tasks
- Create ClickUp tasks from new Google Sheets rows
- Create Google Sheet rows for new tasks in ClickUp
- Create ClickUp tasks from new or updated Google Sheets rows (Team Drive).
- Update Google Sheets rows when ClickUp tasks change
- Create Google Sheet rows for new task changes in ClickUp
- Create Google Sheets spreadsheets for new ClickUp tasks
- "update ClickUp custom field values from new or updated rows in Google Sheets"
- Create ClickUp tasks from new Google Sheets rows (Team Drive)
- Create ClickUp lists from new Google Sheets rows.
- Create ClickUp tasks for new Google Sheet rows
- Create tasks in ClickUp from new spreadsheets in Google Sheets
- Create Google Sheets rows for ClickUp task changes.
- Create ClickUp subtasks for new or updated Google Sheets rows
- Create ClickUp lists from new or updated Google Sheets rows
- 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
- Create new Google Sheets columns for every new ClickUp task
- Add new ClickUp lists to Google Sheets as multiple rows
- Update ClickUp tasks from new or updated Google Sheets rows
- Update ClickUp tasks whenever new or updated rows appear in Google Sheets
- 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
- Create new ClickUp folders from new or updated Google Sheets spreadsheet rows
- Create rows in Google Sheets from new tasks in ClickUp
- Update and copy worksheets in Google Sheets when task changes occur in ClickUp
- Post attachments in ClickUp for new or updated rows in Google Sheets
- Create Google Sheets rows for new task comments in ClickUp
- Create multiple rows in Google Sheets for new task comments in ClickUp
- Create spreadsheets in Google Sheets for new comments on tasks in ClickUp
- Create spreadsheet rows in Google Sheets for new time entries in ClickUp
- Update Google Sheets rows when new comments on tasks occur in ClickUp
- Create tasks in ClickUp from new rows in Google Sheets
- Create Google Sheets rows for new tasks in ClickUp
- Update tasks in ClickUp when new or updated rows appear in Google Sheets team drive
- Update Google Sheets rows when tasks change in ClickUp
- Create ClickUp tasks from new or updated rows in Google Sheets on team drive
- Record task changes in ClickUp to Google Sheets by creating new spreadsheet rows
- Update tasks in ClickUp when new or updated rows happen in Google Sheets
- Create new tasks in ClickUp from new rows in Google Sheets
- Edit ClickUp document pages when new or updated rows are found in Google Sheets team drive
- Send chat messages in ClickUp each time new or updated spreadsheet rows are detected in Google Sheets
- Add new ClickUp tasks to the top of a Google Sheets spreadsheet as rows
- Create new ClickUp documents from new or updated rows in Google Sheets
- Send ClickUp channel messages for new or updated Google Sheets rows on team drive
- Clear new ClickUp tasks rows in Google Sheets automatically
- Update ClickUp custom field values with new or updated rows in Google Sheets team drive
- Update Google Sheets rows with new ClickUp time entries
- Update ClickUp custom field values with new rows from Google Sheets
- Create top rows in Google Sheets when task changes occur in ClickUp
- Create custom fields in ClickUp for every new or updated row in Google Sheets
- Create spreadsheet rows in Google Sheets for new channel messages posted in ClickUp
- Send direct messages in ClickUp for new or updated rows in Google Sheets
- Update Google Sheets rows when new attachments are added to tasks in ClickUp
- Add new ClickUp reactions to Google Sheets as rows
- Update Google Sheets properties when ClickUp tasks change
Related Zap Templates
- Create rows in Google Sheets for new ClickUp tasks
- 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 Google Sheets rows for ClickUp task changes.
- 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
- Update ClickUp tasks from new or updated Google Sheets 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 rows in Google Sheets from new tasks in ClickUp
- Create Google Sheets rows for new task comments in ClickUp
- Create spreadsheet rows in Google Sheets for new time entries in ClickUp
- Create Google Sheets rows for new tasks in ClickUp
- Create ClickUp tasks from new or updated rows in Google Sheets on team drive
- Create new tasks in ClickUp from new rows in Google Sheets
- Add new ClickUp tasks to the top of a Google Sheets spreadsheet as rows
- Clear new ClickUp tasks rows in Google Sheets automatically
- Update ClickUp custom field values with new rows from Google Sheets
- Create spreadsheet rows in Google Sheets for new channel messages posted in ClickUp
- Add new ClickUp reactions to Google Sheets as rows
- Create ClickUp tasks from new Google Sheets rows
- Update Google Sheets rows when ClickUp tasks change
- "update ClickUp custom field values from new or updated rows in Google Sheets"
- Create ClickUp tasks for new Google Sheet rows
- 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
- Create new Google Sheets columns for every new ClickUp task
- Update ClickUp tasks whenever new or updated rows appear in Google Sheets
- 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
- Update and copy worksheets in Google Sheets when task changes occur in ClickUp
- Create multiple rows in Google Sheets for new task comments in ClickUp
- Update Google Sheets rows when new comments on tasks occur in ClickUp
- Update tasks in ClickUp when new or updated rows appear in Google Sheets team drive
- Record task changes in ClickUp to Google Sheets by creating new spreadsheet rows
- Edit ClickUp document pages when new or updated rows are found in Google Sheets team drive
- Create new ClickUp documents from new or updated rows in Google Sheets
- Update ClickUp custom field values with new or updated rows in Google Sheets team drive
- Create top rows in Google Sheets when task changes occur in ClickUp
- Send direct messages in ClickUp for new or updated rows in Google Sheets
- Update Google Sheets properties when ClickUp tasks change
- Create Google Sheet rows for new tasks in ClickUp
- Create Google Sheet rows for new task changes in ClickUp
- Create ClickUp tasks from new Google Sheets rows (Team Drive)
- Create tasks in ClickUp from new spreadsheets in Google Sheets
- Create ClickUp lists from new or updated Google Sheets rows
- 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
- Add new ClickUp lists to Google Sheets as multiple rows
- 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 new ClickUp folders from new or updated Google Sheets spreadsheet rows
- Post attachments in ClickUp for new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for new comments on tasks in ClickUp
- Create tasks in ClickUp from new rows in Google Sheets
- Update Google Sheets rows when tasks change in ClickUp
- Update tasks in ClickUp when new or updated rows happen in Google Sheets
- Send chat messages in ClickUp each time new or updated spreadsheet rows are detected in Google Sheets
- Send ClickUp channel messages for new or updated Google Sheets rows on team drive
- Update Google Sheets rows with new ClickUp time entries
- Create custom fields in ClickUp for every new or updated row in Google Sheets
- Update Google Sheets rows when new attachments are added to tasks in ClickUp