Pull up Gmail history for a particular contact

If you store contacts in Grist, and use Gmail to email them, there is a simple way to create a formula that will open Gmail to a list of conversations with that contact.

  • Basic Formula

    If the contact’s email address is in the column $Email, then write a formula like this:

    from urllib.parse import quote_plus
    "https://mail.google.com/mail/#search/" + quote_plus($Email)

    This will produce a column of clickable links that look like here https://mail.google.com/mail/...

  • Prettier Version

    You can make this link prettier as follow. Add the link text, like “Search Gmail” to the formula, like so:

    from urllib.parse import quote_plus
    "Search Gmail https://mail.google.com/mail/#search/" + quote_plus($Email)

    Then change the column type to Text, and select HyperLink under Cell Format:

    HyperLink Cell Format

    Now you’ll see clickable links, but they’ll show up as Search Gmail.

  • Example in action

    To see this example in action, visit our Lightweight CRM template: