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