Google Sheets + Harvest

Create spreadsheet rows at top in Google Sheets for new time entries in Harvest

Keep track of your time easily with this automation that links the Harvest app to Google Sheets. Whenever a new time entry is added in Harvest, a spreadsheet row is swiftly created at the top of your designated Google Sheets document. This workflow simplifies time management, ensuring your records are always up-to-date and making data analysis even easier.

When this happens...
New Time Entry
Triggers when a time entry is created.
TriggerPolling
automatically do this!
Create Spreadsheet Row at Top
Creates a new spreadsheet row at the top of a spreadsheet (after the header row).
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

Invoice Paid
Triggers when an invoice is fully paid.
Trigger
Polling
Try It
New Client
Triggers when a new client is added.
Trigger
Polling
Try It
New Expense
Triggers when a new expense is added.
Trigger
Polling
Try It
New Project
Triggers when a project is created.
Trigger
Polling
Try It
- Exclude entries created as running timers?
Trigger
Polling
Try It
New User Assignment
Triggers when a user is assigned to a project.
Trigger
Polling
Try It
Timer Stopped
Triggers when a timer is stopped.
Trigger
Polling
Try It
Updated Invoice
Triggers when an invoice is updated.
Trigger
Polling
Try It
- NameRequired
- Address
Action
Write
- ClientRequired
- NameRequired
- Code
- Bill By
- Hourly Rate
- Budget By
- Budget
- Cost Budget
- Notes
Action
Write
- ProjectRequired
- TaskRequired
- HoursRequired
- Spent DateRequired
- Notes
Action
Write
- ProjectRequired
- TaskRequired
- Spent DateRequired
- Notes
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Invoice IDRequired
Action
Search
- NameRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
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
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

Invoice Sent
Triggers when an invoice is sent or marked as sent.
Trigger
Polling
Try It
New Contact
Triggers when new contact is added.
Trigger
Polling
Try It
New Invoice
Triggers when an invoice is created.
Trigger
Polling
Try It
New Task
Triggers when a new task is added.
Trigger
Polling
Try It
New User
Triggers when a new User is added.
Trigger
Polling
Try It
Timer Started
Triggers when a timer is started.
Trigger
Polling
Try It
Updated Client
Triggers when a client is updated.
Trigger
Polling
Try It
- Exclude entries created as running timers?
Trigger
Polling
Try It
- ClientRequired
- First NameRequired
- Last Name
- Email
- Title
- Mobile Phone
- Office Phone
- Fax
Action
Write
- Project
- NameRequired
- Billable By Default
- Default Hourly Rate
- Is Default
Action
Write
- ProjectRequired
- TaskRequired
- Started TimeRequired
- Ended TimeRequired
- Spent DateRequired
- Notes
Action
Write
Stop Timer
Stops any running timers
Action
Write
- Client name
- Client ID
Action
Search
- NameRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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
- 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
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- 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 Harvest

Simple time tracking software and powerful reporting that helps your team thrive.

Related categories

Time Tracking Software

Related Zap Templates

Create spreadsheets in Google Sheets for updated invoices in Harvest

Google Sheets + Harvest

Create spreadsheet rows at top in Google Sheets for new time entries in Harvest

Supported triggers and actions

Invoice Paid

New Client

New Expense

New Project

New Time Entry

New User Assignment

Timer Stopped

Updated Invoice

Create Client

Create Project

Create Time Entry

Start Timer

API Request (Beta)

Find Invoice

Find Task

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

Invoice Sent

New Contact

New Invoice

New Task

New User

Timer Started

Updated Client

Updated Time Entry

Create Contact

Create Task

Create Time Entry (Start & End Times)

Stop Timer

Find Client

Find Project

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

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 Harvest

Related categories

Related Zap Templates

Related Zap Templates