Google Sheets API
Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Legge e scrive in Fogli Google.
Servizio: sheets.googleapis.com
Per chiamare questo servizio, ti consigliamo di utilizzare le librerie client fornite da Google. Se la tua applicazione deve utilizzare le tue librerie per chiamare questo servizio, utilizza le seguenti informazioni quando effettui le richieste API.
Documento di rilevamento
Un documento di rilevamento è una specifica leggibile da computer per descrivere e utilizzare le API REST. Viene utilizzato per creare librerie client, plug-in IDE e altri strumenti che interagiscono con le API di Google. Un servizio può fornire più documenti di rilevamento. Questo servizio fornisce il seguente documento di rilevamento:
Endpoint di servizio
Un endpoint di servizio è un URL di base che specifica l'indirizzo di rete di un servizio API. Un servizio può avere più endpoint di servizio. Questo servizio ha il seguente endpoint di servizio e tutti gli URI riportati di seguito sono relativi a questo endpoint di servizio:
https://sheets.googleapis.com
| Metodi |
batchUpdate |
POST /v4/spreadsheets/{spreadsheetId}:batchUpdate
Applica uno o più aggiornamenti al foglio di lavoro. |
create |
POST /v4/spreadsheets
Crea un foglio di lavoro e restituisce il foglio di lavoro appena creato. |
get |
GET /v4/spreadsheets/{spreadsheetId}
Restituisce il foglio di lavoro con l'ID specificato. |
getByDataFilter |
POST /v4/spreadsheets/{spreadsheetId}:getByDataFilter
Restituisce il foglio di lavoro con l'ID specificato. |
| Metodi |
copyTo |
POST /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
Copia un singolo foglio da un foglio di lavoro a un altro. |
| Metodi |
append |
POST /v4/spreadsheets/{spreadsheetId}/values/{range}:append
Collega valori a un foglio di lavoro. |
batchClear |
POST /v4/spreadsheets/{spreadsheetId}/values:batchClear
Cancella uno o più intervalli di valori da un foglio di lavoro. |
batchClearByDataFilter |
POST /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter
Cancella uno o più intervalli di valori da un foglio di lavoro. |
batchGet |
GET /v4/spreadsheets/{spreadsheetId}/values:batchGet
Restituisce uno o più intervalli di valori da un foglio di lavoro. |
batchGetByDataFilter |
POST /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter
Restituisce uno o più intervalli di valori corrispondenti ai filtri dati specificati. |
batchUpdate |
POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdate
Imposta i valori in uno o più intervalli di un foglio di lavoro. |
batchUpdateByDataFilter |
POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter
Imposta i valori in uno o più intervalli di un foglio di lavoro. |
clear |
POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear
Cancella i valori da un foglio di lavoro. |
get |
GET /v4/spreadsheets/{spreadsheetId}/values/{range}
Restituisce un intervallo di valori da un foglio di lavoro. |
update |
PUT /v4/spreadsheets/{spreadsheetId}/values/{range}
Imposta i valori in un intervallo di un foglio di lavoro. |
Salvo quando diversamente specificato, i contenuti di questa pagina sono concessi in base alla licenza Creative Commons Attribution 4.0, mentre gli esempi di codice sono concessi in base alla licenza Apache 2.0. Per ulteriori dettagli, consulta le norme del sito di Google Developers. Java è un marchio registrato di Oracle e/o delle sue consociate.
Ultimo aggiornamento 2025-07-25 UTC.
[null,null,["Ultimo aggiornamento 2025-07-25 UTC."],[],[],null,["# Google Sheets API\n\nReads and writes Google Sheets.\n\n- [REST Resource: v4.spreadsheets](#v4.spreadsheets)\n- [REST Resource: v4.spreadsheets.developerMetadata](#v4.spreadsheets.developerMetadata)\n- [REST Resource: v4.spreadsheets.sheets](#v4.spreadsheets.sheets)\n- [REST Resource: v4.spreadsheets.values](#v4.spreadsheets.values)\n\nService: sheets.googleapis.com\n------------------------------\n\nTo call this service, we recommend that you use the Google-provided [client libraries](https://cloud.google.com/apis/docs/client-libraries-explained). If your application needs to use your own libraries to call this service, use the following information when you make the API requests.\n\n### Discovery document\n\nA [Discovery Document](https://developers.google.com/discovery/v1/reference/apis) is a machine-readable specification for describing and consuming REST APIs. It is used to build client libraries, IDE plugins, and other tools that interact with Google APIs. One service may provide multiple discovery documents. This service provides the following discovery document:\n\n- \u003chttps://sheets.googleapis.com/$discovery/rest?version=v4\u003e\n\n### Service endpoint\n\nA [service endpoint](https://cloud.google.com/apis/design/glossary#api_service_endpoint) is a base URL that specifies the network address of an API service. One service might have multiple service endpoints. This service has the following service endpoint and all URIs below are relative to this service endpoint:\n\n- `https://sheets.googleapis.com`\n\nREST Resource: [v4.spreadsheets](/workspace/sheets/api/reference/rest/v4/spreadsheets)\n--------------------------------------------------------------------------------------\n\n| Methods ||\n|-----------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------|\n| [batchUpdate](/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdate) | `POST /v4/spreadsheets/{spreadsheetId}:batchUpdate` Applies one or more updates to the spreadsheet. |\n| [create](/workspace/sheets/api/reference/rest/v4/spreadsheets/create) | `POST /v4/spreadsheets` Creates a spreadsheet, returning the newly created spreadsheet. |\n| [get](/workspace/sheets/api/reference/rest/v4/spreadsheets/get) | `GET /v4/spreadsheets/{spreadsheetId}` Returns the spreadsheet at the given ID. |\n| [getByDataFilter](/workspace/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter) | `POST /v4/spreadsheets/{spreadsheetId}:getByDataFilter` Returns the spreadsheet at the given ID. |\n\nREST Resource: [v4.spreadsheets.developerMetadata](/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata)\n--------------------------------------------------------------------------------------------------------------------------\n\n| Methods ||\n|-----------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| [get](/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/get) | `GET /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}` Returns the developer metadata with the specified ID. |\n| [search](/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/search) | `POST /v4/spreadsheets/{spreadsheetId}/developerMetadata:search` Returns all developer metadata matching the specified [DataFilter](/workspace/sheets/api/reference/rest/v4/DataFilter). |\n\nREST Resource: [v4.spreadsheets.sheets](/workspace/sheets/api/reference/rest/v4/spreadsheets.sheets)\n----------------------------------------------------------------------------------------------------\n\n| Methods ||\n|------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------|\n| [copyTo](/workspace/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo) | `POST /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo` Copies a single sheet from a spreadsheet to another spreadsheet. |\n\nREST Resource: [v4.spreadsheets.values](/workspace/sheets/api/reference/rest/v4/spreadsheets.values)\n----------------------------------------------------------------------------------------------------\n\n| Methods ||\n|----------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------|\n| [append](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append) | `POST /v4/spreadsheets/{spreadsheetId}/values/{range}:append` Appends values to a spreadsheet. |\n| [batchClear](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClear) | `POST /v4/spreadsheets/{spreadsheetId}/values:batchClear` Clears one or more ranges of values from a spreadsheet. |\n| [batchClearByDataFilter](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClearByDataFilter) | `POST /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter` Clears one or more ranges of values from a spreadsheet. |\n| [batchGet](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGet) | `GET /v4/spreadsheets/{spreadsheetId}/values:batchGet` Returns one or more ranges of values from a spreadsheet. |\n| [batchGetByDataFilter](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGetByDataFilter) | `POST /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter` Returns one or more ranges of values that match the specified data filters. |\n| [batchUpdate](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate) | `POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdate` Sets values in one or more ranges of a spreadsheet. |\n| [batchUpdateByDataFilter](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdateByDataFilter) | `POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter` Sets values in one or more ranges of a spreadsheet. |\n| [clear](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/clear) | `POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear` Clears values from a spreadsheet. |\n| [get](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get) | `GET /v4/spreadsheets/{spreadsheetId}/values/{range}` Returns a range of values from a spreadsheet. |\n| [update](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/update) | `PUT /v4/spreadsheets/{spreadsheetId}/values/{range}` Sets values in a range of a spreadsheet. |"]]
