Airtable + Harvest

Update records in Airtable for new time entries in Harvest

Streamline your project tracking and management process with this automation. Whenever you add a new time entry in Harvest, it updates a record in Airtable instantly. This workflow simplifies record-keeping, letting you focus more on productive tasks and less on manual data entry. Using this setup, you can always keep a clear, updated overview of time spent on projects.

When this happens...
New Time Entry
Triggers when a time entry is created.
TriggerScheduled
automatically do this!
Update Record
Update the values of specific cells in an Airtable record.
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

What does this mean?

Invoice Paid
Triggers when an invoice is fully paid.
Trigger
Scheduled
Try It
New Client
Triggers when a new client is added.
Trigger
Scheduled
Try It
New Expense
Triggers when a new expense is added.
Trigger
Scheduled
Try It
New Project
Triggers when a project is created.
Trigger
Scheduled
Try It
- Exclude entries created as running timers?
Trigger
Scheduled
Try It

New User Assignment
Triggers when a user is assigned to a project.
Trigger
Scheduled
Try It
Timer Stopped
Triggers when a timer is stopped.
Trigger
Scheduled
Try It

Updated Invoice
Triggers when an invoice is updated.
Trigger
Scheduled
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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Invoice IDRequired
Action
Search
- NameRequired
Action
Search
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write

Invoice Sent
Triggers when an invoice is sent or marked as sent.
Trigger
Scheduled
Try It
New Contact
Triggers when new contact is added.
Trigger
Scheduled
Try It
New Invoice
Triggers when an invoice is created.
Trigger
Scheduled
Try It
New Task
Triggers when a new task is added.
Trigger
Scheduled
Try It
New User
Triggers when a new User is added.
Trigger
Scheduled
Try It
Timer Started
Triggers when a timer is started.
Trigger
Scheduled
Try It
Updated Client
Triggers when a client is updated.
Trigger
Scheduled
Try It
- Exclude entries created as running timers?
Trigger
Scheduled
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
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more