Google Sheets + ProjectManager

Add new ProjectManager timesheet entries to Google Sheets as spreadsheet rows

Stay organized and on top of every project detail with this efficient workflow. When a new timesheet entry is added in ProjectManager, a row will be created in your Google Sheets to keep a detailed record. This seamless integration offers an excellent solution to manage and track time allocations without missing out on any crucial information, greatly helping project planning and management.

When this happens...
New Timesheet Entry
Triggered when a new timesheet entry is created
TriggerScheduled
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

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

Supported triggers and actions

New User
Triggered when a new user is added to your account
Trigger
Scheduled
Try It
- Project ID
Trigger
Scheduled
Try It
- NameRequired
- Description
- Manager
- Priority
- Status
- Folder
- Target Date
- AccessRequired
Action
Write
- UserRequired
- Task IDRequired
- DateRequired
- HoursRequired
- Notes
Action
Write
- Project IDRequired
Action
Write

Get Project Priorities
Gets a list of all the priorities which can be applied to a project
Action
Write
- ProjectRequired
Action
Write

- Task IDRequired
Action
Write
- ProjectRequired
Action
Write
Get User Roles
Get all the roles which can be assigned to a user
Action
Write
Get User Teams
Get all the teams which a user can be added to
Action
Write
- Task IDRequired
- Field IDRequired
- ValueRequired
Action
Write
- Task IDRequired
- Name
- Description
- Due Date
- Progress
- Priority
- Status ID
Action
Write
- User to UpdateRequired
- First Name
- Last Name
- Phone Number
- Notes
- Teams
- Skills
Action
Write
- First Name
- Last Name
- Email
- Assignable Users Only
- Team
- Skill
- Role
Action
Search
- Date From
- Date To
- Project
- Task
- User
- Order By
Action
Search
- First NameRequired
- Last NameRequired
- EmailRequired
- Assignable Users Only
- Team
- Skill
- Role
- Phone
- Notes
- Teams
- Skills
Action
Search or write
- Date From
- Date To
- Project
- Task IDRequired
- UserRequired
- Order By
- DateRequired
- HoursRequired
- Notes
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 Project
Triggers when a new project is created
Trigger
Scheduled
Try It
- Project
- User
Trigger
Scheduled
Try It
- Project IdRequired
- NameRequired
- Description
- Start Date
- Due Date
- ProgressRequired
- Assignees
- Priority
- Status ID
Action
Write
- First NameRequired
- Last NameRequired
- EmailRequired
- Phone
- Notes
- Role
- Teams
- Skills
Action
Write
Get Project Folders
Get all of the project folders, used to organise your projects
Action
Write
Get Project Statuses
Get all the statuses which can be applied to a project
Action
Write
- Task IDRequired
Action
Write
Get Task Priorities
Get all the priorities which can be applied to a task
Action
Write
- User IDRequired
Action
Write
Get User Skills
Get all the skills which can be applied to a user
Action
Write
Get Account Information
Returns information about the current user including home URL, email, user ID and workspace name
Action
Write
- Project to UpdateRequired
- Name
- Description
- Manager
- Priority
- Status
- Status Update
- Folder
- Target Date
Action
Write
- Timesheet Entry IDRequired
- Hours
- Notes
Action
Write
- Project Name
- Manager
- Priority
- Status
- Folder
Action
Search
- Project
- Assignee
- Priority
- Progress From
- Progress To
- Date From
- Date To
- Task Name
- Summary Task
- Order ByRequired
Action
Search
- NameRequired
- Manager
- Priority
- Status
- Folder
- Description
- Target Date
- AccessRequired
Action
Search or write
- Project IdRequired
- Assignee
- Priority
- Progress From
- Progress To
- Date From
- Date To
- NameRequired
- Summary Task
- Order ByRequired
- Description
- Start Date
- Due Date
- ProgressRequired
- Assignees
- Status ID
Action
Search or write
- 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

About Google Sheets

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

Learn more

Related categories

Similar apps

About ProjectManager

ProjectManager.com is a simple yet powerful online project management tool that enables you and your team to plan, track, monitor and report on your projects in real-time.

Related categories

Project Management

Related Zap Templates

Add new ProjectManager tasks from Google Sheets updates

Related Zap Templates

Add new ProjectManager tasks from Google Sheets updates

Google Sheets + ProjectManager

Add new ProjectManager timesheet entries to Google Sheets as spreadsheet rows

New User

New Task

Create Project

Create Timesheet Entry

Get Project Details

Get Project Priorities

Get Task Fields

Get Task Details

Get Task Statuses (Columns)

Get User Roles

Get User Teams

Update Task Field Value

Update Task

Update User

Search Users

Search Timesheets

Find or Create User

Find or Create Timesheet Entry

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Project

New Timesheet Entry

Create Task

Create User

Get Project Folders

Get Project Statuses

Get Task Field Values

Get Task Priorities

Get User Details

Get User Skills

Get Account Information

Update Project

Update Timesheet Entry

Search Projects

Search Tasks

Find or Create Project

Find or Create Task

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About ProjectManager

Related categories

Related Zap Templates

Related Zap Templates