tiagogouvea/gmail-to-google-sheets-script

Search for emails on your gmail account (using a query) and store results on a google sheets

Tiago Gouvêa

Senior Developer coding since 1997 - CEO at App Masters

Daily work technologies

StackOverflow and other communities

I really like to fell part of the developers community. Since I can remember (before 2000s) I used to be part of many communities.

Currently, I'm a Google Developers Group Organizer on my city, and I have already held dozens of events for programmers.

GitHub

I would like to contribute more here, but nowadays 99% of my time coding are on App Masters projects.

Blog

I wrote a blog in portuguese, talking about programming and related topics. Take a look at tiagogouvea.com.br.

Other technologies

---

gmail-to-google-sheets-script's Issues

"Exceeded maximum execution time"

This code can only extract a minimum number of emails before hitting Google's inflexible code execution time limit. (5 min for free accounts, 30 min for paid Google Workspace, or whatever they're calling it now, subscribers.) I can't figure out how to get it to store its progress to make it resumable. Users should expect to expect their emails in small batches if they have a lot of them.

UPDATE: This is really not usable for large email accounts. I just spent several hours re-running the script, and got hit with "Exception: Service invoked too many times for one day: premium gmail". It's going to take me days to get my emails exported. That's not the fault of this script's developer, it's Google being unhelpful, but it's just a fact of trying to use this.

Only update and automatic

Hy.

Can u write script with automatically update Sheet, when get New Email?

Limitations on # of emails pulled?

Thanks for this. Any idea why the pull would cut off after 1030 emails (1 month's worth)?
I have it set up to pull emails since March (after:2020/3/31 before:2020/12/17) but it only returns those since Nov.
Any ideas how to correct? Thank you!

"from:" and "is:sent" not being respected

This is a wonderful code, thanks!

But... it does not respect the "from:" filter :( - native Gmail does neither - it counts the whole conversation tree.

Any ideas how to actually get sent e-mails only?

Sample query:
is:sent from:[email protected] -notwantthisma.il -filename:.ics after:2022/6/15

Result:
Threads' incoming e-mails are included, too.

Expected behavior:
Only sent mails included.