# Google Sheets integration

> Spreadsheet platform for reading, writing, and managing spreadsheet data programmatically.

- Authentication: oauth2

## Tools (12)

- **Append Values**: Appends rows of data after the last row of a detected table in a sheet.
- **Batch Clear Values**: Clears cell values from multiple ranges in a single request while preserving formatting.
- **Batch Get Values**: Reads cell values from multiple ranges in a single request.
- **Batch Update Spreadsheet**: Applies one or more structural updates (add/delete/rename sheets, delete rows, merge cells, etc.) atomically.
- **Batch Update Values**: Writes values to multiple ranges in a single request.
- **Clear Values**: Clears cell values from a single range while preserving formatting and data validation.
- **Copy Sheet To Another Spreadsheet**: Copies a single sheet/tab from one spreadsheet to another.
- **Create Spreadsheet**: Creates a new spreadsheet with optional initial sheets/tabs and properties.
- **Delete Spreadsheet**: Permanently deletes a spreadsheet using the Google Drive API.
- **Get Spreadsheet**: Retrieves spreadsheet metadata and optionally cell data for specified ranges.
- **Get Values**: Reads cell values from a single range in a spreadsheet using A1 notation.
- **Update Values**: Writes values to a single range in a spreadsheet, overwriting existing data.

## Triggers (2)

- **New Row in Spreadsheet**: Triggers when a new row appears in a Google Sheets spreadsheet
- **Updated Row in Spreadsheet**: Triggers when an existing row changes in a Google Sheets spreadsheet

## Related prompts

- [Auto-refresh a Google Sheet from Databricks every night](https://www.generalinput.com/prompts/auto-refresh-a-google-sheet-from-databricks-every-night.md)
- [Log daily football results and league standings to Sheets](https://www.generalinput.com/prompts/log-daily-football-results-and-league-standings-to-sheets.md)
- [Daily IP reputation screening with Slack threat alerts](https://www.generalinput.com/prompts/daily-ip-reputation-screening-with-slack-threat-alerts.md)
- [Log every new Azure DevOps work item to Google Sheets](https://www.generalinput.com/prompts/log-every-new-azure-devops-work-item-to-google-sheets.md)
- [Daily data breach monitoring for key email accounts](https://www.generalinput.com/prompts/daily-data-breach-monitoring-for-key-email-accounts.md)
- [Morning team travel briefing with live flight alerts](https://www.generalinput.com/prompts/morning-team-travel-briefing-with-live-flight-alerts.md)
- [Air-freight shipment tracker with live flight alerts](https://www.generalinput.com/prompts/air-freight-shipment-tracker-with-live-flight-alerts.md)
- [Log an airport's daily departures to a Google Sheet](https://www.generalinput.com/prompts/log-an-airports-daily-departures-to-a-google-sheet.md)
- [Daily competitor price and promo watch for any website](https://www.generalinput.com/prompts/daily-competitor-price-and-promo-watch-for-any-website.md)
- [Auto-submit your weekly portal report from a spreadsheet](https://www.generalinput.com/prompts/auto-submit-your-weekly-portal-report-from-a-spreadsheet.md)
- [Daily Help Scout conversation log in Google Sheets](https://www.generalinput.com/prompts/daily-help-scout-conversation-log-in-google-sheets.md)
- [Daily Chargebee collections worklist for your AR team](https://www.generalinput.com/prompts/daily-chargebee-collections-worklist-for-your-ar-team.md)

Connect Google Sheets in General Input: https://www.generalinput.com/apps/google-sheets