Export Gmail to Google Sheets

“How do I automate lead importing from Gmail to a spreadsheet?”
“How do I parse and extract data from Gmail to Google Sheets?”
“How do I convert an email to a spreadsheet?”

– Disgruntled salesperson

It’s no secret that Gmail management is demanding work. As marketers, we have to stay on top of everything from analytics to customer support and email campaigns. It’s tough to juggle work when you’re also responsible for handling almost all the work, especially on the technical side.

You’re switching between your Gmail and other tools like a headless chicken. In this article, I’ll show a simple hack on how to automate this nightmarish task. No code and scripts are required!

Who Benefits from this Automation?

I see two groups that might benefit from the automation to export Gmail to Google Sheets. Both teams require time to constantly update email messages.

a) Business Development and Sales teams: A salesperson who is involved in Lead Generation saves time when leads are automatically sent to a spreadsheet and does lead matching.

b) Email Outreach teams: An email outreach person benefits from this automation when an email campaign, especially bulk ones, has a high response rate.

Requirements

a) A Google Workspace or a GSuite subscription. The email to retrieve data from should be a company email like hello@companyname.com. A personal Gmail account like yourname@gmail.com has extra steps that are beyond this article. I like to keep this tutorial simple and easy to follow.

b) An Integromat account.

Why Pay for Automation at All?

Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, instead, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price. You choose.

busy desktop

I hate a super cluttered desktop. Ever experienced a desktop (or Downloads folder) full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all this.

What is Integromat?

Integromat is a powerful integration platform that allows you to visualize, design, and automate your work in minutes. In other words, it lets apps talk to each other so that you can remove repetitive tasks.

Integromat supports a multitude of integrations and apps across the board. From email to spreadsheets, to forms, to to-do lists, Integromat has you covered. Automate any part of your marketing operation one way or another. You’re like Iron Man with different technologies in the palm of your hand.

Create an Integromat account and get started.

How to Connect and Export Gmail to Google Sheets

1 – Click on Templates. The tool already has a template since this scenario is a standard case.

integromat 02b

2 – Find and click on the Email Google Sheets template.

gmail to sheets integromat 4

2 – Click on the Create new scenario from template button from the lower left of the page.

integromat 03

Setting Up Gmail Connection

First is setting up the Gmail connection under the Email module.

1 – Under Connection click on Add.

gmail to sheets integromat 6

2 – Under Connection type, select Google Restricted.

Important Note: Using a personal @gmail.com address has extra steps. This article assumes that you’re using a professional email like hello@companyname.com. Otherwise, you need to connect using custom authentication.

3 – Under Connection name, name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

gmail to sheets integromat 7

4 – Click on Continue. A pop-up window appears.

5 – Inside the pop-up window, click on the Gmail account you want to select.

integromat 04

6 – Click on Allow. Integromat asks permission to access your Google account. This is standard procedure. The window closes after clicking it.

integromat 05

7 – Back in Integromat, under Folder is where you select the folder from Gmail that you want to connect. Start with All Mail as an example. This changes depending on your specific cases.

8 – Under Criteria, select if you want to retrieve All emails, Only Read emails, and Only Unread emails. Select All emails as an example.

9 – Under Maximum number of results, select the number of emails you want to retrieve. Select 50 as an example.

gmail to sheets integromat 8

10- Click on Continue.

11 – Under Choose where to start, if it appears, select All emails.

gmail to sheets integromat 5

Done! At this point, you’re finished with the email connection side.

Setting Up Google Sheets Connection

Next is setting up the Google Sheets connection. But first, you need to go to Google Drive and create a new Google Sheets file.

1 – Go to your Google Drive workspace.

2 – Click on + New then create a new Google Sheets file.

tmr 0
tmr 00

3 – Name the Google Sheets file. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

gmail to sheets integromat 9

4 – Name the tab or sheet on the bottom. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

gmail to sheets integromat 10

5 – Name the headers. It’s helpful to map out the correct data point in the integration process.

Column A: Email Number
Column B: Email of Sender
Column C: Subject Line
Column D: Body Email

gmail to sheets integromat 11

The first steps are done! Go back to Integromat.

1 – Under Connection, click on Add.

2 – Name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

gmail to sheets integromat 12b

3 – Click on Continue. A pop-up window appears.

4 – Inside the pop-up window, select the Gmail account that stores the Google Sheets file.

integromat 04

5 – Click Allow. Integromat asks permission to access your Google account. This is standard procedure. The window closes after clicking it.

gmail to sheets integromat 13

6 – Back in Integromat, under Mode, choose Select spreadsheet and sheet. This is to make the integration simpler.

7 – Under Spreadsheet, choose the Google Sheets file you created earlier. Find the name you gave it.

8 – Under Sheet, choose the Google Sheets tab from earlier. Find the name you gave it. After which, the ‘Values’ are created.

gmail to sheets integromat 15

9 – Under Values is where it gets tricky. The headings from the Google Sheets file are the parameters where you decide the values. Once you click the field, you’re presented with different parameters. Don’t be overwhelmed. Read the context of the parameters to know which one is mapped to which.

gmail to sheets integromat 17

Under (A), which is Email Number, select Email ID (UID).
Under (B), which is Email of Sender, select email address of Sender.
Under (C), which is Subject Line, select Subject.
Under (D), which is Body Email, select Text content.

Parameters like Attachment or Date are also available. Make sure to add an extra column and name it on the Google Sheets spreadsheet so on and so forth.

10 – Click on Continue. Now it’s time to run and process the integration.

11 – Click on Run once with a play button icon.

integromat 06

A spinning wheel and a Log on the bottom right appear. Wait for the integration to finish. How long the integration takes depends on the Maximum number of results you select. It’s finished when a) green checkmarks appear, and when b) The scenario run was completed appears in the Log.

processing

Go to your Google Sheets file and you now see the emails successfully exported from Gmail.

gmail to sheets integromat 19

Viola! Congratulations you exported emails from Gmail to Google Sheets with complete information! You may also add other parameters or fields if you need them.

Schedule Automation and Reports

Integromat can schedule the automation based on cycles. The schedule is up to you.

1 – On the screen, click on the Scheduling button and turn it on.

integromat 06

2 – Under Run scenario, select the schedule you need. What you select on this parameter dictates the next ones.

If you select At regular intervals, you need to select the minutes that Integromat processes the automation.

If you select Once, you need to select the date.

If you select Every day, you need to select the time.

If you select Days of the week or Days of the week, you need to select the days.

gmail to sheets integromat 18b

3 – Click on Activate. Ignore any advanced settings for now.

Viola! Congratulations you’re automating Gmail exports to Google Sheets!

More articles on automation:
Import Shopify Data to Google Sheets
Import Google Ads Data to Google Sheets
Import WooCommerce Data to Google Sheets
Import Facebook Page Insights to Google Sheets
Import LinkedIn Ads API Data to Google Sheets
Import Facebook Ads Data to Google Sheets
Connect Mailchimp to Google Sheets

Conclusion: Send Gmail to Google Sheets Faster

Running a business is a never-ending cycle of work. This no-code solution doesn’t need you to learn coding or Python. It’s frustrating to juggle all of your responsibilities. Invest in tool automation and avoid repetitive tasks. Integrate apps you use every day. Time is precious for you so get back to doing what matters most: growing your business.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 5 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.