Harvest, Google Sheets Integrations

Google Sheets
Harvest
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Harvest, Google Sheets integrations

Send a new client in Harvest as a new row to Google Sheets

Send a new client in Harvest as a new row to Google Sheets

When a new client is created in Harvest, a new row with their credentials is added in Google Sheets.


14
Send Expenses from Harvest to Google Sheets

Send Expenses from Harvest to Google Sheets

List all expenses meeting specified criteria and send them to Google Sheets. In this scenario this template was used.


6
Harvest + Google Sheet + Xero

Harvest + Google Sheet + Xero

This template allows you to automatically calculate the total number of hours you spent working for a client during the current month. The calculated data is stored in a Google Sheet but at the same time an invoice is created for the client. Note: In order for this template to work you need to make sure you have an existing record for each of your clients inside your Xero account. The name of each client needs to be the as the one in your Harvest account.


0
Create a new Recipient in Payment Rails when a new Person is added in Harvest and record it in Google Sheets

Create a new Recipient in Payment Rails when a new Person is added in Harvest and record it in Google Sheets

Every time a new user is added in Harvest, Integromat will automatically create a new Recipient in Payment Rails and record it in Google Sheets.


0
Automated employee payments with data grabbed from a time-tracking app

Automated employee payments with data grabbed from a time-tracking app

Retrieve the time tracked by your employees on Harvest, store all the details in Google Sheets and create draft payments using Revolut Business. The setup of the template assumes you have your employee data stored in a Google Sheets sheet. It has to include these columns: Name of the employee and payment details. To see which details are required to create a Revolut draft payment depending on the country, click here. For example, if you're creating a payment to the United Kingdom, your Sheet #2 (the one with the courier information) needs to include an Account Number and a Sort Code; for payment to Germany, it's IBAN and BIC.


0

Triggers

Harvest

Watch Clients

Triggers when a new client is created.

Harvest

Watch Contacts

Triggers when a new contact is created.

Harvest

Watch Invoices

Triggers when a new invoice is created.

Harvest

Watch Projects

Triggers when a new project is created.

Harvest

Watch Tasks

Triggers when a new task is created.

Harvest

Watch Time Entries

Triggers when a new time entry is created.

Harvest

Watch Users

Triggers when a new user is created.

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Actions

Harvest

Create a Client

Creates a new client.

Harvest

Create a Contact

Creates a new contact.

Harvest

Create a free-form Invoice

Creates a new invoice.

Harvest

Create an Expense

Creates a new expense.

Harvest

Create an Invoice Payment

Creates a invoice payment.

Harvest

Create a Project

Creates a new project.

Harvest

Create a Task

Creates a new task.

Harvest

Create a Time Entry

Creates a new time entry.

Harvest

Create a User

Creates a new user. Admin permissions required.

Harvest

Create Invoice Line Item

Adds new line item to specific invoice.

Harvest

Delete a Client

Deletes an existing client.

Harvest

Delete a Contact

Deletes an existing contact.

Harvest

Delete an Expense

Deletes an existing expense.

Harvest

Delete an Invoice

Deletes an existing invoice.

Harvest

Delete a Project

Deletes a project and any time entries or expenses tracked to it. However, invoices associated with the project will not be deleted. If you don’t want the project’s time entries and expenses to be deleted, you should archive the project instead.

Harvest

Delete a Task

Deletes an existing task.

Harvest

Delete a Time Entry

Deletes an existing time entry.

Harvest

Delete a User

Deletes an existing user. Deleting a user is only possible if they have no time entries or expenses associated with them. Admin permissions required.

Harvest

Delete Invoice Line Item

Deletes line item on specific invoice.

Harvest

Edit a Client

Edits an existing client.

Harvest

Edit a Contact

Edits an existing contact.

Harvest

Edit an Expense

Edits an existing expense.

Harvest

Edit an Invoice

Edits and existing invoice.

Harvest

Edit a Project

Edits an existing project.

Harvest

Edit a Task

Edits an existing task.

Harvest

Edit a Time Entry

Edits an existing time entry.

Harvest

Edit a User

Edits an existing user. Admin permissions required.

Harvest

Edit Invoice Line Item

Edits line item on existing invoice.

Harvest

Get a Client

Retrieves information about specific client.

Harvest

Get a Contact

Retrieves information about specific contact.

Harvest

Get an Expense

Retrieves information about specific expense.

Harvest

Get an Invoice

Retrieves information about specific invoice.

Harvest

Get a Project

Retrieves information about specific project.

Harvest

Get a Task

Retrieves information about specific task.

Harvest

Get a Task Assignment

Retrieves information about specific task assignment.

Harvest

Get a Time Entry

Retrieves information about specific time entry.

Harvest

Get a User

Retrieves information about specific user. Admin permissions required.

Harvest

Get a User Assignment

Retrieves information about specific user assignment.

Harvest

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Copy a Sheet

Copies a sheet to another spreadsheet.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Create a Spreadsheet from a Template

Creates a new spreadsheet from a template sheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Searches

Harvest

List Clients

Returns a list of your clients.

Harvest

List Contacts

Returns a list of your contacts.

Harvest

List Expenses

Returns a list of your expenses.

Harvest

List Invoices

Returns a list of your invoices.

Harvest

List Payments

List all payments for an invoice.

Harvest

List Projects

Returns a list of your projects.

Harvest

List Task Assignments

Retrieves a list of your task assignments.

Harvest

List Tasks

Returns a list of your tasks.

Harvest

List Time Entries

Returns a list of your time entries.

Harvest

List User Assignments

Retrieves a list of your user assignments.

Harvest

List Users

Returns a list of your users. Admin permissions required.

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Integrate Harvest, Google Sheets with these services