How to send new Gmail emails to Google Sheets automatically

By Jake Marsh · Updated

To add new Gmail emails to a Google Sheet automatically, set up an export in Rowcatch, run it once, then choose Every hour, Every 6 hours or Every day in step 5, Keep it up to date. While Chrome is open on that computer, Rowcatch runs the same Gmail search on that schedule and adds a row for each new matching email, skipping any email already in the sheet. The toolbar button shows how many rows were added.

Before you start

You need an export that already works. If you haven't made one, follow how to export Gmail emails to Google Sheets first: pick a template, set the search and columns, preview, create the spreadsheet and export once.

Steps

  1. Open the export in Rowcatch (click the toolbar button, then its name in the list).
  2. Scroll to step 5, Keep it up to date.
  3. Pick how often:
SettingWhen it runs
Off (run by hand)Only when you click Export
Every hourAbout once an hour
Every 6 hoursAbout every 6 hours
Every dayOnce a day, after the hour you choose
  1. For Every day, choose the hour, such as "after 8 AM". If the computer was asleep at that hour, the run happens soon after it wakes.
  2. Leave Chrome running. Scheduled runs happen while Chrome is open on that computer, even with the Rowcatch tab closed.
  3. Check the toolbar button. Its badge counts the rows added since you last opened Rowcatch, and the export shows "Last scheduled run" with the result.

How Rowcatch avoids duplicate rows

Each run reads the same search, then skips what's already in the sheet. Pick the rule under Duplicates in step 4:

Duplicates settingUse it for
One row per email; skip emails already in the sheetLogs, invoices, leads (the default)
One row per conversation (newest email)Support threads or client conversations, one row per thread (later replies to a thread already in the sheet are skipped)
Skip rows whose value in a column is already thereOrders and anything with its own ID, so a resent confirmation isn't added twice
Always add rowsRarely; every run adds every match

A search that keeps its date window short, like newer_than:7d, keeps each run quick. Emails older than the window stay in the sheet; they just aren't looked at again.

Limits worth knowing

  • A scheduled run adds up to 300 emails. If more arrive between runs, the next run picks up the rest.
  • Your plan's monthly email allowance covers scheduled runs too: Starter 1,000 emails a month, Pro 2,000, Business 4,000.
  • A run that fails is retried later, with longer waits after each failure. After five failures in a row, or when Google asks you to sign in again, the schedule pauses and the export says why, with a Resume button.
  • Turning off the computer or quitting Chrome stops the schedule until Chrome is open again.

Several schedules at once

Each saved export has its own search, columns, spreadsheet tab and schedule, so an hourly Orders export and a daily Invoices export can run side by side. Starter includes 1 saved export, Pro 10 and Business unlimited.

Working with the sheet while it updates

Add your own columns, notes, colors and formulas. Rowcatch keeps them, writes new rows below the old ones and lines them up by column name, so moving a column doesn't break the next run. Any email text that starts like a formula is written as plain text.

What it costs

The trial covers your first 100 exported emails or 7 days, whichever comes first, and scheduled runs count toward it like any other export. After that, Starter is $39 a month, Pro $70 and Business $99, per Google account, or $390, $699 or $990 a year. Every plan and the install link are on the Rowcatch page.

Rowcatch: Email Parser to Google Sheets for Gmail

Export Gmail emails to Google Sheets with parsing rules, duplicate checks and scheduled sync 3 plans from $39 a month per Google account.


Questions

Does Rowcatch run when my computer is off?

No. Rowcatch runs inside Chrome on your computer, which is why no email ever goes through a Great Work server. When Chrome opens again, the next run adds anything that arrived in the meantime, as long as it still matches the search.

Can I run it more often than every hour?

Hourly is the fastest schedule. You can click Check what will be exported and Export N emails now any time for an extra run.

Will a scheduled run ever charge me more?

No. Plans are a fixed price. When the month's allowance is used up, runs stop adding rows and Rowcatch says the limit was reached. The allowance resets on the 1st.

Does it update rows when an email changes?

No. Rowcatch adds rows; it doesn't rewrite rows it wrote earlier, so your edits to old rows stay as you left them.


More Rowcatch guides


More Chrome guides