Google Sheets

Read rows from a Google Sheet, add or update rows, and create, clear or delete spreadsheets and their tabs.

Needs a Google Sheets connection — 

Pick a saved connection in the Credential field, or create one from there. It signs in with an OAuth2.

Create a connection →

Try it

工作流 · save-links-to-sheet.awf 4 个步骤

Save All Page Links to Sheet：包含 4 个步骤的工作流，从 When Started 开始，到 Add a row per link 结束。

1. 1 When Started（触发器 — 打开其文档页面） 触发器
2. 2 Collect all links（Get All Link — 打开其文档页面） Get All Link
3. 3 One link per row（Split Out — 打开其文档页面） Split Out
4. 4 Add a row per link（Google Sheets — 打开其文档页面） Google Sheets

在 AWFlow 中打开 复制 .awf

What it does

The Google Sheets node works on three kinds of things (Resource):

• Spreadsheet: list your spreadsheets, get one, create one (optionally with several tabs), delete one, or clear a range of cells.
• Worksheet (a tab inside a spreadsheet): list, get, create, delete, or clear a range.
• Data: get the values of a range, append a row, or update a row. Each comes in two versions: …from Spreadsheet / …into Spreadsheet, where Range names the tab (Sheet1!A1:C10), and …from Worksheet / …into Worksheet, where you pick the tab in Worksheet and Range is just the cells (A1:C10).

For append and update, the node writes one row each time it runs and puts each value under the matching header in the first row of the tab, leaving the other cells empty. With the Worksheet versions, Data shows one field per column, named after those headers, so they are the easiest to fill.

Spreadsheet → List returns up to 10 spreadsheets from your Drive.

If Google returns an error, the node does not stop: it outputs success: false and the message in error. Add an IF on success when a failed write must not go unnoticed.

When to use it

• Log each scraped price, form entry or lead as a new row.
• Read a list of URLs or keywords from a sheet to drive a workflow.
• Update a status column once a row has been processed.
• Use Airtable or Baserow / NocoDB instead if your data lives there.

Inputs and settings

适用于所有选项

设置项	类型	作用
Credential 必填（必填）	Credential	The Credential to use to make request.

16 个选项 · 选择“Resource and Spreadsheet Operation”以查看其设置

Spreadsheet

ListGetCreateDeleteClear

Worksheet

ListGetCreateDeleteClear

Data

Get Values from SpreadsheetGet Values from WorksheetAppend Values into SpreadsheetAppend Values into WorksheetUpdate Values in SpreadsheetUpdate Values in Worksheet

Spreadsheet · List 的设置

没有其他设置。

正在显示 Spreadsheet · List 的设置

Need an operation that isn't listed? — 

Call the Google Sheets API yourself with the HTTP Request node, and pick the same connection in its Credential field.

Use HTTP Request →

• Range uses A1 notation: A1:D (columns A to D, all rows), 2:2 (row 2), or Sheet1!A1:C10 with the tab name. For append, a range covering your table, such as A:D, is enough: Google adds the row after the last filled one.
• Put column names in row 1 before you append: they are the field names shown in Data.
• Value Input Option: User Entered reads values as if you typed them (so =SUM(A2:A9) becomes a formula and 2026-09-10 a date). Raw stores them exactly as text.
• Turn on Include Values In Response to get the written row back in the output.

Outputs

• Output

• Get Values returns range and values, a list of rows, each row a list of cell values. The first row is usually your headers.
• Append and update return what Google reports: the updated range and the number of cells changed (plus the values when Include Values In Response is on).
• Spreadsheet → Get and Create return the spreadsheet with its spreadsheetId, properties and sheets.
• Delete and Clear return success: true; any failure returns success: false and error.

Dependencies and credentials

• Credential (connection, OAuth2): required. See Create a connection.

Google Sheets connects by signing in to your Google account (OAuth). You first create your own Google OAuth client once, with both the Google Sheets API and the Google Drive API enabled (the spreadsheet list is read through Drive): follow Create your OAuth client. Then create a Google Sheets credential, paste the Client ID and Client Secret, click Check connection and approve the Google window. AWFlow asks to read and edit your spreadsheets and to see the names of your Drive files. The sign-in is kept and refreshed for you. See also Create a credential.

Example workflow

1. A Context Menu trigger runs when you right-click a product page.
2. Information Extractor reads name and price from the page text.
3. Google Sheets, Data → Append Values into Worksheet, spreadsheet Price watch, worksheet Products, Range A:D, Data Name = {{ $input.name }}, Price = {{ $input.price }}, URL = {{ $('Context Menu').pageUrl }}, Value Input Option User Entered.
4. IF checks {{ $input.success }} is not false, and a Browser Notification confirms the row.

Common issues

• The output has success: false and “Unable to parse range: …”. Range is not valid A1 notation, or names a tab that does not exist. Check the tab name, and quote it if it has spaces: 'My data'!A1:C.
• Values land in the wrong columns. Row 1 has no headers, or different ones from the Data fields, so values are written in field order. Add or fix the headers, then pick the worksheet again so Data shows the new columns.
• The spreadsheet list is empty or misses files. The Google Drive API is not enabled for your OAuth client, or the file is not among the 10 returned. Enable the API, or pick the spreadsheet by mapping its id.
• “… insufficient authentication scopes” or a 403 error. An API is not enabled, or the sign-in is older than the current permissions. Enable the Sheets and Drive APIs, then click Check connection again on the credential. To delete spreadsheet files, use Google Drive, whose sign-in can manage files.

Related nodes

• Google Drive: manage the spreadsheet files themselves.
• Split Out: turn values rows into one item each.
• CSV: work with a CSV export instead.
• Airtable: a database-style alternative.