Google Sheets + Harvest

Add new Harvest Time Entries to a Google Sheets spreadsheet

When this happens
Step 1: New Timesheet Entry
Then do this
Step 2: Create Spreadsheet Row

If you'd like to have your Harvest time entries sent elsewhere for further analysis or reporting, use Zapier to start automatically adding new time entries to a Google Sheets spreadsheet. Once you set up this Harvest-Google Sheets integration, new time entries from that point forward are added as new rows in a spreadsheet.

Try this template

Supported triggers and actions

What does this mean?

New User Assignment
Triggers when a person is assigned to a project.
Trigger
Scheduled
New Client
Triggers when you add a new client.
Trigger
Scheduled
New Contact
Triggers when you add a new contact.
Trigger
Scheduled
New Invoice
Triggers when you add a new invoice.
Trigger
Scheduled
New Invoice
Triggers when you add a new invoice (with line item support).
Trigger
Scheduled

New Person
Triggers when you add a new person.
Trigger
Scheduled
New Project
Triggers when you add a new project.
Trigger
Scheduled

New Task
Triggers when you add a new task.
Trigger
Scheduled

Harvest
Triggers when a new timesheet entry is created for today.
Scheduled
Trigger
Harvest
Adds a new client.
Scheduled
Action
Harvest
Adds a new contact.
Scheduled
Action
Harvest
Creates a project.
Scheduled
Action
Harvest
Creates and starts a timer for the current day.
Scheduled
Action
Harvest
Stops the timer for the current day (if one is running).
Scheduled
Action
Harvest
Adds a new task.
Scheduled
Action
Harvest
Creates a new timesheet entry for the current day.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
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
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 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 lookup row.
Scheduled
Action