Skip to content
ClickRuntime

Connect Google Sheets to Microsoft Teams

Teams often keep deadlines, lists and logs in a Google Sheet while they talk in Microsoft Teams. Connect them to have the sheet post reminders and alerts into a Teams channel, and to log what happens back into the sheet.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Microsoft Teams

Reminders, alerts and drafts for review, with a sheet as the list and a Teams channel as the place your team sees them. These are ready-made starting points. Anything else you can describe works too.
Every 10 minutes

Scan email links, log results and alert Teams on bad ones

Links in new emails are checked with VirusTotal, every result is logged in your Security sheet, and malicious ones are flagged in Teams.

See how it works
On a schedule

Post upcoming deadlines from a sheet to Teams

Each morning your Teams channel lists every item in your tracker due in the next two days, with the person responsible.

See how it works
Every 15 minutesAI

Turn sheet briefs into AI drafts reviewed in Teams

Add a brief to your sheet and an AI draft is written into the row and posted to your Teams channel for review.

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 Microsoft Teams, 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 Microsoft Teams automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Microsoft Teams 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 hour, post to our Teams channel any row in my Tracker sheet whose Status changed to Blocked, mentioning the Owner.

Each Monday, use AI to summarize last week's rows in my Feedback sheet and post the top three themes to Teams.

Use cases

Why people connect Google Sheets and Microsoft Teams

How the two apps work together

  • ClickRuntime checks the sheet on a schedule, as often as every 5 minutes.
  • New or matching rows are posted to a Teams channel through your Microsoft connection or an incoming webhook.
  • Teams messages can also be read on a schedule and logged in the sheet.

  • Ops manager posts daily numbers

    A row of daily metrics in a sheet is posted to a Teams channel each morning.

  • Project lead flags overdue tasks

    Rows in a tracker with a past due date are posted to Teams with the owner.

  • Sales team logs wins

    New rows in a Wins sheet are announced in a Teams channel.

  • HR shares new starters

    Rows in a New Hires sheet start a welcome post in Teams on the start date.

More apps

Google Sheets, Microsoft Teams 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.

HubSpot deals to a sheet and Teams

Copy new HubSpot deals to my Deals sheet and post each one to our Teams sales channel.

Sheet reminders by Teams and Outlook

For each row due tomorrow, post to Teams and email the owner from Outlook.

Form answers posted in Teams

When a Google Forms response lands in my sheet, post it to our Teams requests channel.

Setup

Connect Google Sheets and Microsoft Teams 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.

Microsoft Teams

Chat / Collaboration

  1. Register an app in your Microsoft tenant and add the delegated permissions ChannelMessage.Send, Chat.ReadWrite, Team.ReadBasic.All, Channel.ReadBasic.All and offline_access.
  2. Create a client secret for the app and copy its client ID and secret.
  3. In the ClickRuntime dashboard, open Connections, choose Microsoft Teams and enter your app's client ID and secret.
  4. If you only need to post to one channel, you can instead open that channel in Teams, choose Workflows → 'Post to a channel when a webhook request is received', and save the URL as a secret on Connections & secrets.

FAQ

Questions about connecting Google Sheets and Microsoft Teams

Can I use a Google Sheet with a Microsoft 365 team?
Yes. You connect a Google account to read the sheet and a Microsoft account to post in Teams. They do not need to be the same organisation.
Which channel do messages go to?
The Teams channel you choose when you set it up. Different rows can go to different channels if the sheet has a channel column.
Will it remind me about the same row twice?
Each reminder is remembered once sent, so a row is posted once per reminder date, not on every run.
Can the team reply in Teams?
Yes, people can reply in the thread as usual. To change the sheet itself, they update the row, and the next run picks it up.
Does it need a Microsoft 365 admin?
Posting through an incoming webhook usually doesn't. Reading channels may need admin approval.
Can it post formatted cards?
Yes. It can post Adaptive Cards with fields and links.
Can it filter rows?
Yes. Any column can be used to decide what is posted.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Microsoft Teams should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude