Skip to content
ClickRuntime

Connect Google Sheets to Outlook

Plenty of businesses run email on Microsoft 365 but keep their lists and trackers in Google Sheets. Connecting Outlook and Sheets lets the sheet drive the emails you send, and turns what arrives in your inbox into tidy rows, without copying between the two.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Outlook

Sales logs with thank-you emails, inbox sorting, lead outreach, invoice checks and weekly reports by email. These are ready-made starting points. Anything else you can describe works too.
The moment it happens

Log each sale to a sheet and send a thank-you from Outlook

Every new sale is added to your sales sheet and the buyer gets a personal thank-you email from your Outlook address.

See how it works
Every 10 minutesAI

Sort your Outlook inbox with AI and log it to a sheet

New emails get an Outlook category and a one-line summary in a sheet, and simple questions get a reply draft waiting for you.

See how it works
Hourly

Email new leads in your sheet from Outlook

Each new lead added to your sheet gets a personal email from your Outlook, and the row is marked as sent with the date.

See how it works
Every 15 minutesAI

Check emailed invoices against your purchase order sheet

Invoices arriving in Outlook are read, matched to your purchase orders in a sheet, and anything that doesn't match is flagged to you.

See how it works
Weekly

Email a weekly summary of your tracking sheet from Outlook

Every Monday your stakeholders get an email from your Outlook with this week's numbers from your tracking sheet and how they changed.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Outlook, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Outlook automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Outlook in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Every morning, email each client in my Renewals sheet from Outlook if their renewal date is in exactly 30 days, and skip anyone with "Do not contact" in column F.

Log every Outlook email from my top 20 clients listed in my Clients sheet, and highlight any the AI judges to be a complaint.

Use cases

Why people connect Google Sheets and Outlook

How the two apps work together

  • Microsoft Graph can notify a trigger link about new Outlook messages, or the script checks the mailbox every few minutes.
  • The script checks the Google Sheet for new or changed rows every few minutes, since Sheets does not send webhooks without extra setup.
  • Sent emails, statuses and extracted details are written back to the sheet so each row shows what happened.

  • Sales teams email leads from a sheet

    New rows in a leads sheet get a personalised first email from the rep's Outlook mailbox. The send date is written back to the row.

  • Office managers send reminders from a list

    Renewal dates, certificate expiries or rent due dates in a sheet trigger reminder emails from Outlook. Nobody has to watch the calendar.

  • Operations log incoming requests

    Emails to an Outlook inbox are logged to a sheet with sender, subject and an AI category. The team works the sheet as a simple queue.

  • Finance tracks invoices received by email

    Invoice emails are read and the supplier, amount and due date are added to a payables sheet. Month-end has one list to check.

More apps

Google Sheets, Outlook and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Sheet leads emailed from Outlook with a Slack note

When a new lead row appears in my Leads sheet, send them an intro email from my Outlook and post their name and company in #sales on Slack.

Outlook replies logged to a sheet and HubSpot

When a lead from my sheet replies to my Outlook email, mark the row as Replied and create a HubSpot contact with the reply text as a note.

Mirror Outlook invoice data in Excel

When an invoice email arrives in Outlook, add the supplier and amount to my Google Sheet and to the Payables table in my Excel workbook on OneDrive.

Setup

Connect Google Sheets and Outlook once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Outlook

Email

  1. At entra.microsoft.com, go to Identity → Applications → App registrations → New registration. Choose single tenant for a work account, or any organisation plus personal accounts for Outlook.com, and add the Web redirect URI https://clickruntime.com/oauth/callback.
  2. Under Certificates & secrets, create a new client secret and copy its value straight away.
  3. Under API permissions, add Microsoft Graph delegated permissions Mail.ReadWrite, Mail.Send, offline_access and User.Read, then grant admin consent if your organisation requires it.
  4. In the ClickRuntime dashboard, open Connections, choose Outlook and enter the Tenant ID, Client ID and client secret.

FAQ

Questions about connecting Google Sheets and Outlook

Can it use my work Microsoft 365 account?
Yes. You connect your Microsoft account in your ClickRuntime dashboard and approve mail access. Some organisations require an admin to approve the connection first.
Which address do emails come from?
Your own Outlook address, so replies come back to your inbox and sent emails appear in your Sent Items.
Does it need access to all my Google files?
No. It only uses the Sheets permission for the spreadsheet you name.
Is there a sending limit?
Microsoft 365 allows up to 10,000 recipients a day per mailbox. For outreach, keep volumes much lower to protect your sender reputation.
Will it overwrite my sheet?
No. It adds rows or updates only the columns you name, such as status or date sent.
Does it send from my mailbox or a shared mailbox?
It can send from your own mailbox, or from a shared mailbox you have Send As rights to in Microsoft 365.
Can emails use values from several columns?
Yes. Any column in the row, such as first name, company or due date, can go into the subject and body.
Will it email the same row twice?
No, if you ask it to record a sent marker in the row or keep state between runs.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Outlook should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude