Projectworks + Smartsheet

Projectworks + Smartsheet integrations

Instantly add new Projectworks projects to a Smartsheet by creating a row for each in real time

Streamline your project management tasks by connecting Projectworks with Smartsheet. With this effective workflow, new projects created in Projectworks are added directly to Smartsheet. Experience efficient management as the need for manual data input is lessened and smoother coordination between your management and operational processes is realized.

When this happens...
Get ProjectsTriggers when a user requests a list of projects.
TriggerPolling
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Projectworks and Smartsheet

Discover other triggers and actions you can use with Projectworks and Smartsheet

- projectID
Trigger
Polling
Try It
Get Custom Fields
Triggers when a user requests a list of Custom Fields
Trigger
Polling
Try It
Get Offices
Triggers when a user requests a list of offices.
Trigger
Polling
Try It
- moduleID
Trigger
Polling
Try It
Get Users
Triggers when a user requests a list of users.
Trigger
Polling
Try It

- UserID
  Required
- TaskID
  Required
- Hours
- IsActive
  Required
Action
Write
- ClientName
  Required
- AccountManagerID
  Required
- OfficeID
  Required
- ExternalReference
- IsActive
- CurrencyID
  Required
Action
Write

- ProjectName
  Required
- OfficeID
  Required
- ClientID
  Required
- ProjectTypeID
  Required
- ProjectStatusID
  Required
- CurrencyID
  Required
- ProjectManagerID
  Required
- AccountManagerID
  Required
- TaskSelfServiceModeID
  Required
- ExternalReference
Action
Write
- UserID
  Required
- TaskID
  Required
- Date
  Required
- Minutes
  Required
- Comment
Action
Write
- moduleID
  Required
- ModuleName
- glcodeID
- IsActive
- Budget
- ExternalReference
Action
Write
- EntityID
  Required
- EntityTypeID
  Required
- FieldID
  Required
- Value
  Required
Action
Write
- taskID
  Required
- TaskName
- StatusID
- PercentComplete
- ExternalReference
Action
Write
- name
- externalReference
Action
Search
- entityTypeID
  Required
- label
  Required
Action
Search
- externalReference
  Required
Action
Search
- name
- externalReference
- projectNumber
Action
Search
- email
- name
- externalReference
Action
Search
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

Get Clients
Triggers when a user requests a list of clients.
Trigger
Polling
Try It
Get Leave Statuses
Triggers when a user requests a list of leave statuses.
Trigger
Polling
Try It
- clientID
Trigger
Polling
Try It
- iD
- userID
- taskID
- date
- userExternalReference
- taskExternalReference
Trigger
Polling
Try It
- StatusID
  Required
Trigger
Polling
Try It
- ProjectID
  Required
- ModuleName
  Required
- Budget
  Required
- IsServices
  Required
- GLCodeID
  Required
- IsActive
- ExternalReference
Action
Write
- UserID
  Required
- StatusID
  Required
- Date
  Required
- TypeID
  Required
- Hours
  Required
Action
Write
- moduleID
  Required
- TaskName
  Required
- TaskTypeID
  Required
- StartDate
- EndDate
- IsOnTimesheet
- StatusID
- PercentComplete
- ExternalReference
- EnforceTimesheetDates
- IsScheduled
Action
Write
- ProjectID
  Required
- Date
  Required
- ResourceTypeID
  Required
- UserID
  Required
- IsPenciled
  Required
- Hours
  Required
- Comment
- ModeID
  Required
Action
Write
- clientID
  Required
- ClientName
- AccountManagerID
- OfficeID
- ExternalReference
- IsActive
Action
Write
- projectID
  Required
- ProjectName
- ProjectStatusID
- ProjectManagerID
- AccountManagerID
- ExternalReference
Action
Write
- ID
  Required
- IsReviewed
- Minutes
- Comment
Action
Write
- name
- code
Action
Search
- code
- description
Action
Search
- name
- externalReference
Action
Search
- externalReference
  Required
Action
Search
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

About Projectworks

Projectworks is a professional services automation software that connects time and expense tracking, resource management, invoicing, and financial reporting.

HelpHelp

Related categories

Project Management

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases