Connect Harvest and Google Sheets integrations
Connect Harvest and Google Sheets with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like Harvest and Google Sheets to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.
Triggers when a new client is created.
Triggers when a new contact is created.
Triggers when a new invoice is created.
Triggers when a new project is created.
Triggers when a new task is created.
Triggers when a new time entry is created.
Triggers when a new user is created.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specific cell.
Clears values from a specific row.
Clears a specified range of values from a spreadsheet.
Copies a sheet to another spreadsheet.
Creates a new spreadsheet.
Creates a new spreadsheet from a template sheet.
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.
Renames a specific sheet.
Updates a specific cell.
Updates a row.
Returns a sheet’s content defined by range values.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Harvest and Google Sheets integrations.
Create custom Harvest and Google Sheets workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Popular Harvest and Google Sheets workflows.
Looking to get more out of Harvest and Google Sheets? With Make you can visually integrate Harvest and Google Sheets into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
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](https://developer.revolut.com/docs/build-banking-apps/#tutorials-tutorials-work-with-draft-payments-international-payments). 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.
TRY IT ->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, Make will automatically create a new Recipient in Payment Rails and record it in Google Sheets.
TRY IT ->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.
TRY IT ->Send Expenses from Harvest to Google Sheets
List all expenses meeting specified criteria and send them to Google Sheets. In this scenario [this template](https://docs.google.com/spreadsheets/d/1n6TQcububd8LnC6lbpe__PxbXhMq5EvPiwXyiTxXVlw/edit?usp=sharing) was used.
TRY IT ->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.
TRY IT ->Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. [Learn more](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796?utm_source=make&utm_medium=in-app&utm_campaign=template)
TRY IT ->Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. [Learn more about webhooks!](https://www.make.com/en/help/tools/webhooks)
TRY IT ->Sync Facebook Lead Ads leads with Google Sheets
Seamlessly capture and organize new Facebook Lead Ads leads by automatically adding them to a Google Sheets spreadsheet. Streamline your lead management process and enhance productivity with this efficient automation solution.
TRY IT ->Send a Gmail email from a new Google Sheets row
Effortlessly send Gmail messages when a new row is added to your Google Sheets. Just ensure your spreadsheet includes these columns: - Email Address - Subject - Content
TRY IT ->
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
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."
"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."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
