Extract time entries from Everhour and send them as a table via Gmail

Get this template

Get this template

Apps used in template

Tools

Everhour

Gmail

About

This template periodically extracts time entries from Everhour and sends them as a table via Gmail with these columns:

created at
task name
project name
client name
cost

The scenario is scheduled to run every Monday at 8 am. You can change the scheduling after you are done setting up this template. If you change the frequency, you will also need to change lookback windows in the first module. The current template is configured to send the time entries for the last 7 days.

Trusted by thousands of fast-scaling organizations around the globe

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Save a Gmail email from a specific sender to Google Sheets as a new row

Use this template to save a Gmail message from a specific sender to your Google Sheets spreadsheet as a new row.

Try It ➔

Save a Gmail email to Google Sheets as a new row

Use this template to save a Gmail email message to your Google Sheets spreadsheet as a new row.

Try It ➔

Save a Gmail email containing a specific phrase to Google Sheets as a new row

Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

Try It ➔

Send a Gmail email from a new Google Sheets row

Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Add client inbox label to Gmail

The Google Sheets module checks for matches between the sender’s email address and the list of client email addresses. If a match is found, the label client_mailbox is added to the email. More information here.

Try It ➔

Create a Gmail draft message from a new Google Sheets row

Use this template to create a Gmail draft message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Analyze sentiment in customer feedback on Google Sheets using ChatGPT

Run a simple sentiment analysis of your customer feedback with the power of Artificial Intelligence!

Try It ➔

Create new completions with OpenAI ChatGPT from new rows in Google Sheets

Save time by automatically generating completions to any topic, for example, SEO keywords from your content topics. Learn more

Try It ➔

Save Gmail emails and attachments to Google Sheets and Google Drive

Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

Try It ➔

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.

Add a Time Record

Adds a new time record.

Action

Basic trigger

Generates bundles with their own structure.

Trigger

Compose a string

Composes a string for easier mapping of scenarios.

Transformer

Convert the encoding of a text

Converts a text from one codepage to another.

Transformer

Copy an Email

Copies an email or a draft into a selected folder.

Action

Create a Client

Creates a new client.

Action

Create a Draft

Creates a new draft and adds it to a selected folder.

Action

Create a Project

Creates a new project.

Action

Create a Section

Creates a new section.

Action

FAQ

How do I get started with Make?

What is a scenario?

What is a module?

What is mapping?

How Make works

Thousands of fast-scaling businesses create and automate on Make

See Make in action

See how Make works

Trusted by 500,000+ Makers

"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."

Philipp Weidenbach

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."

Erkki Markus

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