Skip navigation
Sign up for free

Wrk Action Library

  Delete rows in Google Sheets
API
Delete a range of rows from a sheet of a Google Sheets spreadsheet. Inputs: Spreadsheet link, range start, and range end Outputs: None Outcomes: Success Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Retrieve data from a row in Google Sheets
API
Retrieve one or more fields from a row in a Google Sheets spreadsheet. Data should be organized as a table with column headers in the first row. Every row other than the headers represents a set of data to be captured. Please refer to the linked documentation for configuration details. Inputs: Spreadsheet link, row number, and fields to capture Outputs: Configured in the "Fields to capture" section Outcomes: Success or missing info Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Edit cell value in Google Sheets
API
Edit the value of a cell in a Google Sheets spreadsheet. Inputs: Spreadsheet link, value, column, and row Outputs: None Outcomes: Success Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Add column in Google Sheets
API
Add a new column into a sheet of a Google Sheets spreadsheet. New column name will be added as a header in the first row. Inputs: Spreadsheet link, new column name, and existing column location Outputs: None Outcomes: Success Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Retrieve row count from Google Sheets
API
Retrieve the number of the last row containing data from a sheet in Google Sheets. Inputs: Spreadsheet link Outputs: Last row number Outcomes: Success Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Delete duplicate values in Google Sheets
API
Remove duplicate records from a sheet of a Google Sheets spreadsheet. Please refer to the linked documentation for the required access permissions. Inputs: Spreadsheet link and column letters Outputs: None Outcomes: Success Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Search value location in Google Sheets
API
Find and return the first location of a specified value within a Google Sheets spreadsheet. Inputs: Spreadsheet link, search value, and column name Outputs: Row of the first result Outcomes: Success or no result Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result
  Retrieve data from Google Sheets
API
Retrieve data from a Google Sheet spreadsheet. Data should be organized as a table with column headers in the first row. Every row other than the headers represents a set of data to be captured. Inputs: Spreadsheet link and fields to capture Outputs: Configured in the "Fields to capture" section Outcomes: Success or missing info Requirements - The provided link to the sheet must have editing permissions. - All drives and sheets need to be shared with: googlewrkbots@wrk.com
$0.005 / result