capabilities.work

Tag and Find a Spreadsheet With Developer Metadata

A 3-step recipe with Google Sheets. We can help you get access.

Recipe · 3 steps

Tag and Find a Spreadsheet With Developer Metadata

with Google Sheets

Create a spreadsheet, tag it with developer metadata, and search for the tag.

  1. Create the spreadsheet and capture its generated spreadsheet ID.
  2. Attach a spreadsheet-scoped developer metadata key/value pair using a createDeveloperMetadata batchUpdate request.
  3. Search the spreadsheet for developer metadata matching the supplied key using a developerMetadataLookup data filter.
What you'll need to have ready
  • accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
  • title: The title to give the newly created spreadsheet.
  • metadataKey: The developer metadata key to attach and later search for.
  • metadataValue: The developer metadata value to associate with the key.
For your developer

Arazzo workflow google-sheets:tag-and-find-developer-metadata, 3 operations: createSpreadsheet → batchUpdateSpreadsheet → searchDeveloperMetadata. Specs on APIs.io.

More recipes with Google Sheets

Append Rows and Format the HeaderArchive and Clear Multiple RangesBulk Load Multiple RangesCopy a Sheet Between SpreadsheetsCreate and Seed a SpreadsheetCreate With an Extra Sheet and WriteCreate, Write, and VerifyOverwrite or Append RowsRefresh a RangeSeed a Range Only If Empty