--- title: Copilot Cowork Handles Gmail & Google Sheets via Power Automate | FlowStudio description: Copilot Cowork built a Power Automate helper flow that searches, drafts, and sends Gmail and reads Google Sheets - no Google plugin needed. Here is how it went. image: https://learn.flowstudio.app/hubfs/blog-featured-images/feature-cowork-gmail-sheets.png --- [Skip to content](https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate#main-content) [![Flow Studio](https://learn.flowstudio.app/hs-fs/hubfs/flow-studio-transparency.png?width=90&height=90&name=flow-studio-transparency.png)](https://flowstudio.app) - [FlowStudio App](https://learn.flowstudio.app/) Show submenu for FlowStudio App - [Getting Started](https://learn.flowstudio.app/getting-started) - [Full Text Search](https://learn.flowstudio.app/full-text-search) - [Flow Diagram](https://learn.flowstudio.app/flow-diagram) - [Clipboard & Library](https://learn.flowstudio.app/clipboard) - [Restore a Flow](https://learn.flowstudio.app/restore-power-automate) - [Migrate and Deploy](https://learn.flowstudio.app/migrate-flows) - [Bulk Export Flows](https://learn.flowstudio.app/bulk-export-flows) - [More Info for IT](https://learn.flowstudio.app/more-info-for-it) - [MCP](https://learn.flowstudio.app/mcp-getting-started) Show submenu for MCP - [Getting Started](https://learn.flowstudio.app/mcp-getting-started) - [Which Agent to Use](https://learn.flowstudio.app/mcp-which-agent-power-automate) - [Connect Without Admin Consent](https://learn.flowstudio.app/mcp-browser-key) - [Build Flows with AI](https://learn.flowstudio.app/build-power-automate-flows-with-ai-agents) - [Vibe Code Flows](https://learn.flowstudio.app/vibe-code-power-automate) - [Power Automate in VS Code](https://learn.flowstudio.app/power-automate-ide) - [Debug Flows](https://learn.flowstudio.app/mcp-debug) - [MCP Tools Reference](https://learn.flowstudio.app/mcp-tools) - [Copilot Agent Skills](https://learn.flowstudio.app/mcp-copilot-skills) - [Compare with Microsoft MCP](https://learn.flowstudio.app/compare/flowstudio-mcp-vs-microsoft-power-automate-mcp) - [Pricing & Plans](https://learn.flowstudio.app/mcp-pricing) - [Manage Tenant Plan](https://learn.flowstudio.app/mcp-tenant-plan-admin) - [FlowStudio AI](https://learn.flowstudio.app/flowstudio-ai) - [Teams](https://learn.flowstudio.app/flowstudio-for-teams) Show submenu for Teams - [Manage Workspace](https://learn.flowstudio.app/teams-workspace) - [Adding Permissions](https://learn.flowstudio.app/teams-add-permission) - [Flow Monitoring](https://learn.flowstudio.app/teams-monitoring) - [Flow Report](https://learn.flowstudio.app/teams-report) - [Blog](https://learn.flowstudio.app/blog) - [FAQ](https://learn.flowstudio.app/faq) - [Personal Data](https://learn.flowstudio.app/personal-data) Open main navigation Close main navigation - [FlowStudio App](https://learn.flowstudio.app/) Show submenu for FlowStudio App - [Getting Started](https://learn.flowstudio.app/getting-started) - [Full Text Search](https://learn.flowstudio.app/full-text-search) - [Flow Diagram](https://learn.flowstudio.app/flow-diagram) - [Clipboard & Library](https://learn.flowstudio.app/clipboard) - [Restore a Flow](https://learn.flowstudio.app/restore-power-automate) - [Migrate and Deploy](https://learn.flowstudio.app/migrate-flows) - [Bulk Export Flows](https://learn.flowstudio.app/bulk-export-flows) - [More Info for IT](https://learn.flowstudio.app/more-info-for-it) - [MCP](https://learn.flowstudio.app/mcp-getting-started) Show submenu for MCP - [Getting Started](https://learn.flowstudio.app/mcp-getting-started) - [Which Agent to Use](https://learn.flowstudio.app/mcp-which-agent-power-automate) - [Connect Without Admin Consent](https://learn.flowstudio.app/mcp-browser-key) - [Build Flows with AI](https://learn.flowstudio.app/build-power-automate-flows-with-ai-agents) - [Vibe Code Flows](https://learn.flowstudio.app/vibe-code-power-automate) - [Power Automate in VS Code](https://learn.flowstudio.app/power-automate-ide) - [Debug Flows](https://learn.flowstudio.app/mcp-debug) - [MCP Tools Reference](https://learn.flowstudio.app/mcp-tools) - [Copilot Agent Skills](https://learn.flowstudio.app/mcp-copilot-skills) - [Compare with Microsoft MCP](https://learn.flowstudio.app/compare/flowstudio-mcp-vs-microsoft-power-automate-mcp) - [Pricing & Plans](https://learn.flowstudio.app/mcp-pricing) - [Manage Tenant Plan](https://learn.flowstudio.app/mcp-tenant-plan-admin) - [FlowStudio AI](https://learn.flowstudio.app/flowstudio-ai) - [Teams](https://learn.flowstudio.app/flowstudio-for-teams) Show submenu for Teams - [Manage Workspace](https://learn.flowstudio.app/teams-workspace) - [Adding Permissions](https://learn.flowstudio.app/teams-add-permission) - [Flow Monitoring](https://learn.flowstudio.app/teams-monitoring) - [Flow Report](https://learn.flowstudio.app/teams-report) - [Blog](https://learn.flowstudio.app/blog) - [FAQ](https://learn.flowstudio.app/faq) - [Personal Data](https://learn.flowstudio.app/personal-data) Contact Us Jun 12, 2026, 7:01:50 PM # Microsoft Copilot Cowork now handles my Gmail and Google Sheets ![Picture of Catherine Han](https://learn.flowstudio.app/hs-fs/hubfs/catherine-circle.jpg?width=50&name=catherine-circle.jpg) [Catherine Han](https://learn.flowstudio.app/blog/author/catherine-han) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate) [Twitter icon](https://twitter.com/intent/tweet?url=https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate) [envelope icon](mailto:?body=https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate) **TL;DR:** Microsoft Copilot Cowork has no Gmail or Google Sheets plugin. With the [FlowStudio MCP plugin](https://marketplace.microsoft.com/en-us/product/WA200011013), it did not need one: Cowork walked me through creating a Google API credential, built a Power Automate helper flow that can search, read, draft, reply, and send my Gmail plus read my Google Drive files, and used it to answer a real question buried across my inbox and a spreadsheet. When the flow could not do something yet, Cowork added a new branch mid-conversation. Microsoft Copilot Cowork now handles my Gmail and Google Sheets. Sounds weird, right? I've been badly behind on my personal to-dos lately. Today I finally faced one I'd been dodging: a few weeks ago a tenant told me they're moving out and asked whether they owed me any fees. The answer was buried across my Gmail and a Google Sheet: exactly the kind of "not interesting" admin task my ADHD brain files under "later". My whole headspace right now is agents and automation, so I made a deal with myself: I'd do this task by letting Cowork do it for me. ## Setup took under an hour It started with one question: ![Asking Copilot Cowork whether it can access Gmail through a helper flow](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/01-cowork-ask.png) **Figure:** Asking Cowork whether it can reach Gmail through a helper flow Cowork's first instinct was Microsoft's Gmail connector. It checked what that connector can still do and flagged the catch before building anything: Google restricted it a while back. Send and reply work, but there is no list and no search. ![Cowork's audit of what the Gmail connector still supports - send and reply yes, list and search no](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/02-connector-limits.png) **Figure:** Cowork audits the Gmail connector and flags the catch: send and reply work, list and search don't So Cowork needed a Google API it could call, and it walked me through creating one with Gmail, Drive, and Sheets scopes. I handed over the credential, and it built a helper flow that can search, read, draft, reply, and send my Gmail, plus a second set of actions in the same flow for my Google Drive files. ## The flow grew mid-conversation Mid-conversation, when I asked for something the flow couldn't do yet, it just added a new branch to the flow on the spot, in seconds. Here it is deploying new Drive and Sheets branches with Update live flow, then going straight back to the task. ![Cowork deploying new Drive and Sheets branches to the helper flow mid-conversation, then finding the tenant's notice email](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/03-branches-deployed.png) **Figure:** Cowork deploys new Drive and Sheets branches mid-conversation, then goes back to the task ## The actual task I pointed it at the Google Sheet where I keep the records and asked it to find the move-out date in her emails, then work out her payment history. ![Pointing Cowork at the Google Sheet and asking for the move-out date and payment reconciliation](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/04-sheet-task.png) **Figure:** Pointing Cowork at the Google Sheet to find the move-out date and reconcile the payments It read the notice email, read both tabs of the sheet, matched 51 payments, and came back with the shortfall, plus the two assumptions I should confirm before holding her to the number. ![Cowork's payment review: 51 payments matched, shortfall computed, assumptions flagged for confirmation](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/05-payment-review.png) **Figure:** Cowork's payment review: 51 payments matched, the shortfall computed, two assumptions flagged to confirm When I asked for a sanity check on uncategorised payments, it went through all of them and showed why none were hers. ![Sanity check on uncategorised payments - none belonged to the tenant](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/06-sanity-check.png) **Figure:** A sanity check on the uncategorised payments: none belonged to the tenant By the end, I had a ready-to-send reply sitting in my Gmail drafts, and a clear answer on what the tenant actually owed. ![The ready-to-send draft reply in Gmail with the tenancy summary and rent reconciliation](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/07-gmail-draft.png) **Figure:** The ready-to-send reply waiting in Gmail drafts, with the tenancy summary and reconciliation ## How does Cowork reach Gmail without a Gmail plugin? The tool underneath is FlowStudio MCP. Cowork does not call Google directly. It builds a Power Automate flow that does, then triggers the flow and reads the result. The flow is the tool: Power Automate handles the call and the execution log, and every run lands in run history where I can inspect each step's inputs and outputs. Here is the whole helper flow in the designer: one trigger, a Get token step, and a Switch with a case per capability: send, get, search, reply, draft, plus the Drive and Sheets branches. ![The helper flow in the Power Automate designer: a Switch action with one case per capability across Gmail, Drive, and Sheets](https://learn.flowstudio.app/hubfs/blog-screenshots/cowork-gmail-sheets/08-helper-flow-designer.png) **Figure:** The helper flow in the Power Automate designer: one trigger, a Get token step, and a Switch with a case per capability This is the same helper-flow pattern I wrote about in [Copilot Cowork can act on systems it has no plugin for](https://learn.flowstudio.app/blog/copilot-cowork-power-automate-execution-layer?hsLang=en): if Power Automate can reach a system, Cowork can act on it, without waiting for a dedicated plugin. Gmail and Google Sheets just happened to be the first ones my personal life needed. Still wrapping my head around what it makes possible. ## Try it The FlowStudio MCP plugin is on the [Microsoft Marketplace](https://marketplace.microsoft.com/en-us/product/WA200011013). Setup steps are at [learn.flowstudio.app/mcp-cowork-setup](https://learn.flowstudio.app/mcp-cowork-setup?hsLang=en), and the free Starter plan at [mcp.flowstudio.app](https://mcp.flowstudio.app?utm_source=hubspot&utm_medium=content&utm_campaign=blog-copilot-cowork-gmail-google-sheets-power-automate) is enough to try the pattern on your own backlog. --- **About FlowStudio MCP:** [FlowStudio MCP](https://mcp.flowstudio.app?utm_source=hubspot&utm_medium=content&utm_campaign=blog-copilot-cowork-gmail-google-sheets-power-automate-footer) is a Model Context Protocol server that gives AI agents action-level visibility into Power Automate. It is [listed on GitHub’s awesome-copilot](https://github.com/github/awesome-copilot/tree/main/skills/flowstudio-power-automate-mcp), the Microsoft-maintained list of recommended skills for AI coding agents. Works with Microsoft Copilot Cowork, Copilot Studio, GitHub Copilot, Claude, and any MCP-compatible agent. **Related reading:** - [Copilot Cowork can act on systems it has no plugin for](https://learn.flowstudio.app/blog/copilot-cowork-power-automate-execution-layer?hsLang=en) - [Set Up FlowStudio MCP in Microsoft 365 Copilot Cowork](https://learn.flowstudio.app/mcp-cowork-setup?hsLang=en) - [Which AI Agent Should You Use With FlowStudio MCP?](https://learn.flowstudio.app/mcp-which-agent-power-automate?hsLang=en) --- *Catherine Han, [FlowStudio](https://flowstudio.app)* Microsoft, Microsoft 365, Copilot, Copilot Cowork, and Power Automate are trademarks of the Microsoft group of companies. Gmail, Google Sheets, and Google Drive are trademarks of Google LLC. FlowStudio is not affiliated with or endorsed by these companies; names are used for identification only. [Insights & Tips](https://learn.flowstudio.app/blog/tag/insights-tips), [MCP](https://learn.flowstudio.app/blog/tag/mcp), [Power Automate](https://learn.flowstudio.app/blog/tag/power-automate), [AI Agents](https://learn.flowstudio.app/blog/tag/ai-agents), [Microsoft 365 Copilot](https://learn.flowstudio.app/blog/tag/microsoft-365-copilot) ## Related posts [![](https://learn.flowstudio.app/hs-fs/hubfs/blog-featured-images/feature-cowork-execution-layer.png?height=200&name=feature-cowork-execution-layer.png)](https://learn.flowstudio.app/blog/copilot-cowork-power-automate-execution-layer?hsLang=en) [Insights & Tips](https://learn.flowstudio.app/blog/tag/insights-tips), [MCP](https://learn.flowstudio.app/blog/tag/mcp), [Power Automate](https://learn.flowstudio.app/blog/tag/power-automate), [AI Agents](https://learn.flowstudio.app/blog/tag/ai-agents), [Microsoft 365 Copilot](https://learn.flowstudio.app/blog/tag/microsoft-365-copilot) ## [Copilot Cowork can act on systems it has no plugin for](https://learn.flowstudio.app/blog/copilot-cowork-power-automate-execution-layer?hsLang=en) ![Picture of Catherine Han](https://learn.flowstudio.app/hs-fs/hubfs/catherine-circle.jpg?width=50&name=catherine-circle.jpg) [Catherine Han](https://learn.flowstudio.app/blog/author/catherine-han) Jun 12, 2026, 7:01:16 PM TL;DR: Microsoft Copilot Cowork (Microsoft's agent workspace in Microsoft 365, not Anthropic's... [Read more](https://learn.flowstudio.app/blog/copilot-cowork-power-automate-execution-layer?hsLang=en) [![M365 Copilot can debug Power Automate](https://learn.flowstudio.app/hs-fs/hubfs/blog-featured-images/thumbnail-v38-v2.png?height=200&name=thumbnail-v38-v2.png)](https://learn.flowstudio.app/blog/copilot-studio-mcp-debug-power-automate?hsLang=en) [Insights & Tips](https://learn.flowstudio.app/blog/tag/insights-tips), [Debugging](https://learn.flowstudio.app/blog/tag/debugging), [MCP](https://learn.flowstudio.app/blog/tag/mcp), [Power Automate](https://learn.flowstudio.app/blog/tag/power-automate), [AI Agents](https://learn.flowstudio.app/blog/tag/ai-agents), [Vibe Coding](https://learn.flowstudio.app/blog/tag/vibe-coding), [Copilot Studio](https://learn.flowstudio.app/blog/tag/copilot-studio), [M365 Copilot](https://learn.flowstudio.app/blog/tag/m365-copilot), [Microsoft 365 Copilot](https://learn.flowstudio.app/blog/tag/microsoft-365-copilot), [Debug](https://learn.flowstudio.app/blog/tag/debug) ## [How to Connect a Custom MCP Server to Copilot Studio to Debug Power Automate](https://learn.flowstudio.app/blog/copilot-studio-mcp-debug-power-automate?hsLang=en) ![Picture of Catherine Han](https://learn.flowstudio.app/hs-fs/hubfs/catherine-circle.jpg?width=50&name=catherine-circle.jpg) [Catherine Han](https://learn.flowstudio.app/blog/author/catherine-han) Apr 16, 2026, 12:06:20 AM Microsoft 365 Copilot, calling get\_live\_flow\_runs on a real Power Automate flow. Inspecting action... [Read more](https://learn.flowstudio.app/blog/copilot-studio-mcp-debug-power-automate?hsLang=en) [![Power Automate designer showing a 4-stage human-in-the-loop flow that uses a Copilot Studio agent to diagnose and fix other flows](https://learn.flowstudio.app/hs-fs/hubfs/blog-featured-images/57-cover-designer-flow.png?height=200&name=57-cover-designer-flow.png)](https://learn.flowstudio.app/blog/power-automate-flow-fixes-other-flows-human-in-the-loop-agent?hsLang=en) [Insights & Tips](https://learn.flowstudio.app/blog/tag/insights-tips), [Debugging](https://learn.flowstudio.app/blog/tag/debugging), [MCP](https://learn.flowstudio.app/blog/tag/mcp), [Power Automate](https://learn.flowstudio.app/blog/tag/power-automate), [AI Agents](https://learn.flowstudio.app/blog/tag/ai-agents), [Vibe Coding](https://learn.flowstudio.app/blog/tag/vibe-coding), [Copilot Studio](https://learn.flowstudio.app/blog/tag/copilot-studio), [M365 Copilot](https://learn.flowstudio.app/blog/tag/m365-copilot) ## [I Built a Flow That Fixes Failed Power Automate Flows](https://learn.flowstudio.app/blog/power-automate-flow-fixes-other-flows-human-in-the-loop-agent?hsLang=en) ![Picture of Catherine Han](https://learn.flowstudio.app/hs-fs/hubfs/catherine-circle.jpg?width=50&name=catherine-circle.jpg) [Catherine Han](https://learn.flowstudio.app/blog/author/catherine-han) Apr 12, 2026, 8:55:15 PM A failed flow sends an HTTP trigger. A Copilot Studio agent reads the run history, produces a... [Read more](https://learn.flowstudio.app/blog/power-automate-flow-fixes-other-flows-human-in-the-loop-agent?hsLang=en) [![Flow Studio](https://learn.flowstudio.app/hs-fs/hubfs/flow-studio-transparency.png?width=90&height=90&name=flow-studio-transparency.png "Flow Studio")](https://flowstudio.app) flowstudio.app --- [Go to FlowStudio MCP](https://mcp.flowstudio.app/) [Go to FlowStudio App](https://flowstudio.app/) [youtube icon](https://www.youtube.com/playlist?list=PLXiXrMydfoLYzS-Ya3yOmYvfEyLbkXhpQ) [linkedin-in icon](https://www.linkedin.com/company/flow-studio-solutions/about/) [envelope icon](mailto:support@flowstudio.app) [link icon](https://flowstudio.app/) Copyright © 2026, Flow Studio Solutions ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Catherine Han", "url" : "https://learn.flowstudio.app/blog/author/catherine-han" }, "dateModified" : "2026-06-12T09:01:50.355Z", "datePublished" : "2026-06-12T09:01:50.000Z", "headline" : "Copilot Cowork Handles Gmail & Google Sheets via Power Automate | FlowStudio", "image" : [ "https://learn.flowstudio.app/hubfs/blog-featured-images/feature-cowork-gmail-sheets.png" ], "mainEntityOfPage" : { "@id" : "https://learn.flowstudio.app/blog/copilot-cowork-gmail-google-sheets-power-automate", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://learn.flowstudio.app/hubfs/flow-studio-transparency.png" }, "name" : "Flow Studio Solutions" } } ```