Gmail to Google Sheets Inbox Log

Keep a running spreadsheet of incoming e-mail (date, sender, subject and preview), handy for auditing a shared support or orders inbox.

Sign in with your Edesy account; the setup wizard opens on this template.

Category

Operations & Productivity

Type

App automation

Steps

1

Apps

Gmail, Google Sheets

Level

Beginner, about 9 min to set up

How the workflow runs

Point the trigger at the label or address you want logged, such as orders@ or a "Customers" label, then choose the spreadsheet and tab. Every message becomes a row with received time, sender name and address, subject, preview and thread id so you can find it again. Add a status column in the sheet to track which messages were answered.

App trigger · GmailGmail: new e-mailApp action · Google SheetsGoogle Sheets: log e-mail

Steps in order

  1. 1

    Gmail: new e-mail

    Starts the workflow · Gmail

  2. 2

    Google Sheets: log e-mail

    App action · Google Sheets

Apps it connects

  • Gmail
  • Google Sheets

Gmail to Google Sheets Inbox Log: questions

You sign in to Edesy Flow with your Edesy account and the template wizard opens: map each role to a person, pick the app connections it needs, and Flow creates the forms and the workflow for you to edit.

Yes. The workflow opens in the visual builder, where you can add, remove or reorder steps, change who approves, edit the e-mails and add branches.

Related templates