How to connect Google Sheets + Projectworks
Zapier lets you send info between Google Sheets and Projectworks automatically—no code required.
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
- New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger
- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Format a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Finds many matched rows (500 max.) by a column and value.
Scheduled
Action
- Google Sheets
Finds a worksheet by title.
Scheduled
Action
- Google Sheets
Returns many rows (500 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific find worksheet.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- Projectworks
Triggers when a user requests a list of budgets.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of clients.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of Custom Fields
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of leave statuses.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of offices.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of projects.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of timecodes.
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of timesheet entries
Scheduled
Trigger
- Projectworks
Triggers when a user requests a list of users.
Scheduled
Trigger
- Projectworks
Triggers when a new leave request is created
Scheduled
Trigger
- Projectworks
Assigns a user to a timecode
Scheduled
Action
- Projectworks
Creates a Budget
Scheduled
Action
- Projectworks
Creates a new company
Scheduled
Action
- Projectworks
Creates a Project
Scheduled
Action
- Projectworks
Creates a Timecode
Scheduled
Action
- Projectworks
Creates a Timesheet entry
Scheduled
Action
- Projectworks
Sets the resourcing for a given person and project on a given day.
Scheduled
Action
- Projectworks
Updates a budget
Scheduled
Action
- Projectworks
Updates a company
Scheduled
Action
- Projectworks
Updates the value of a custom field for a specific entity
Scheduled
Action
- Projectworks
Updates a project
Scheduled
Action
- Projectworks
Updates a timecode
Scheduled
Action
- Projectworks
Updates a timesheet entry
Scheduled
Action
- Projectworks
Finds a company by name or external reference.
Scheduled
Action
- Projectworks
Finds a currency by its name or code.
Scheduled
Action
- Projectworks
Finds a custom field by entity type and label
Scheduled
Action
- Projectworks
Finds a GL Code by its code or description
Scheduled
Action
- Projectworks
Finds a Module by external reference.
Scheduled
Action
- Projectworks
Finds an Office by name or external reference.
Scheduled
Action
- Projectworks
Finds a project by name or external reference
Scheduled
Action
- Projectworks
Finds an existing task by external reference.
Scheduled
Action
- Projectworks
Finds an existing user by name, email address, or external reference.
Scheduled
Action
How Google Sheets + Projectworks Integrations Work
- Step 1: Authenticate Google Sheets and Projectworks.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.
Google Sheets Tutorials
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.