Back to Integrations
integration integration
integration Google Sheets node

Integrate Google Sheets with 500+ apps and services

Unlock Google Sheets’s full potential with n8n, connecting it to similar Data & Storage apps and over 1000 other services. Automate data management by syncing, validating, and transforming data across platforms. Create adaptable and scalable workflows between Google Sheets and your stack. All within a building experience you will love.

Create workflows with Google Sheets integrations

799 integrations
Sort by:
Popularity
NameOldestNewest

Popular ways to use Google Sheets integration

Google Sheets node

Sync data between multiple Google Spreadsheets

Triggers workflow all two minutes Reads data from a Google Spreadsheet (in example Sheet Data columns A to G) Write the data unchanged in two different Spreadsheets with same Sheet name and columns, expressions are optional)
jan
Jan Oberhauser
Google Sheets node
Telegram Trigger node

Save Telegram daily messages to Google Sheets

A goal for 2022 is to write 1 thing I do each day. Combined with this workflow you will get daily messages via Telegram and when you reply to them they will be saved in a Google Sheet. Note: Make sure to configure your Telegram and Google Sheet credentials! You will also need to modify the functions to have your Telegram username and bot name.*
imnickdev
Nicholas Lewanowicz
Google Sheets node
Webhook node

Transfer data from website to Google Sheets

Take data from website form via webhook and save data into Google Sheets document!
markbowen
Mark Bowen
Google Sheets node
HTTP Request node
Twilio node
Telegram node
Telegram Trigger node

Add data from a photo to Google Sheets

Automatically adding expense receipts to Google Sheets with Telegram, Mindee API, Twilio, and n8n.
isabel
isa024787bel
Dropbox node
Google Sheets node

Add data from Google Sheet to Dropbox

Triggers worfklow all 15 minutes Reads the data from Google Sheet Converts data to XLS Uploads the file to Dropbox
jan
Jan Oberhauser
Google Sheets node

Transform data in Google Sheets

This workflow appends, lookup, updates, and reads data from a Google Sheet spreadsheet. Set node: The Set node is used to generate data that we want to add to Google Sheets. Depending on your use-case you might have data coming from a different source. For example, you might be fetching data from a WebHook call. Add the node that will fetch the data that you want to add to the Google Sheet. Use can then use the Set node to set the data that you want to add to the Google Sheets. Google Sheets node: This node will add the data from the Set node in a new row to the Google Sheet. You will have to enter the Spreadsheet ID and the Range to specify which sheet you want to add the data to. Google Sheets1 node: This node looks for a specific value in the Google Sheet and returns all the rows that contain the value. In this example, we are looking for the value Berlin in our Google Sheet. If you want to look for a different value, enter that value in the Lookup Value field, and specify the column in the Lookup Column field. Set1 node: The Set node sets the value of the rent by $100 for the houses in Berlin. We pass this new data to the next nodes in the workflow. Google Sheets2 node: This node will update the rent for the houses in Berlin with the new rent set in the previous node. We are mapping the rows with their ID. Depending on your use-case, you might want to map the values with a different column. To set this enter the column name in the Key field. Google Sheets3 node: This node returns the information from the Google Sheet. You can specify the columns that should get returned in the Range field. Currently, the node fetches the data for columns A to D. To fetch the data only for columns A to C set the range to A:C. This workflow can be broken down into different workflows each with its own use case. For example, we can have a workflow that appends new data to a Google Sheet, and another workflow that lookups for a certain value and returns that value. You can learn to build this workflow on the documentation page of the Google Sheets node.
harshil1712
ghagrawal17

Supported Actions

Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet
Google Sheets node

About 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.

Related categories

Similar integrations

  • MySQL node
  • Postgres node
  • Notion node
  • Airtable node
  • Google Drive node
  • Google Calendar node
  • MongoDB node
  • Microsoft SQL node
  • Notion Trigger node
  • GraphQL node

Over 3000 companies switch to n8n every single week

Connect Google Sheets with your company’s tech stack and create automation workflows

FAQ about Google Sheets integrations

  • How can I set up Google Sheets integration in n8n?

      To use Google Sheets integration in n8n, start by adding the Google Sheets node to your workflow. You'll need to authenticate your Google Sheets account using supported authentication methods. Once connected, you can choose from the list of supported actions or make custom API calls via the HTTP Request node, for example: you can configure your Google Sheets integration by specifying the spreadsheet ID and the range for data inputs or outputs. Make sure to set up any additional parameters based on your needs, such as reading, writing, or updating data. Finally, test your setup to ensure everything works as expected before running the workflow.

  • Do I need any special permissions or API keys to integrate Google Sheets with n8n?

  • Can I combine Google Sheets with other apps in n8n workflows?

  • What are some common use cases for Google Sheets integrations with n8n?

  • How does n8n’s pricing model benefit me when integrating Google Sheets?

Last week I automated much of the back office work for a small design studio in less than 8hrs and I am still mind-blown about it.

n8n is a game-changer and should be known by all SMBs and even enterprise companies.

in other news I installed @n8n_io tonight and holy moly it’s good

it’s compatible with EVERYTHING

We're using the @n8n_io cloud for our internal automation tasks since the beta started. It's awesome! Also, support is super fast and always helpful. 🤗

Need help setting up your Google Sheets integration?

Discover our latest community's recommendations and join the discussions about Google Sheets integration.
Sergey Komardenkov
sérgio eduardo floresta filho
Julian
therealJMT
Guilherme

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon