Quickly Save your Gmail Messages in Evernote with a Google Sheet

Your Evernote account has a secret email address and any email message forwarded to this address is automatically archived as a new note in one of your Evernote notebooks. You can forward PDFs, travel receipts, audio clips, images and other important emails to this email address and they will be archived forever in your Evernote account.

You can send emails from Gmail to your Evernote account manually or you can use services like Zapier or IFTTT to automate the task of creating notes in Evernote from your Gmail mailbox. For instance, you can star a message in Gmail and it is sent to Evernote. Or can you apply the label Evernote to a message inside Gmail and IFTTT will forward the message with attachments to Evernote.

While it is easy to integrate Gmail and Evernote with the help of external services, a downside is that you would need to grant full access to your Gmail mailbox to a third party service. If you are not happy doing that, there’s an alternate solution that uses Google Sheets and it can be implemented in less than a minute.

Let’s see how:

Gmail to Evernote

Send Gmail Messages to Evernote

  1. Click here to copy the Gmail to Evernote spreadsheet in your Google Drive.
  2. Put your Evernote email address (help) and other values in column D. Refer to the illustrated screenshot for details.
  3. Now click the Start button, authorize the script and it will run in the background. Close the sheet and any messages in Gmail with the label Evernote (cell D4) will be sent to your Evernote in specified notebook and tag.

That’s it. The script is open-source and no third-party has access to any of your Gmail or Google Drive data. You can also consider using the Bulk Auto Forward tool for automated sending to other email based workflows like Kindle, Instapaper, Salesforce, WordPress and so on.

Later, if you wish to stop the Google sheet from forwarding your Gmail messages to Evernote, simply click the Stop button. Also, please note that you should only specify tag and notebook names that already exist in your Evernote. If they do not existing, the email will get saved in your default Evernote notebook.

See more Evernote tips & tricks.

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

0

Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.