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
$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
$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
$0.005 / result
  Add row of data in Google Sheets
API
Add a row of data at the end of a Google Sheets sheet. The data points and their destination columns will need to be specified. Please refer to the linked documentation for configuration details. Inputs: Spreadsheet link, columns and data assignments Outputs: None Outcomes: Success
$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
$0.005 / result
  Transpose data in Google Sheets
API
Transpose data in Google Sheets spreadsheets. Inputs: Spreadsheet link, range start, range end, and result cell start Outputs: None Outcomes: Success
$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
$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
$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
$0.005 / result
  Perform an API call in Google Sheets
API
Perform an API call in Google Sheets. Please refer to the API documentation for more details on configuration. API doc: https://developers.google.com/sheets/api/reference/rest Inputs: Endpoint and method Outputs: Response status code Outcomes: Success or unsuccessful
$0.005 / result
  Split text to columns in Google Sheets
API
Split the contents of a cell into different columns in a sheet of a Google Sheets spreadsheet. Inputs: Spreadsheet link, column name, and split delimiter Outputs: None Outcomes: Success
$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: Row number and configured in the "Fields to capture" section Outcomes: Success or missing info
$0.005 / result