Google Sheets Node

Read, write, and manage Google Sheets spreadsheets.

Setup

  1. Go to the Google Cloud Console
  2. Enable the Google Sheets API
  3. Create OAuth credentials or a Service Account
  4. Add a GOOGLE_SHEETS credential in Nodebase
If using a Service Account, share the spreadsheet with the service account email address.

Operations

Read Rows

Fetch rows from a spreadsheet. Specify the Spreadsheet ID, Sheet Name, and Range (e.g. A1:D100).

Output: {{googleSheets.data.rows}}

Append Row

Add a new row to the end of a sheet. Pass an array of values matching the column order.

Update Row

Update a specific row or cell range. Specify the range (e.g. A5:D5) and the new values.

Clear Range

Clear values from a specified range without deleting the cells themselves.

Create Spreadsheet

Create a new spreadsheet with a given title and optional sheet names.

Output: {{googleSheets.data.spreadsheetId}}, {{googleSheets.data.url}}

Combine the Loop node with Google Sheets to process each row individually — e.g. send a personalized email for every row in your spreadsheet.
GmailNotion