You can set up a Google Sheets Microsoft Outlook integration two ways: with Zapier, which can add a sheet row for each new Outlook email or send an Outlook email for each new row, or with Microsoft Power Automate, which has a Google Sheets connector made by Microsoft. For a one-time list, you can export Outlook contacts to a CSV file and open it in Sheets. Where they stop: Zapier only sees new rows added at the bottom, Power Automate can't open sheets in shared drives, and neither one reads what an email means or checks the sheet is right. AI agents read the email, update the right row and flag what needs a person.
What a Google Sheets Microsoft Outlook integration has to do
Plenty of small teams run on a Google sheet and an Outlook inbox. Orders, job requests or sign-ups arrive by email, and someone copies each one into the sheet. Or the sheet holds a list, and someone writes an Outlook email for each row. A Google Sheets Microsoft Outlook integration is meant to do that copying for you.
A good connection does more than add a row. It puts the right details in the right columns, updates the row that already exists instead of adding a second one, and keeps going when someone sorts or edits the sheet.
Three ways to connect Google Sheets to Outlook
None of them comes from Google. One comes from Microsoft, one from Zapier, and one is a file you move yourself.
Zapier
- How it works
- You build a zap with one trigger and one or more actions. Outlook triggers include New Email in Personal Inbox, New Email in Shared Mailbox, New Message in Folder and New Calendar Event. Google Sheets actions include Create Spreadsheet Row, Update Spreadsheet Row and Lookup Spreadsheet Row. It works the other way too: a new or updated row can send an Outlook email, make a draft or add an event.
- Good for
- A simple flow in one direction, like a row for each email to a sales inbox, or a thank-you email for each new row.
- Where it breaks
- Zapier's help says new rows only trigger when they are added at the bottom of the sheet, and that deleting rows, sorting, or renaming columns or the sheet can make the zap miss rows or run twice. Sheets in a shared drive need a separate trigger. It copies the email's fields; it can't tell which details in the email body go in which column unless you set that up.
Microsoft Power Automate
- How it works
- Power Automate has a Google Sheets connector published by Microsoft, with actions to insert, get, update and delete rows. You pair it with an Outlook trigger, like when a new email arrives, in a cloud flow.
- Good for
- Teams already on Microsoft 365 who want the flow to live with their Outlook account.
- Where it breaks
- Microsoft's page says sheets in shared drives can't be selected, shared sheets don't show in the file list, and changes made at the same time by other runs or by people editing the sheet aren't supported. The connector allows 100 calls each 5 minutes per connection, and it isn't offered in US Government GCC High.
Export to a CSV file
- How it works
- Outlook can export your contacts to a CSV file. In new Outlook and Outlook on the web it is under People, then Export contacts. You then import the file into Google Sheets.
- Good for
- A one-time list, like moving your contacts into a sheet for a mailing.
- Where it breaks
- It is a copy for that day. Nothing updates after, and Microsoft notes the file has to be UTF-8 for names in some languages to show right.
Arkeo agents
- How it works
- Agents read new email in Outlook, take out the details your sheet tracks, update the row that already exists or add a new one, and check the sheet for blanks and repeats.
- Good for
- Teams whose sheet is the record for orders, jobs or leads that arrive by email.
- Where it breaks
- Anything your rules keep for a person, like an email the agent can't place or a row that doesn't add up, goes to the sheet's owner in one message.
How to connect Google Sheets to Outlook with Zapier
These follow Zapier's and Microsoft's pages. Open them for the screens.
- 1Set up the sheet first
Put column headers in row 1 with no blank rows or columns between them. New rows should always go at the bottom. Agree with your team not to sort or delete rows while the zap is on.
- 2
Make the zapIn Zapier, start a zap with a Microsoft Outlook trigger, like New Email in Personal Inbox or New Message in Folder. Add the Google Sheets action Create Spreadsheet Row, or Lookup Spreadsheet Row first if you want to update rows that already exist.
- 3
Map each column and test
Match each sheet column to a field from the email, like the sender, subject or date. Send yourself a test email and check the row it makes.
- 4Or use Power Automate on Microsoft 365
Make a cloud flow with an Outlook trigger and the Google Sheets Insert row action. If your sheet is in a shared drive, paste the sheet's ID from its web address, since it won't show in the file list.
- 5For a one-time list, export your contacts
In new Outlook, select People, then Export contacts, then Export. The CSV file goes to your Downloads folder. In Google Sheets, import the file.
What still has to be done by hand
The zap or flow moves the email into the sheet. Keeping the sheet right is still someone's job, and the trouble starts once the team uses the sheet the way people use sheets.
Sheets get sorted and edited. Zapier's help says new rows only trigger at the bottom, rows added in the middle can make the zap run again on old data, and deleting rows, sorting, or renaming a column or tab can make it lose track. Microsoft says the same kind of thing for Power Automate: edits made by people while a flow writes to the sheet aren't supported.
Shared drives get in the way. Microsoft's page says sheets in shared drives can't be selected in Power Automate, and Zapier needs a separate shared drive trigger that isn't instant. Many small companies keep their main sheets in a shared drive.
Zaps stop without warning. In one thread on Zapier's community forum, two people said the new row trigger stopped for all their sheets, then fired hours late, until Zapier staff fixed it more than a week later. Zapier's own advice for a slow zap is to turn it off and on again. Someone has to notice the rows stopped coming in.
And an email isn't a row. The zap copies the sender, subject and date. The order number, the job address or the reply that changes a booking sit in the body, and someone still reads each one and types it in.
The agents that do it
Each agent does one job from start to finish in your own Outlook and Google Sheets. Your team talks to them in Slack or Teams.
Client email gets an owner and a reply.
- Reads new mail in your shared mailboxas it lands
- Files it and sends it to the right personright away
- Flags mail no one has answeredevery day
Bad entries fixed before the report goes out.
- Checks sheets for blanks, repeats and odd numbersevery day
- Marks the rows that need a lookper row
- Tells the person who owns the sheetsame day
Your weekly numbers, filled in for you.
- Pulls sales and bookings into your sheetevery Monday
- Compares it to last weekevery Monday
- Sends the summary to your teamMonday morning
Questions
Is my customers' information safe?
Yes. Agents work in your own Outlook and Google Sheets and see only what their job needs. Customer details never go into public AI. Agents connect to AI through business-grade connections audited under SOC 2.
Can I connect Google Sheets to Outlook without Zapier?
Yes. Microsoft Power Automate has its own Google Sheets connector, made by Microsoft, that works with Outlook in a cloud flow. For a one-time list, export your Outlook contacts to a CSV file and import it into Sheets.
Can I send Outlook emails from a Google sheet?
Yes. Zapier can send an Outlook email, or make a draft, for each new or updated row in a sheet. Test it on a copy of the sheet first so nobody gets an email by mistake.
Why did my Google Sheets zap stop adding rows?
Zapier's help says the usual causes are rows added in the middle, deleted or sorted rows, and renamed columns or tabs. Turn the zap off before you change the sheet, then test it again.
What does it cost?
You get the price on the call, along with the hours it saves your team.