Get this template

Harvest + Google Sheet + Xero

Harvest + Google Sheet + Xero

Get this template
Make template animation background

Apps used in template

About

Share

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.

Similar templates for inspiration

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Google Sheets
Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action
Google Sheets
Add a Row

Appends a new row to the bottom of the table.

Action
Google Sheets
Add a Sheet

Adds a new sheet.

Action
Tools
Basic trigger

Generates bundles with their own structure.

Trigger
Google Sheets
Bulk Add Rows (Advanced)

Appends multiple rows to the bottom of the table.

Action
Google Sheets
Bulk Update Rows (Advanced)

Updates multiple rows.

Action
Google Sheets
Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Action
Google Sheets
Clear a Cell

Clears a specific cell.

Action
Google Sheets
Clear a Row

Clears values from a specific row.

Action

FAQ

How do I get started with Make?
What is a scenario?
What is a module?
What is mapping?

See Make in action

See how Make works

image (48)

Trusted by 200,000+ customers

"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."

teleclinic

Head of Operations at Teleclinic

"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."

Cayden Phipps

COO at Shop Accelerator Martech

"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."

Ekki Smaly

Product Owner at Smaily

"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."

Andreas Wixler

CTO & Co-founder at FINN