Google Sheets

spreadsheetId

The unique identifier of the Google Sheet to which data will be appended.

range

The range in the Google Sheet where new values will be appended.

valueInputOption

Specifies how the input data will be added to the sheet (e.g., USER_ENTERED, RAW).

insertDataOption

Defines how existing data is changed when new data is input (e.g., OVERWRITE, INSERT_ROWS).

includeValuesInResponse

If true, the response includes the values that were appended.

spreadsheetId

The ID of the spreadsheet that you want to update.

range

The A1 notation of the range in which you want to append values.

valueInputOption

Specifies how the input data should be interpreted (e.g., RAW or USER_ENTERED).

insertDataOption

Specifies how existing data is changed when new data is input (e.g., OVERWRITE or INSERT_ROWS).

includeValuesInResponse

Determines if the update response should include the values of the cells that were appended.

responseValueRenderOption

Determines how values in the response should be rendered.

responseDateTimeRenderOption

Determines how dates, times, and durations in the response should be rendered.

SPREADSHEET_ID

The ID of the spreadsheet containing the source and destination ranges.

SHEET_ID

The ID of the sheet where the copy and paste operation should occur.

spreadsheetId

The unique ID of the spreadsheet containing the sheet to be copied.

sheetId

The ID of the sheet in the source spreadsheet that will be copied.

destinationSpreadsheetId

The unique ID of the spreadsheet where the new copied sheet will be created.

access_token

OAuth 2.0 Bearer token used to authenticate the request; must have appropriate Google Sheets API scopes.

title

The title of the spreadsheet to create

spreadsheetUrl

The URL of the Google Spreadsheet from which the ID will be extracted.

resourceName

The resource name of the person to provide information about. Use 'people/me' to indicate the authenticated user.

personFields

A mask to restrict which fields on the person resource are returned. Must specify at least one field; multiple fields are separated by commas. If omitted, the API returns a 400 error.

sources

A comma-separated list specifying the data sources to return. Defaults to READ_SOURCE_TYPE_PROFILE and READ_SOURCE_TYPE_CONTACT if not set. Optional parameter.

resourceName

Resource name of the person to provide information about. To get data for the authenticated user, specify 'people/me'.

personFields

Field mask specifying which person fields to return, separated by commas. Required and must be at least one valid field (e.g., 'names,emailAddresses').

sources

Mask of what source types to return. If unset, defaults to profile and contact sources. Values should be provided as a repeated query parameter (sources=...).

resourceName

The resource name of the person to provide information about; use 'people/me' to refer to the authenticated user.

personFields

A field mask that selects which data fields are returned in the response (e.g., 'names,emailAddresses,photos'). Multiple fields are separated by commas and must be chosen from the API's allowed values.

spreadsheetId

The ID of the spreadsheet to retrieve metadata from.

metadataId

The ID of the developer metadata to retrieve.

access_token

The OAuth 2.0 access token used to authenticate and authorize the API request. This must be included as a Bearer token in the Authorization header, and must have the appropriate userinfo or OpenID scopes.

resourceName

The resource name of the person to provide information about. Use 'people/me' to indicate the authenticated user.

personFields

Specifies which fields on the person resource to return. Must be a comma-separated list of fields such as 'names,emailAddresses,photos'.

sources

Optional. Restricts returned sources. If omitted, defaults to profile and contact sources. Usually not required for basic profile details.

resourceName

The resource name of the person whose information is to be retrieved. For the current authenticated user, this must be 'people/me'.

personFields

Specifies which fields on the person resource to include in the response. Must be a comma-separated list of valid fields such as 'names', 'emailAddresses', and 'photos'. Omitting this will result in a 400 error.

personFields

A required comma-separated string specifying which person fields to include in the response. Must be a list of valid field names supported by the People API, such as 'names', 'emailAddresses', 'phoneNumbers', etc.

personFields

A comma-separated list of person field names specifying which fields to return for the person resource. At least one valid field name must be specified. Common values include 'names', 'emailAddresses', 'phoneNumbers', and 'addresses'.

access_token

The OAuth 2.0 access token used for authenticating the request, provided in the 'Authorization' header as 'Bearer <access_token>'. Must be a valid token with scope for People API.

resourceName

The resource name of the person whose profile is being retrieved; use 'people/me' to reference the currently authenticated user.

personFields

A comma-separated list specifying which fields to include in the response, such as 'names,emailAddresses'; must be non-empty or the request will fail with a 400 error. Allowed values are specific field names defined in the API.

Spreadsheet ID

The ID of the spreadsheet to retrieve data from

Range A1 Notation

The range of cells to read from, in A1 notation

spreadsheetId

The ID of the spreadsheet to be requested.

ranges

The ranges to retrieve from the spreadsheet using A1 notation.

includeGridData

If true, grid data should be returned. Ignored if a field mask is set.

spreadsheetId

The ID of the spreadsheet to retrieve.

dataFilters

The filters to select which ranges to retrieve.

includeGridData

Include grid data in the response if true.

spreadsheetId

The unique identifier for the spreadsheet from which to retrieve structure metadata.

spreadsheetId

The ID of the spreadsheet to retrieve values from.

range

The A1 notation of the range to retrieve values from.

url

The URL of the web page from which to retrieve structural metadata.

language

The preferred language for the structured data.

SPREADSHEET_ID

The ID of the spreadsheet containing the sheet to rename. This is found in the URL of the spreadsheet.

SHEET_ID

The ID of the specific sheet to rename within the spreadsheet. This can be obtained via the spreadsheets.get method.

newTitle

The new title for the sheet.

spreadsheetId

The ID of the spreadsheet from which to retrieve metadata.

dataFilters

The data filters that describe the criteria used to select which DeveloperMetadata entries to return.

spreadsheetId

The ID of the spreadsheet to apply updates to.

requests

A list of update requests to apply to the spreadsheet. Each request is executed in sequence.

includeSpreadsheetInResponse

Determines if the update response should include the spreadsheet resource.

responseRanges

Specifies the ranges included in the response spreadsheet. Applies only if includeSpreadsheetInResponse is true.

responseIncludeGridData

Indicates if grid data should be returned. Relevant only if includeSpreadsheetInResponse is true.