Short answer: Use a free Google Apps Script that adds every Gmail message with your chosen label to a Google Sheet, with a link back to the email. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Gmail filter; Add the Inbox log tab; Paste the script; Turn on the 10-minute check; See it work.
How to set it up
- Make a Gmail filter. In Gmail, create a filter for the emails you care about, such as anything with New lead in the subject, and have it apply the label to-sheet.
- Add the Inbox log tab. In your sheet, add a tab called Inbox log with five columns: date, from, subject, preview and link.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below, then run it once. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once.
- Turn on the 10-minute check. Run
installEvery10Minonce, and new labeled emails are logged around the clock. - See it work. Each email becomes a row, and the label is removed so nothing is logged twice. Click the link to open the email.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that adds every Gmail message with your chosen label to a Google Sheet, with a link back to the email.
How do I set it up?
In 5 steps: 1. Make a Gmail filter; 2. Add the Inbox log tab; 3. Paste the script; 4. Turn on the 10-minute check; 5. See it work. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/