Unprotect Sheet(Password Protected) in Office scripts

I am trying to unprotect my sheet so I can remove autofilter and delete some rows. My plan from there is to create a table in power automate so i can read it into Power Apps.

How can I unprotect my sheet?

I am running the below, I assume it isnt working due to not having the password in the code. How can I format this to accept a password?

function main(workbook: ExcelScript.Workbook) {

	let selectedSheet = workbook.getActiveWorksheet();
	selectedSheet.getProtection().unprotect();
	// Toggle auto filter on selectedSheet
	selectedSheet.getAutoFilter().remove();
	// Delete range 1:6 on selectedSheet
	selectedSheet.getRange("1:6").delete(ExcelScript.DeleteShiftDirection.up);
}

Error: Line 4: WorksheetProtection unprotect: The argument is invalid or missing or has an incorrect format. Again, I am assuming this is due to me not having the password in the script. I have the password but not sure where to input it.

I look at this example but no where to enter password .

https://stackoverflow.com/questions/64393820/protect-worksheet-in-office-scripts-with-options

Updated error:

error msg {
"message": "We were unable to run the script. Please try again.\nWorkbook not found.\r\nclientRequestId: b29bf86c-8a12-4ab3-b639-2350a0022b89",
"logs": []
}

any help would be appreciated.

In order to use additional parameters, you need to make the call from Power Automate but obviously, you first need to add the parameter to your script.

https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-parameters-returns

So for your script ...

function main(workbook: ExcelScript.Workbook, password: string) {
	let selectedSheet = workbook.getActiveWorksheet();
	selectedSheet.getProtection().unprotect(password);

	// Toggle auto filter on selectedSheet
	selectedSheet.getAutoFilter().remove();
	
	// Delete range 1:6 on selectedSheet
	selectedSheet.getRange("1:6").delete(ExcelScript.DeleteShiftDirection.up);
}

Once you've added it to your script, you can then reference it from PowerAutomate/LogicApps ...

Note: Your code to use the workbook.getActiveWorksheet() may bring you unstuck, I'd be more specific if I were you given it needs to be executed from PA/LA. Obviously, I am making an assumption that you have more than one worksheet in your workbook.