> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/build/google-sheets.md).

# Read rows with Google Sheets in Duaer

In Duaer, Google Sheets defaults to Authentication OAuth2, Resource Sheet, and Operation Get Row(s). You need a googleSheetsOAuth2Api credential.
## Get rows from a sheet

1. Create a googleSheetsOAuth2Api credential (or switch to Service Account in the panel).
2. Search for Google Sheets, connect it after the previous node, and select that credential.
3. Leave Resource on Sheet and Operation on Get Row(s).
4. Choose Document (spreadsheet) and Sheet (tab).
5. Select Execute step. Rows appear as output items.

Other operations include Append Row, Append or Update Row, Update Row, Clear, Create, and Delete.

For in-product tables, prefer [Keep rows in a Duaer data table](/build/data-tables.md). For SQL, see [Read and write Postgres in Duaer](/build/postgres.md).
## Questions

### Does Google Sheets in Duaer default to read or write?

Operation defaults to Get Row(s). Switch to Append Row when you need to write.

## Related

- [Create an Airtable record in Duaer](https://doc.duaer.com/build/airtable.md)
- [Create a Notion page in Duaer](https://doc.duaer.com/build/notion.md)
- [Upload a file with Google Drive in Duaer](https://doc.duaer.com/build/google-drive.md)