Connect Open Government, Queensland Government and Zoho Sheet

Both apps 25Open Government, Queensland Government 11Zoho Sheet 14

• Trigger
  New dataset

  Fires when a new dataset is published on the Queensland Government open data portal.

• Action
  Find datasets by criteria

  Search datasets on the portal by keyword, tag, organization, or other facets.

• Action
  Find resources by criteria

  Search across all data resources by field/value criteria.

• Action
  Get dataset

  Retrieve the full metadata and resource list for a single dataset by its id or name.

• Action
  Get group

  Returns one thematic group of the Queensland open data catalogue by its short name, with its title, description and dataset count. The portal blocks its own group endpoint, so the group is read from a dataset search instead; a group with no datasets is reported as not found.

• Action
  Get organization

  Returns one publishing organisation of the Queensland open data catalogue by its short name, with its title, description and dataset count. The portal blocks its own organisation endpoint, so the organisation is read from a dataset search instead; an organisation with no datasets is reported as not found.

• Action
  Get resource

  Returns one published file or service of the Queensland open data catalogue by its file id, including its download link, format and size.

• Action
  List datasets

  Returns the short name of each dataset on the Queensland Government open data portal, up to 1000 per call.

• Action
  List groups

  Returns every thematic group datasets are filed under on the Queensland open data portal, with a dataset count for each. The portal blocks its own group-list endpoint, so the groups are read from the dataset search's grouped counts.

• Action
  List organizations

  Returns every publishing organisation on the Queensland open data portal, with a dataset count for each. The portal blocks its own organisation-list endpoint, so the organisations are read from the dataset search's grouped counts.

• Action
  List tags

  Returns the tags used to label datasets on the Queensland open data portal, optionally narrowed to tags containing given text or belonging to one vocabulary.

• Trigger
  New or Updated Row (WorkDrive)

  Triggers when a new row is added or an existing row is modified in a specified worksheet.

• Trigger
  New Row (WorkDrive)

  Triggers when a new row is created in a specified worksheet.

• Action
  Create Row

  Adds one or more rows to a worksheet in a Zoho Sheet workbook, matching values to columns by the header row.

• Action
  Create Row (WorkDrive)

  Adds one or more rows to a worksheet in a Zoho Sheet workbook (including workbooks stored in Zoho WorkDrive), matching values to the table's header columns.

• Action
  Delete Row

  Deletes a particular row based on its index.

• Action
  Delete Row (WorkDrive)

  Deletes a particular row based on its index.

• Action
  Search and Delete Row

  Deletes the row(s) in a Zoho Sheet worksheet that match a search criteria, removing them so the rows below move up.

• Action
  Search and Delete Row (WorkDrive)

  Finds the rows in a worksheet of a WorkDrive-stored Zoho Sheet workbook that match a search criteria and deletes them.

• Action
  Search and Update Row

  Searches and then updates a row based on some criteria.

• Action
  Search and Update Row (WorkDrive)

  Finds the rows in a Zoho Sheet worksheet (stored in WorkDrive) that match a criteria and updates them with new column values.

• Action
  Search Row

  Returns the rows of a Zoho Sheet worksheet that match the specified criteria.

• Action
  Search Row - Workdrive Users

  Returns the rows of a Zoho Sheet worksheet (stored in WorkDrive) that match the specified criteria.

• Action
  Update Row

  Updates one row of a Zoho Sheet worksheet, identified by its row number, with new values keyed by column header.

• Action
  Update Row (WorkDrive)

  Updates one row of a worksheet in a Zoho Sheet workbook stored in WorkDrive, identified by its row number, with new values keyed by column header.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.