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.

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.

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.

resourceName

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

personFields

A field mask to restrict which fields on the person are returned. Example: 'names,emailAddresses,photos'. Valid field names must be comma-separated.

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.

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.

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.