How to Automatically Save Gmail Emails to Google Sheets with Make

If you regularly copy details from Gmail into a spreadsheet, Make can automate the job. You can watch for incoming emails and add details such as the sender, subject and received date to a new row in Google Sheets.

Checked: 10 September 2026 against Make's official Gmail, Google Sheets, template and pricing pages. Features and prices can change.

What does this automation do?

The workflow is simple: Gmail → Make → Google Sheets. Make watches Gmail for a new email. When a matching email arrives, the scenario sends the details you choose to Google Sheets and appends them as a new row.

Make currently provides a Gmail Watch Emails trigger and a Google Sheets Add a Row action. Make also publishes an official template designed to create a new Google Sheets row for every new Gmail email.

When is Gmail to Google Sheets useful?

This setup makes sense when emails contain information you repeatedly need to record. Examples include enquiries, leads, orders, support requests, applications or messages from a particular sender.

You do not have to log your whole inbox. A better setup for many people is to use filters or criteria so only relevant messages reach the spreadsheet.

Step 1: Prepare your Google Sheet

Create a spreadsheet and add headings for the information you want to capture. A simple starting point is Date, Sender, Subject and Email. Keeping clear column headings makes mapping the Gmail data easier later.

Step 2: Create a scenario in Make

Sign in to Make and create a new scenario. Add Gmail as your first module. Make's official Gmail and Google Sheets integration instructions say to add the Gmail module, create the connection and link your Google account.

Step 3: Add the Gmail Watch Emails trigger

Select Gmail's Watch Emails trigger. Make describes this trigger as running when a new email is received in your mailbox. Configure it around the messages you actually want to capture rather than automatically treating every email as useful data.

Step 4: Add Google Sheets

Add a Google Sheets module after Gmail and connect your Google account. Choose Add a Row. Make says this action appends a new row to the bottom of the table.

Step 5: Map your Gmail data to the spreadsheet

Select the spreadsheet and sheet you prepared. Then map the Gmail information to the matching columns. For example, map the sender to your Sender column, the subject to Subject and the email date to Date.

Step 6: Test the scenario

Run the scenario with a suitable test email and check the resulting spreadsheet row. Confirm each value has landed in the correct column. If something looks wrong, fix the mapping before turning the scenario on.

Step 7: Turn the automation on

Once the test works, activate the scenario. The exact frequency available depends on your Make plan. Make's current Free plan has a 15-minute minimum interval between scheduled runs, while paid plans offer more scheduling control.

How much does Make cost?

Make currently lists a Free plan at $0 with up to 1,000 credits per month. Its pricing page says each module action in a scenario, such as adding a Google Sheets row or fetching Gmail data, counts as a credit. Check Make's current pricing before choosing a paid plan because prices and allowances can change.

Should you use Make's official template?

It can be a useful shortcut. Make currently publishes an official template called Create a new Google Sheets row for every new email received in Gmail. It uses Gmail, Text parser and Google Sheets to log new email details. Building the workflow yourself can be better if you only want selected messages or specific fields.

Is this worth automating?

If you copy the same type of email information into a spreadsheet regularly, yes. Start with a narrow rule and a few fields. Once it works reliably, you can add filters or other steps rather than building a large workflow from the start.

If you want more Gmail ideas, read 7 useful ways to automate Gmail with Make. You can also see my 10 Make automation ideas or Make.com review.

Comparing platforms first? See Make vs Zapier or Make vs n8n.