Formulas that take your Gmail account and optional search criteria.
The Gmail Pack offers four formulas to grab Threads and Thread counts, and Messages and Message counts from your inbox based on specific filter criteria. Try adding them to your table columns to bring in specific inbox results!
ThreadCount()
Returns the count of email threads in your Gmail account that match the specified Gmail search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search:The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important"
Returns email threads that match the provided search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search:The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important"
💡 Hint: For a list of available options, see:
Returns emails that match the provided search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search:The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important"
💡 Hint: For a list of available options, see: