See llms.txt for all machine-readable content.

Google Sheets and Microsoft Excel 365 integration

Save yourself the work of writing custom integrations for Google Sheets and Microsoft Excel 365 and use n8n instead. Build adaptable and scalable Data & Storage, Productivity, workflows that work with your technology stack. All within a building experience you will love.

How to connect Google Sheets and Microsoft Excel 365

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google Sheets and Microsoft Excel 365 integration: Create a new workflow and add the first step

Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel

How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: Change the website to scrape in the "Fetch website content" node Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).

Build your own Google Sheets and Microsoft Excel 365 integration

Create custom Google Sheets and Microsoft Excel 365 workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google Sheets supported actions

Microsoft Excel 365 supported actions

Google Sheets and Microsoft Excel 365 integration details

Google Sheets

Google Sheets

Google Sheets is a web-based spreadsheet program offered by Google for free. It similar to Microsoft Excel, and can be accessed anywhere on any device, you only need a Google account.

Microsoft Excel 365

Microsoft Excel 365

Microsoft Excel is the most famous spreadsheet tool in the world. It is developed by Microsoft as part of their Office Suite. It is widely used by individuals, professionals, developers, and companies for many uses in statistics, accounting, data analysis, etc.

FAQ about Google Sheets integrations

Need help setting up your Google Sheets and Microsoft Excel 365 integration?

Discover our latest community's recommendations and join the discussions about Google Sheets and Microsoft Excel 365 integration.

  • sw2025

    Is the Google Sheets Node not working for anyone else (not a newbie)?

    sw2025

    Not a newbie to n8n - Have successfully used the G-sheets nodes many times in the past with the same credentials, never an issue. Today I’m trying to create a new automation that requires using the G-Sheets nodes - cann…

    Open topic
  • Tenzin Nyima 10B15

    How to Update Multiple Rows in Google Sheets at Once in n8n?

    Tenzin Nyima 10B15

    Hi everyone I’m currently learning n8n and experimenting with Google Sheets automation. I’ve set up a workflow (screenshot attached) that includes: Trigger: “When chat message received” AI Agent connected to: Goog…

    Open topic
  • Sergey Komardenkov

    Google Sheets Action is not picking up a list of available Sheets despite seeing the document itself

    Sergey Komardenkov

    Describe the problem/error/question I am testing a workflow where the final action is addition of a row into a Google sheet. I have created a new sheet, I gave it Edit permissions by link just in case, and of course I ad…

    Open topic
  • Filbert Henrico

    Seeking help to look for Pivot table or any formula operation in Google Sheet

    Filbert Henrico

    Hi there, I am using free service in n8n and I am looking for a support to provide information whether there is an option for pivot table or vlookup formula in the operation section for google sheet? Is it something th…

    Open topic
  • Boba228ai

    Switch Node with Google Doc File Problem

    Boba228ai

    Hello everyone! I set up workflow file transfer in supabase. Google Drive trigger receives file data, transfers it to switch, it determines what kind of file it is (google sheet, google doc, pdf) and then transfers it to…

    Open topic

Looking to integrate Slack and VirusTotal in your company?

Trusted by teams building smarter workflows.

Why

Why use n8n to integrate Google Sheets with Microsoft Excel 365

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

Simple enough to 
understand + sophisticated 
enough to ship